Course Outline

Microsoft Access 2007 Level 2
This class is designed for people who are familiar with Access. Participants will learn to design multiple-table queries and to create expressions and parameters. The class covers optimizing tables for efficiency as well as importing and exporting data. The class teaches participants to use Access commands rather than wizards. 6 hours.
Course prerequisites: Access Level 1 or equivalent experience.

Table and Query Properties
Creating charts
Field size
Format and decimal places
Input mask
Caption
Default value
Validation rule and text
Required
Description
Top values Indexing and Lookups 

Indexing and Lookups
Multiple table design
Primary key
Indexed property
Multiple field index
Looking up key descriptions Expressions in Queries

Expressions in Queries
Expression builder
Numerical expressions
Formatting expressions
Date and time expressions
Text expressions
Sorting and criteria in expressions

Functions in Queries
Getting help with functions
If function
Date and time functions
Text functions Parameters in a Query 

Parameters in a Query
What is a parameter?
Multiple parameters
Data typing parameters
Criteria expressions with parameters
Recording parameters
Parameter as a field
Parameters in expressions field

Exporting and Importing Data 
Access databases
Excel spreadsheets
Word documents
Delimited ASCII
Fixed ASCII

Prerequisites:  Access Level One or equivalent experience.
Revised 1/21/2008
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600