1. SQL and Microsoft Access

• Importing Information
• Exporting Information
• Copying o and from Other Office Programs

2. Using the SELECT Statement

• Selecting All Data
•  Selecting Specific Data
•  Selecting Conditional Data
•  Using the ORDER BY Statement

3. Using SQL Joins

• Creating Simple Joins
•  Using an Alias
•  Sorting Joins
•  Creating Outer Joins

4. Using Subqueries

• What is a Subquery?
•  Creating a Subquery
•  Subqueries with Aggregate Functions and Nested Subqueries
•  Using the IN Keyword with Subqueries

5. Advanced Form Tasks, Part One

• Limiting User Access to a Form
•  Creating Checkboxes and Command Buttons
•  Building Command Button Events
•  Creating Event Procedures

6. Advanced Form Tasks, Part Two

• Using Hyperlinks in a Form
• Adding Links to Other Database Objects
• Inserting a Mailto Link in a Form
• Adding a Browser Control to a Form
• Performing Calculations in a Form

7. Advanced Form Tasks, Part Three

• Exporting Your Form to XML
• Exporting a Form as a Word Document
• Exporting a Form as HTML
• Sending a Form as an E-mail Attachment
• Exporting a Form to Other Formats

8. Creating Split Forms

• Creating a Split Form
• Splitting an Existing Form
• Using a Split Form
• Fixing the Form Separator

9.Using Digital Signatures

• What is a Digital Signature?
• Obtaining a Digital Signature
• Attaching Your Signature to a Database
• Extract and Use a Signed Database

10. Using the Trust Center

• Opening the Trust Center
• Trusting a Database
• Configuring Macro Security
• Customizing the Message Bar

11. Managing COM Add-ins

• Viewing Add-ins
• Opening the Add-in Manager
• Installing Add-ins
• Disabling All Add-ins
• Uninstalling Add-ins

12. Customizing Access

• Changing User Information
• Changing the Office Background and Theme
• Setting the Default Database Type and Location