Microsoft Access XP-2003 Foundation

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

• Report Writing
• Writing Effective Letters & Emails

• Excel XP-2003: Level 1
• Word XP-2003: Level 1

The next course in this series is:

• Access XP-2003: Advanced

Relevant accreditations include:

• Microsoft Office Specialist: Core