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
