Microsoft Access XP-2003 Foundation

Objectives
On completion of this course delegates will be able to:

Create simple databases
Work with records in tables
Edit and modify tables
Manipulate data by creating and modifying queries
Display and edit data using forms and reports
Create smaller more efficient tables by joining or relating
Course Content

Getting Started

An Overview of Access & Databases
Creating Tables

Creating tables using the Design View & the Table Wizard
Setting Field Names, Data Types & Primary Keys
Working with Tables

Record Navigation
Adding, Editing, Saving & Deleting Records
Setting Field Properties

Editing Tables

Changing height & width of rows/columns
Changing font attributes & cell effects
Selecting, moving, hiding, unhiding & freezing a column
Finding & Filtering Data

Using Simple Queries

Creating Queries using the Design View &
The Simple Query Wizard
Modifying Query Results

Sorting & Printing a Query
Adding Criteria to a Query
Creating Basic Forms

Creating a Form using the Forms Wizard &
AutoForm
Adding a Field to a Form
Creating Basic Reports

Creating a Report using the Reports Wizard
AutoReport
Printing & Grouping Reports

Working with the Office Assistant

Using the Office Assistant
Find an answer
Hide/Display the Office Assistant
Change Office Assistant Options
Using On Line Help

Modifying Tables

Inserting, Renaming & Deleting Columns
Creating Relationships

Using Operators in Queries

Using Comparison Operators & Wildcards
Advanced Queries

Setting Top Values in a Query
Creating & Formatting a Calculated Field
Creating Function Queries
Action Queries

Manipulating Controls

Editing Controls in a Form/Report
Using Editing Tools

Using the Design View

Adding Graphical Elements to a Form
Time Permitting Topics:

Appendix I

Using the Label Wizard
Appendix II

Importing & Exporting data to Excel