Access Module I
Basic

Download Class
Data Files

Getting Started
Starting Access
Opening an Existing Database
Using Menu Commands
Displaying and Hiding Toolbars
Changing Menu and Toolbar Options
Using Database Objects
Using the Database Window Selecting Object Types
Opening a Database Object
Exiting Access

Getting Started
Creating Tables
Creating a New Database
Designing Tables
Creating a Table in Design View
Using Design View
Adding Field Names
Assigning Data Types
Adding a Field Description
Setting a Primary Key
Saving a New Table
Using the Table Wizard

Creating Tables
Working with Tables
Using Datasheet View
Navigating Fields in Tables
Adding Records
Moving through Records
Selecting Records
Editing Records
Saving Records
Deleting Records

Working with Tables
Setting Field Properties
Using Field Properties
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Yes/No Formats
Setting Default Values
Setting Validation Rules
Creating an Input Mask Wizard
Creating an Input Mask Manually
Creating a Custom Input Mask
Typing a Lookup List
Modifying Lookup Properties

Editing Tables
Changing the Row Height
Changing the Column Width Changing a Font Attribute
Changing a Cell Effect
Selecting a Column
Moving a Column
Hiding a Column
Unhiding a Column
Freezing a Column

Editing Tables
Finding and Filtering Data
Sorting Records
Finding Specific Records
Finding Records using Wildcards Using Replace
Using Filter By Selection Applying/Removing a Filter
Using Filter Excluding Selection
Using the Filter For Feature
Using Filter By Form
Finding and Filtering Data

Printing Data
Printing Table Data
Changing the Page Setup
Printing Selected Records
Printing Data

Using Simple Queries
Using Queries and RecordSets
Using the Simple Query Wizard Creating a Query in Design View
Opening a Query
Adding a Table to a Query
Joining Tables in a Query
Running a Query
Using Simple Queries

Creating Basic Forms
Using Forms
Using the Form Wizard
Viewing Records in a Form
Printing Records in a Form
Basing a Form on a Query
Using AutoForm
Adding a Record using a Form

Creating Basic Forms
Creating Basic Reports
Using Reports
Using the Report Wizard
Using Print Preview
Printing Pages of a Report
Grouping and Summarizing Report Data
Basing a Report on a Query
Using AutoReport
Creating Basic Reports

Working with the Office Assistant
Using the Office Assistant
Finding an Answer
Hiding/Displaying the Office Assistant Changing Office Assistant Options Working with the Office Assistant

Using Online Help
Working with Online Help
Viewing ScreenTips
Using Help Contents
Showing and Hiding the Help Tabs Using the Help Answer Wizard
Using the Help Index 
Using Online Help 
 

Access Module II
Intermediate

Download Class
Data Files

Creating Relationships
Using Related Tables
Creating a Relationship Between Tables
Setting Referential Integrity
Viewing Subdatasheets
Deleting a Join Line
Creating Relationships

Modifying Tables
Inserting a Column in a Table
Changing a Column Name
Deleting a Column
Inserting a Lookup Column
Inserting a Hyperlink Column
Creating a Many-to-Many Relationship
Modifying Tables

Modifying Query Results
Sorting a Query
Adding Criteria to a Query
Hiding a Field in a Query
Adding a Record using a Query
Printing a Query
Modifying Query Results

Using Operators in Queries
Using Comparison Operators
Using an And Condition
Using an Or Condition
Using the Between And Operator
Using the Expression Builder
Using a Wildcard Character
Using Operators in Queries

Manipulating Controls
Using Controls
Selecting Non-adjacent Controls
Selecting Adjacent Controls
Deleting Controls
Sizing a Control by Dragging
Moving Controls
Sizing Controls Automatically
Aligning Controls
Spacing Controls
Viewing the Properties of an Object
Changing a Control Property
Displaying the Field List
Adding a Field
Using the Toolbox
Manipulating Controls

Using Design View
Hiding the Ruler
Disabling the Snap to Grid Feature
Displaying the Field List
Adding a Field
Moving Part of a Paired Control
Aligning Controls
Spacing Controls
Using the Toolbox
Adding a Label
Adding an Image
Adding a Rectangle
Adding a Line
Editing an Unbound Control
Using Design View

