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
