Your Office

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