Description

This book offers full, comprehensive coverage of Access. Ideal for business courses.

 

Make Microsoft Office, Your Office

The Your Office series prepares you to use both technical and soft skills in the real world. Our modern approach weaves the technical content into realistic business scenarios and focuses on using Office as a decision-making tool. Students learn best by doing, so you will be active from page 1. There is plenty of guidance at first, but the case exercises will ask more from you as the book progresses. Innovative features help you progress from a basic understanding to mastery of each application, empowering you to perform with confidence in Windows 8, Word, Excel, Access, and PowerPoint, even on mobile devices. No matter what career path you’re on, the Your Office series will give you the foundation to succeed.

 

Also available with MyITLab

MyITLab is an online homework, tutorial, and assessment program designed to work with this text to engage students and improve results. Within its structured environment, students practice what they learn, test their understanding, and pursue a personalized study plan that helps them absorb course material and understand difficult concepts.

 

 

Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. MyITLab is not a self-paced technology and should only be purchased when required by an instructor. If you would like to purchase both the physical text and MyITLab, contact your Pearson representative.

 

Features

About The Book

 

Features for active learning help students learn by doing, and immerse them in the world of Microsoft Office.

• Workshop Objectives list: the learning objectives to be achieved as students work through the workshop. Page numbers are included for easy reference. These are revisited in the Concepts Check at the end of the workshop.
• Active text box represents the active portion of the workshop and helps students quickly identify what steps they need to follow to complete the workshop Prepare Case. This is easily distinguishable from explanatory text by the blue shaded background. Active Text
• Starting and ending files: these appear before every case in the text. Starting Files identify exactly which Student Data Files are needed to complete each case. Ending Files are provided to show students the naming conventions they should use when saving their files. Each file icon is color coded by application.
• Side note conveys a brief tip or piece of information aligned visually with a step in the workshop, quickly providing key information to students completing that particular step.
• Consider This offers critical thinking questions and topics for discussion, set apart as a boxed feature, allowing students to step back from the project and think about the application of what they are learning and how these concepts might be used in the future.
• Soft Skills icons appear with other boxed features and identify specific places where students are being exposed to lessons on soft skills.

 

Study aids help students review and retain the material so they can recall it at a moment’s notice.

• Quick Reference boxes summarize generic or alternative instructions on how to accomplish a task. This feature enables students to quickly find important skills.
• Concept Check review questions appear at the end of the workshop, which require students to demonstrate their understanding of the objectives.
• Visual Summary offers a review of the objectives learned in the workshop using images from the completed solution file, mapped to the workshop objectives with callouts and page references, so students can easily find the section of text to refer to for a refresher.
• MyITLab™ icons identify which cases from the book match those in MyITLab™.
• Blue Box Video icons appear with each Active Text box and identify the brief video, demonstrating how students should complete that portion of the Prepare Case.

 

The real world focus reminds students that what they’re learning is practical and useful the minute they leave the classroom.

• Real World Success features in the workshop opener share anecdotes from real former students, describing how knowledge of Office has helped them get ahead or be successful in his or her life.
• Real World Advice box offers notes on best practices for general use of important Office skills. The goal is to advise students as a manager might in a future job.
• Business Application Icons appear with every case in the text and clearly identify which business application students are being exposed to, i.e., Finance, Marketing, Operations, etc.
• Real World Interview Video icons appear with the Real World Success Story in the workshop opener and feature a real businessperson discussing how he or she actually uses the skills in the workshop on a day-to-day basis.

 

 

Also available with MyITLab

The way students discover Micr

New to this Edition

New to the Your Office Series:

• New Mobile Computing Workshop & Touch Guide Appendix prepare students for a more mobile, collaborative workplace and feature exciting changes in mobile technology that prove that your office is no longer just a desk within four walls. 
• Real World Success Stories at the beginning of each workshop share anecdotes from real students and recent graduates describing how knowledge of Office has helped him or her to get ahead or be successful in his or her life.
• Real World Interview Video Icons are paired with the Real World Success Story in the workshop opener and features an interview of a real business person discussing how he or she actually uses the skills in the workshop on a day-to-day basis.
• Business Application Icons appear with every case in the text and clearly identify which business application students are being exposed to, ex. Finance, Marketing, Operations, etc.
• New Blue Box Videos come with each Blue Box in the workshop and demonstrate how students complete that particular skill and why the skill is applied in the context of the case.
• Soft Skills Icons identify specific parts of the workshop where students are being exposed to lessons on soft skills, which tie in with new Soft Skills videos.
• More Consistent Case Line-Up:
• Workshops all conclude with Practice, Problem Solve, and Perform Cases at the end of workshops to allow full mastery at the workshop level.  Alternative versions of each of these cases are available in Instructor Resources. 
• Module Capstones all include More Practice, Problem Solve, and Perform Cases that require students to synthesize objectives from the two previous workshops to extend their mastery of the content.  Alternative versions of each of these cases are available in Instructor Resources. 
• New Perform in Your Team Cases require students to collaborate to complete assignments.
• More Grader Projects offered with this edition, which include Problem Solve cases at both the workshop and module capstone levels.   
• MOS Certification Guide for instructors and students to direct anyone interested in prepping for the MOS exam to the specific series resources to find all content required for the test.

 

