None

1. The Basics

•           Getting Started
•           Signing In
•           Creating a Database
•           Database Terminology
•           Saving a Database
•           Opening a Database

2. Your First Database

•           About Security
•           Warnings   
•           About Relationships
•           Searching for Objects
•           Opening Database Objects
•           Changing the Object View
•           Understanding the Types of Views Available

3. Working with Tables and Records

•           Creating a Table
•           Understanding Table Views
•           Adding and Editing Records
•           Searching and Browsing Records
•           Deleting Records
•           Printing Records

4. Formatting Tables

•           Selecting Data
•           Changing Column and Row Width and Height
•           Applying Text Formatting
•           Applying Gridlines
•           Changing Fill Colors
•           Checking Your Spelling

5. Creating Forms

•           Creating a Form from an Object
•           Creating a Form with the Wizard
•           Creating a Form from Scratch
•           Understanding Form Views
•           Using a Form

6. Formatting Forms

•           Understanding Bound and Unbound Controls
•           Changing the Theme
•           Using the Format Painter
•           Adding Fields
•           Adding Controls
•           Adding Images and Logos
•           Review Questions

7. Creating Reports

•           Creating a Report from an Object
•           Creating a Report with the Wizard
•           Creating a Report from Scratch
•           Understanding Report Views
•           Printing Reports

8. Formatting Reports

•           Changing the Theme
•           Using the Format Painter
•           Grouping and Sorting Data
•           Adding Controls
•           Adding Images and Logos
•           Adding Page Numbers, Headers, and Footers

9. Creating Basic Queries

•           Types of Queries
•           Creating a Query with the Wizard
•           Running a Query
•           Understanding Query Views
•           Sorting and Filtering a Query

10. Creating Advanced Queries

•           Creating and Using Parameter Queries
•           Creating and Using Crosstab Queries
•           Creating and Using Make-Table Queries
•           Creating and Using Multiple Table Queries
•           Creating and Using Append Queries
•           Creating and Using Delete Queries
•           Creating and Using Update Queries

11. Managing Your Database

•           Compacting and Repairing a Database
•           Encrypting a Database with a Password
•           Backing Up Your Database
•           Exporting a Database and Database Objects
•           Printing Database Objects

12. Customizing the Interface

•           Collapsing and Pinning the Ribbon
•           Customizing the Quick Access Toolbar
•           Hiding and Showing Ribbon Tabs
•           Creating Custom Ribbon Tabs
•           Resetting Interface Changes

.

Course Days: 1 Day