Access 2003
Foundation Level |
Section One
Section Two
Section Three
Section Four |
The Fundamentals
Work with a Database
Find, Filter, and Format Data
Tables and Fields |
Enhanced Level |
Section One
Section Two
Section Three
Section Four
Section Five |
Work with Queries
Work with Forms
Work with Reports
Format Forms and Reports
Relational Databases |
Expert Level |
Section One
Section Two |
Work with Macros
Program Integration |
|
Foundation |
|
Section One - The Fundamentals |
Introduction to Databases
Open a Database
Use Menus and Toolbars
Fill Out Dialog Boxes
Keystroke and Right-click Shortcuts
Open and Modify Database Objects
Work with Multiple Windows
Tour of a Table
Add, Edit, and Delete Records
Tour of a Form
Tour of a Query
Tour of a Report
Preview and Print a Database Object
Select Data
Cut, Copy, and Paste Data
Use Undo
Check Spelling
Help from the Office Assistant
Use the What's This Button
Use the Zoom Box
Close a Database and Exit Access |
|
Foundation |
|
Section Two - Work with a Database |
Plan a Database
Use the Database Wizard
Create a Blank Database
Use the Table Wizard
Modify a Table and Use Data Types
Create a New Table from Scratch
Create a Query in Design View
Modify a Query
Sort a Query using Multiple Fields
Develop AND and OR Operators
Use the Form Wizard
Use the Report Wizard
Use the Mailing Labels Wizard
Database Object Management
File Management
Compact and Repair a Database
Convert an Access 97/2000 Database |
|
Foundation |
|
Section Three - Find, Filter, and Format Data
|
Find and Replace Information
Sort Records
Filter by Selection
Filter by Form
Create an Advanced Filter
Adjust Row Height and Column Width
Rearrange Columns
Change Gridline and Cell Effects
Freeze a Field
Hide a Column
Change the Datasheet Font |
|
Foundation |
|
Section Four - Tables and Fields |
| Understand Field Properties
Index a Field
Add a Primary Key
Insert, Delete, and Reorder Fields
Change a Field's Data Type
Use Field Descriptions
Add a Caption
Change a Field Size
Format Number Fields
Format Number Fields by Hand
Format Text Fields
Set a Default Value
Required Data Entry
Validate Data
Create an Input Mask
Create a Lookup Field
Create a Value List
Modify a Lookup List |
|
Enhanced |
|
Section One - Work with Queries |
Query Types
Create a Multiple Table Query
Create a Calculated Field
Use the Expression Builder
Use an IF Function
Summarize Groups of Records
Display Top or Bottom Values
Parameter Queries
Find Duplicate Records
Find Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make Table Queries
Update Queries |
|
Enhanced |
|
Section Two - Work with Forms |
Use AutoForm
Modify a Form
Add and Delete Fields
Move and Size Controls
Change the Tab Order
Work with Control Properties
Control Property Reference
Work with Form Properties
Form and Report Property Reference
Work with Multiple Controls
Add, Cut, Copy, and Paste Controls
Change a Control's Data Source
Create a Calculated Control
Change a Control's Default Value
Use the Control Wizard
Create a Sub-Form
Modify Sub-Forms |
|
Enhanced |
|
Section Three - Work
with Reports |
Use AutoReport
Modify a Report
Add and Delete Fields
Move and Size Controls
Page Margins and Orientation
Add Page Numbers and Dates
Report Sections
Group and Sort Records
Create Calculated Controls
Work with Section Properties
Use the Chart Wizard |
|
Enhanced |
|
Section Four - Format
Forms and Reports |
Format Fonts
Change Text Alignment
Use AutoFormat
Change Colours
Apply Special Effects
Use the Format Painter
Add Pictures and Lines
Align Controls
Change Format Properties |
|
Enhanced |
|
Section Five - Relational
Databases |
Understand Table Relationships
Create Relationships between Tables
Enforce Referential Integrity
Test, Print, and Delete Relationships
Understand Relationship Types |
|
Expert |
|
Section One - Work
with Macros |
Create and Run a Macro
Edit a Macro
Work with Macro Groups
Assign a Macro to an Event
Create Conditional Expressions
Assign to Keystroke Combinations |
|
Expert |
|
Section Two - Program
Integration |
Import Information
Export Information
Import from an Access Database
Link from an External Source
Analyse Records with Excel
Export Records to Word
Mail Merge Records to Word
Use Hyperlink Fields
Use OLE Object Fields |
|