Also available with MyITLab

The way students discover Microsoft Office 2013 should be just as easy—and just as cool—as it is to work in our new cloud-based, accessible, streamlined interface.

 

To help you move your students to this new environment, we've enhanced MyITLab for Office 2013 with powerful new features and the latest Office 2013 content. MyITLab enables the most open, realistic, high-fidelity simulations of Office applications to help students understand concepts more thoroughly. And, coming from Pearson, you can be confident you have an experienced partner that is committed to providing the content, resources, and expertise for the best digital learning tools–now and into the future.

 

With MyITLab for Office 2013, you’ll be able to:

• Offer Office 2013 training and tutorials in a new, easy-to-use design
• Engage students with new cloud-based, HTML5 Office 2013 simulations that mirror the content in your Pearson textbook, do not require any downloads or installations, and can be translated into 8 languages
• Extend learning in, and beyond, the classroom—the Pearson eText and all simulations are fully compatible with any tablet, laptop, or iPad®
• Empower all students to experience MyITLab using cont

Table of Contents

Contents

Common Features

Common Features WORKSHOP 1: The Common Features of Microsoft Office

PREPARE CASE: Painted Paradise Resort and Spa Employee Training Preparation

Working with the Office Interface
Understand Office Applications and Accounts
Start Office Programs and Manipulate Windows
Use the Office Ribbon, Contextual Tools, and Other Menus
Manipulating Files and Finding Help in Office
Manage Files in Office
Get Help
Understanding the Cloud and Touch Integration
Use Windows SkyDrive
Use Touch Mode, Gestures, and Reading Mode

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Perform in Your Life

 

Access Module 1-Understanding and Using a Relational Database

Access WORKSHOP 1: The Four Main Database Objects

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament

Understanding Database Basics and Tables
Understand what Access Is
Maneuvering in the Navigation Pane
Understand what a Table Is
Manually Navigate a Database
Understanding Queries, Forms, and Reports
Understand what a Query Is
Understand what a Form Is
Understand what a Report Is
Backing Up Your Database
Compact and Repair a Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 2: Tables, Keys, and Relationships

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament Database

Inserting Data into a Database
Importing Data from Other Sources
Manual Data Entry
Understanding Tables and Keys
Creating a Table in Design View
Understand Masks and Formatting
Understanding and Designating Keys
Understanding Relational Databases
Understanding Basic Principles of Normalization
Understanding Relationships
Create a One-to-Many Relationship
Create a Many-to-Many Relationship
Understanding Referential Integrity

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 1 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 2-Accessing, Maintaining, and Presenting Information

Access WORKSHOP 3: Queries and Data Access

PREPARE CASE: Turquoise Oasis Spa Data Management

Work With Datasheets
Find and Replace Records in the Datasheet
Modify Datasheet Appearance
Queries
Run Other Query Wizards
Create Queries in Design View
Sort Query Results
Define Selection Criteria for Queries
Create Aggregate Functions
Create Calculated Fields

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 4: Access Information from an Access Database

PREPARE CASE: Turquoise Oasis Spa's New Database

Creating Customized Forms
Navigate in datasheets and forms
Update Table Records Using Forms
Create a Form Using the Form Wizard
Modify a Form’s Design
Creating Customized Reports
Create a Report Using the Report Wizard
Use and Customize Access Themes
Modify a Report’s Design
Save a Report as a PDF File

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 2 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 3-Ensuring Consistent Data and Advanced Querying

Access WORKSHOP 5: Advanced Tables

PREPARE CASE: The Red Bluff Golf Club: Modifying Database Tables

Controlling the Way Data Is Entered: Advanced Field Options
Understand Input Masks
Use Custom Formatting
Define Data Validation Rules
Work with Captions
Create Indexes
Use the Required Data Property
Define Default Values
Advanced Data Types
Create Lookup Fields
Use the Calculated Data Type
Use the Yes/No Data Type
Use AutoNumbers and Determining Preferences for Natural Keys
Use the Attachments, Hyperlinks, and OLE Objects Data Types
Filtering Data
Create Filters
Using the Table Analyzer Wizard
Normalize a Table

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 6: Pattern Matching and Functions in Queries

PREPARE CASE: The Red Bluff Golf Club: Creating Queries

Working with Advanced Criteria and Calculations
Wildcard Characters in String Comparisons
Find Records with the “Most” or “Least” Values
Make a Parameter Query Ask for Input
Concatenate Strings Using the & Operator
Use Advanced Query Operators
Using Advanced Functions in Queries
The IIf Function
The IsNull Function
Date Functions
The Round Function

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 3 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 4-Leveraging Queries for Business Information and Intelligence

Access WORKSHOP 7: Aggregated Calculations, Subquerying, and SQL

PREPARE CASE: The Turquoise Oasis Spa Database: Querying with Advanced Calculations

