Session 1

Section A: Understanding Access

• What Is Access?
• Access vs. Excel
• Components, Objects, and Terms
• Changes In 2007

Section B: Getting Started

• Application Overview
• Using Templates
• Using the Ribbon
• The Navigation Pane
• Shortcut to Forms
• Finding Help

Section C: Using the Navigation Pane Effectively

• Group View Options
• Item View Options
• Organizing Items
• Navigation Options
• Table Views
• Query and Form Views
• Report and Macro Views

Section D: Data Entry

• Working with Records
• Entering and Editing Records Data
• Deleting Records
• Sorting Data In Records
• Finding Data in Records
• Entering Data In Forms

Section E: Database Design

• Design Steps
• Purpose
• Tables
• Fields
• Relationships
• Primary Key
• Making the Relationship
• Naming Conventions
• Design Cleanup
• Example: Purpose and Tables
• Example: Primary Key and Relationships

Section F: Creating Databases and Tables

• Create Blank Database
• Datasheet View
• Saving Tables
• Table Templates

Session 2

Section A: Working with Tables

• Design View
• Text and Memo Data Types
• Number Data Types
• AutoNumber Data Types
• Yes/No Data Types
• Data Beyond the Database
• Creating Tables
• Setting Primary Keys

Section B: Field Properties

• Field Properties Overview
• Modifying Fields
• Text Field Properties
• Number Field Properties
• Validation Rules
• Arranging and Deleting Fields
• Viewing Changes
• Validation Text
• More Field Properties
• Memo Fields
• Attachment Fields
• Input Masks

Section C: Lookup Fields

• Creating Lookups
• Design View Lookups
• Lookup Properties

Section D: Relationship Theory

• Relationship Basics
• Beyond Relationship Basics
• Relationship Types
• Putting Relationship Theory Together

Section E: Creating Relationships

• Viewing Relationships
• Building and Modifying Relationships
• Relationship Reports
• Joining Table Properties

Section F: Analyzing Design

• Cleaning Up
• Formatting Datasheets
• Hiding Columns
• Rearranging Fields
• Performance Analyzer

Section G: Subdatasheets and Filters

• Adding Subdatasheets
• Subdatasheet Display
• Removing Subdatasheets
• Filtering by Selection
• Number Filtering
• Filtering by Form
• Advanced Filters
• Total Row Summaries

Session 3

Section A: Query Basics

• Query Wizard
• Selecting Data Sources
• Selecting Fields
• Sorting Fields
• Arranging Fields
• Criteria
• Comparison Criteria
• Range Criteria

Section B: Intermediate Queries

• Field Properties
• Query Properties
• Unique List
• Outputting All Fields
• Removing Tables
• Multiple Table Queries
• Query Relationships

Section C: Calculation in Queries

• Adding Fields
• Calculation Fields
• Null Values
• Totals
• Expression Builder

Section D: Special Queries

• Crosstab Queries
• Modifying Crosstab Queries
• Finding Duplicate Records
• Finding Unmatched Records
• Parameter Queries
• Range Parameters
• SQL View

Section E: Action Queries

• Updating Queries
• Creating Table Copies
• Creating Table Queries
• Saving Action Queries
• Archiving Records
• Deleting Queries
• Deleting Tables

Section F: Concatenation

• What is Concatenation?
• Concatenating Data
• Reviewing Concatenation
• Concatenation Examples

Session 4

Section A: Importing/Exporting Data

• Importing Data
• Importing Objects
• Importing from Excel
• Making Changes
• Exporting Data
• Add-Ins
• Save as PDF or XPS

Section B: Using Mail Merge

• Introduction
• Mail Merge Wizard
• Creating a Merge Letter
• Sharing Outlook Contacts
• Importing Outlook Folders
• Collaboration

Section C: Basic Forms

• Lookup Tables
• Form Wizard
• Form Tools
• Layout View

Section D: Form Controls

• Design View
• Controls
• Move Controls
• Selecting Multiple Controls
• Arranging Controls

Section E: Form Design

• Font Formatting
• Conditional Formatting
• Control Types
• Query by Form
• Check Boxes
• Bind Controls
• Properties

Section F: Special Forms

• Split Forms
• Subforms
• Subform Relationships
• Creating Subforms
• PivotTable Forms
• Calculations
• Filtering PivotTables

Section G: Reports

• AutoReports
• Report Wizard
• Grouping and Sorting
• Adding Pictures
• Page Breaks
• Label Wizard
• Charts

Session 5

Section A: Controlling Display and Data Entry

• Form Properties
• Display Options
• Data Entry Options
• Lock Controls
• Bang and Dot Operator
• Query Aliases
• Query Parameters
• Dynamic Reports

Section B: Access Automation

• Remove Grouping
• Control Wizard
• Switchboard Manager
• Edit Switchboard Pages
• Edit Main Switchboard
• Customize Switchboards

Section C: Custom Automation

• Overview
• Unbound Forms
• Add Record
• Message Box
• Close Form
• Close Database
• Modal Dialog Form

Section D: Working with the File

• Custom Navigation Pane
• Arranging Objects
• Database Properties
• Access Options
• Current Database Options
• Compact and Repair
• Back Up Database
• Database Splitter
• Linked Table Manager

Section E: Security

• Security Types
• Password Protection
• User-Level Permissions
• Creating User-Level Permissions
• Security Tips
• Section F: Sharing Information
• Printing Tables
• Printing Forms
• Printing Reports
• Output as File
• Database Documenter
• Save as Previous Version