1. Introduction FREE CHAPTER

• Course Introduction and Structure

2. Modify Database Structure

• Import Objects or Data from Other Sources
• Delete Database Objects
• Hide and Display Objects in the Navigation Pane

3. Manage Table Relationships and Keys

• (Part 1) Understand Relationships
• (Part 2) Understand Relationships
• (Part 3) Understand Relationships
• (Part 4) Understand Relationships
• Display Relationships
• Set the Primary Key
• Enforce Referential Integrity
• Set Foreign Keys

4. Print and Export Data

• Configure Print Options for Records, Forms, and Reports
• Export Objects in Alternative Formats

5. Objective Domain 1 Exercises and Solutions

• Objective Domain 1 Exercises and Solutions

6. Create Tables

• Import Data into Tables
• Create linked tables from external sources
• Import tables from other databases

7. Manage Tables

• Hide Fields in Tables
• Add Total Rows
• Add Table Descriptions

8. Manage Table Records

• Find and Replace Data
• Sort Records
• Filter Records

9. Create and Modify Fields

• (Part 1) Add and Remove Fields
• (Part 2) Add and Remove Fields
• Add Validation Rules to Fields
• Change Field Captions
• Change Field Sizes and Data Types
• Configure Auto Increment and Set Default Values
• Apply Built-In Input Masks

10. Objective Domain 2 Exercises and Solutions

• Objective Domain 2 Exercise Solutions

11. Create and Run Queries

• Create Simple Queries
• Create Basic Crosstab Queries
• Create Basic Parameter Queries
• (Part 1) Create Basic Action Queries
• (Part 2) Create Basic Action Queries
• (Part 3) Create Basic Action Queries
• (Part 4) Create Basic Action Queries
• Create Basic Multi-Table Queries
• Save Queries
• Run Queries

12. Modify Queries

• Add, Hide, and Remove Fields, Sort and Filter Data
• Filter Data Within Queries

13. Objective Domain 3 Exercises and Solutions

• Objective Domain 3 Exercises and Solutions

14. Configure Form Controls

• Introduction to Forms
• (Part 1) Add, Move, and Remove Form Controls
• (Part 2) Add, Move, and Remove Form Controls
• (Part 3) Add, Move, and Remove Form Controls
• (Part 4) Add, Move, and Remove Form Controls
• (Part 5) Add, Move, and Remove Form Controls
• Add and Modify Form Labels

15. Format Forms

• Modify Tab Order on Forms
• Sort Records by Form Field
• Modify Form Positioning
• Insert Information in Form Headers and Footers
• Insert Images on Forms

16. Objective Domain 4 Exercises and Solutions

• Objective Domain 4 Exercises and Solutions

17. Configure Report Controls

• Introduction to Access Reports
• Group and Sort Fields on Reports
• Add and Modify Report Controls and Labels

18. Format Reports

• Format a Report into Multiple Columns
• Modify Report Positioning
• Format Report Elements
• Change Report Orientation
• Insert Information in Report Headers and Footers
• Insert Images on Reports

19. Objective Domain 5 Exercises and Solutions

• Objective Domain 5 Exercises and Solutions

20. Sample Exam

• Sample Exam Project 1
• Sample Exam Project 2
• Sample Exam Project 3
• Sample Exam Project 4
• Sample Exam Project 5
• Sample Exam Project 6

21. Associate Access 77-730 Optional Lectures

• Create a Blank Desktop Database
• Create a Database from a Template
• Compact and Repair a Database
• Back Up a Database
• Split a Database
• Encrypt a Database with a Password
• Recover Data from Backup
• Create a Table
• Create a Form
• Create a Form from a Template with Application Parts
• Create a Report Based on the Query or Table and in Design View
• Create a Report Using the Report Wizard