Understanding the Group By Aggregate Function in Aggregated Calculations
The Group By Clause
Summarize Data
Summarize Duplicate Data
Understanding the Where Aggregate Function in Aggregated Calculations
Where Aggregate Function
Business Calculations Using Subquerying
Subqueries
Percentage of Sales Revenue
Percentage of Sales Volume
Physical Volume
Percentage of Physical Volume
Understanding Structured Query Language
SQL Statements
SELECT Statement Basics
Create a Basic SQL Query
The WHERE Clause
The ORDER BY Clause
The HAVING Clause with AS and GROUP BY
The INNER JOIN and OUTER JOIN Clauses
The Union Query
The SQL Subquery
Creating a Crosstab Query
Crosstab Query Wizard

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 8: Action Queries and Advanced Relationships

PREPARE CASE: The Turquoise Oasis Spa: Understanding Action Queries

Understanding Action Queries
Create a New Table Using a Make Table Query
Append Data to a Table
Edit and Delete Data
Create, Test, and Run Delete Queries
Advanced Relationships Using Multiple Tables
Inner Joins
Outer Joins
Use the Find Unmatched Query Wizard

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 4 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 5-Producing Professional Forms and Reports

Access WORKSHOP 9: Advanced Form Settings and Form Types

PREPARE CASE: Enhancing Data Entry at the Red Bluff Golf Club

Working with Form Properties
Define Bound and Unbound Forms
Modify the Form Property Sheet
Using Advanced Form Modification
Modify the Form Header
Modify the Form in Design View
Creating Advanced Forms
Create Specialized Forms
Create a Multipage Form Using Tab Controls

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 10: Advanced Reports and Mailing Labels

PREPARE CASE: Enhancing Database Reports at the Red Bluff Golf Club

Creating Customized Reports
Use the Summary Options in Report Wizard
Modify the Report in Design View
Selecting and Modifying Controls in Design View
Change Report Properties
Add and Remove Fields from a Report
Use the Group, Sort, and Total Pane
Add Labels and Shapes to a Report
Modify Calculated Fields in a Report
Creating Parameter Reports
Create a Parameter Report
Use Conditional Formatting in a Report
Creating Mailing Labels
Create Mailing Labels

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 5 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 6-Building a Refined User Interface and Experience

Access WORKSHOP 11: Develop Navigation Forms and the User Interface

PREPARE CASE: Turquoise Oasis Spa Database

Creating Navigation Forms
View a Navigation Form
Create a Navigation Form
Modify a Navigation Form
Refining the User Interface
Create a Main Menu
Add Command Buttons to the Navigation Form
Set Start-Up Display Options
Test the Application

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 12: Create a Refined User Experience with Macros

PREPARE CASE: The Turquoise Oasis Spa Database: Automating Tasks and Increasing Functionality

Understanding the Purpose of Macros
Modify Database Settings for Protection from Macro Viruses
Understand the Macro Designer
Understand How to Test and Troubleshoot Macros
Increase Efficiency and Usability of a Database by Automating Tasks
Improve Database Design and Function by Automating Manual Processes
Reduce Processing Time by Combining Routine Tasks
Create Macro Groups
Create Macros That Run When the Database Opens
The Benefits of Embedded Macros
Increase Functionality of Forms and Reports
Implement Complex Business Rules with Data Macros

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 6 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 7-Implementing and Automating a Database with VBA

Access WORKSHOP 13: Use VBA In Access

PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

Introducing VBA Basics
Understand the Functionality of VBA in Access
Convert an Existing Macro to VBA
Edit and Structure VBA Procedures
Create and Use Loops in VBA
Adding VBA to an Access Database
Create VBA Procedures
Use Comments to Document VBA Procedures
Debug the VBA in a Database and Add Error Handling
Compiling and Securing Your VBA
Compile VBA Modules
Secure VBA in a Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 14: Implement Your Database

PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

Implementing a Database
Shared and Exclusive Modes
Prepare a Database for a Single User
Compatibility Between Versions of Access
Prepare a Database for Multiple Users
Encryption and Passwords
Setting the User’s Experience
Control Startup Options
Methods of Implementation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 7 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Appendix A: Efficient Interaction with a Touchscreen

PREPARE CASE: Painted Paradise Resort and Spa Works with Touch Features

Interacting with a Windows 8 Tablet PC

Understand Variations in Tablets

Understand Methods for Interacting with a Tablet PC

Using the Touch-Screen Interface

Use Flick, Touch, and Bezel Gestures

Use Office 2013 Touch Gestures

Use Other Touch Features

Concept Check

Key Terms

 

Appendix B: Normalize a Database for Effective Design

PREPARE CASE: The Terra Cotta Brew Coffee Shop Designing a Normalized Database

Normalizing a Database
Types of Anomalies
The First Normal Form
The Second Normal Form
The Third Normal Form
Join Tables Together in Relationships with Referential Integrity
Understanding an Entity Relationship Diagram

Concept Check

Key Terms

Visual Summary

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

How Others Perform