Creating Action Queries
Creating a Make-table Query
Creating an Update Query
Creating an Append Query
Creating a Delete Query
Creating Action Queries

Using Advanced Query Wizards
Using the Crosstab Query Wizard
Using the Find Duplicates Query Wizard
Using the Find Unmatched Query Wizard
Designing Advanced Queries
Setting Top Values in a Query
Creating a Calculated Field
Formatting a Calculated Field
Creating a Function Query
Creating a Parameter Query
Creating a Concatenation in a Query
Filtering a Query
Designing Advanced Queries

Using Advanced Form Design
Using Forms in Design View
Creating a Combo Box
Creating a List Box
Creating an Option Group
Adding a Logic Control
Setting the Tab Order Automatically
Setting the Tab Order Manually
Adding a Form Header and Footer
Creating a Blank Form
Using Advanced Form Design

Using Advanced Report Design
Using Report Sections in Design View Creating a Calculated Control
Grouping Data in a Report
Creating Group Headers and Footers
Creating a Running Summary
Inserting a Date/Time Control
Inserting a Page Break
Changing the Report Margins
Using the Label Wizard
Creating a Report without Using a Wizard
Using Advanced Report Design

Access Module III
Advanced

Download Class
Data Files

Analyzing Tables
Analyzing a Table
Using Relationships in Splits
Using the Table Analyzer Wizard
Using the Performance Analyzer
Analyzing Tables

Using Advanced Database Features
Importing Data
Linking Data to an Access Table
Using the Linked Table Manager
Exporting Data
Converting Files
Printing a Relationship Document
Creating a Data Access Page-Page Wizard
Compacting a Database
Using Name AutoCorrect
Backing Up a Database
Using Advanced Database Features

Using Charts
Creating a Chart
Adding a Chart to a Form or Report
Activating Microsoft Graph to Edit
Changing the Chart Type
Changing the Chart Title
Formatting the Chart Title
Adding Data Labels to a Chart
Using Charts

Using Subforms/Subreports
Working with Subforms/Subreports
Creating a Subform/Subreport
Editing the Layout of a Subform
Displaying a Subform in Datasheet View
Displaying a Subform Total
Using Subforms/Subreports

Using Other Form Techniques
Adding a Command Button
Saving a Form as a Report
Creating a PivotTable or PivotChart
Using Other Form Techniques

Using ActiveX Controls
Working with ActiveX Controls
Registering an ActiveX Control
Adding an ActiveX Control
Attaching an ActiveX Control
Using ActiveX Controls

Working with Indexes
Viewing Indexes
Creating a Single Field Index
Creating a Multiple Field Index
Deleting an Index
Creating a Multiple Field Primary Key
Working with Indexes

Creating Macros
Working with Macros
Opening the Macro Design Window
Creating a Macro
Assigning an Argument to an Action
Saving a Macro
Using Single Step Mode for Testing
Running a Macro
Editing an Existing Macro
Running a Macro using the Tools Menu
Creating a Macro using the Macro Builder
Creating Macros

Using Macros
Using Properties
Assigning a Macro to a Control
Creating a Command Button
Adding a Condition to a Macro
Creating a Group Macro
Creating an Autoexec Macro
Using Macros

Using Switchboards
Opening and Using a Switchboard
Creating a Switchboard Form
Adding a Command Button to a  Switchboard
Setting Startup Options
Using Switchboards

Creating Custom Toolbars
Creating a Custom Toolbar
Adding a Built-in Menu Item
Creating a Custom Menu Item
Adding a Command to a Menu Item
Adding Custom Commands
Docking a Floating Toolbar
Linking a Toolbar to a Report
Adding a Separator Bar
Creating a Shortcut Menu
Linking a Custom Shortcut Menu
Adding Buttons to a Custom Toolbar
Changing a Button Image
Deleting a Custom Toolbar
Creating Custom Toolbars

Exporting Data to Excel and Word
Exporting Data to an Excel Workbook Dragging and Dropping Data into Excel
Creating Excel Workbooks - Office   Links
Creating Word Documents - Office Links
Exporting Data to Excel and Word

Replicating Databases
Replicating a Database
Synchronizing Database Replicas
Resolving Replication Conflicts
Replicating Databases