Access 2003 Training (Basic)

Description:

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Access 2003. Students will learn how to plan and create a database, work with tables, create queries and forms, filter records, and generate reports. This course is approved courseware for Microsoft Office Specialist certification.

Outline:

• Unit 1: Getting started
  • Topic A: Database concepts
  • Topic B: Exploring the Access environment
  • Topic C: Getting help
  • Topic D: Closing a database and Access

• Unit 2: Databases and tables
  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables

• Unit 3: Fields and records
  • Topic A: Changing the design of a table
  • Topic B: Finding and editing records
  • Topic C: Organizing records

• Unit 4: Data entry rules
  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting validation rules
  • Topic D: Using indexes

• Unit 5: Simple queries
  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

• Unit 6: Using forms
  • Topic A: Creating forms
  • Topic B: Using the Form Wizard
  • Topic C: Using Design view
  • Topic D: Finding, sorting, and filtering records

• Unit 7: Working with reports
  • Topic A: Creating reports
  • Topic B: Modifying and printing reports

• Appendix A: Microsoft Office Specialist exam objectives map
  • Topic A: Comprehensive exam objectives

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.