Module 1: Customizing Tables in access 2007
Understanding Field Properties
Adding a Primary Key to a Table
Indexing a Field
Inserting, Deleting, and Moving Fields
Importing a Table from another Source

Module 2: Formatting Records in access 2007
Modifying Fonts
Using AutoFormat
Using the Formatting Ribbon

Module 3: Formatting Tables in access 2007
Formatting Number Fields
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types

Module 4: Controlling Table Data Entry in access 2007
Setting a Default Value
Setting a Required Value
Creating and Using Input Masks
Creating and Removing Table Relationships

Module 5: Managing Table Data Entry in access 2007
How to Validate Data
Creating a Lookup Field
Modifying a Lookup Field
Creating a Value List
Modifying a Value List

Module 6: Basic Form Controls in access 2007
Adding a Control
Using the Control Wizard
Cutting, Copying, Pasting, and Moving a Control
Formatting a Control

Module 7: Advanced Form Controls in access 2007
Modifying a Control’s Properties
Changing a Control’s Data Source
Changing a Control’s Default Value
Creating a Calculated Control
Using Form Properties

Module 8: Formatting Your Form in access 2007
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout

Module 9: Formatting Controls in access 2007
Changing the Colour of a Control
Using Control Properties
Aligning Controls
Applying Special Effects

Module 10: Organizing Report Data in access 2007
Adding and Removing Fields
Using Report Sections
Changing Section Properties
Grouping and Sorting in a Report
Changing Group Properties
Using Calculated Controls in a Report

Module 11: Formatting Reports in access 2007
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Using AutoFormat
Common Report Tasks
Adding a Photo
Adjusting Page Properties
Adding Headers and Footers
Adding Page Numbers
Using the Label Wizard

Module 12: Basic Queries in access 2007
Review of Queries
Creating a Query
Sorting a Query
Filtering a Query
Hiding Fields
Using AND OR Operators
Use of IIF Functions

Module 13: Multiple Table Queries in access 2007
Creating a Multiple Table Query
Creating a Calculated Field
Using the Expression Builder
Using Queries to Summarize

Module 14: Using Advanced Queries in access 2007
Creating a Parameter Query
Using Parameter Queries
Creating Crosstab Queries
Using Crosstab Queries
Using Make-Table Queries

Module 15: Action Queries in access 2007
Append Queries
Delete Queries
Update Queries

Exporting Queries