Microsoft Access 2007 - Intermediate
* Note : This course continues on from the first course - you will need to have completed the entire first course and assignments as you will be building on to these files.

Table of Contents
Working with Tables
Date Formulas
Short Date Format
Default Value
Input Mask
Creating a Form
Rulers & Grids
Form Header and Footer
Widening a Working Area
Rulers and Grids
Areas of a Form
Form Header Height
Labels
Selecting Labels
Fonts
Font Size
Text Formats
Center Align
Special Effects Shadow
Label Size
Moving a Label
Background Area
Fill/Background Color
Line Border Color
Fill/Foreground Color
Form View
Drawing Lines
Line Properties
Border Width
Field List
Inserting Fields
Deleting Field Labels
Tab Index Order
Uppercase Conversion
Calculating Fields
Form Height
Filter by Form
Filter Criteria
Apply Filter
Remove Filter
Creating a Query
Join Tables
Join Properties
Adding Fields to a Query Table
Datasheet View
Sorting Data
Query Criteria
Saving a Query
Opening a Query
Creating a Report
Page Headers
New Line Code
Pictures
Text Boxes
Text Box Properties
Sorting and Grouping
Selecting Multiple Fields
Multiple Pages
Page Setup
Copy
Paste
Sum Formula
Page Break
Date Formula plus 30 days