Microsoft Access 2003 Basic and Intermediate

Objective:

Participants will understand the concept of database. Using Access create tables, queries, forms and reports.

Course Outline

• 1. Introduction To Microsoft Access 2003

  • What Is Access?
  • What Is Database?
  • Creating Files
  • Starting Access 2003
  • Opening And Closing A Database File

  2. The Database Window

  • The Database Menu Bar
  • The Database Window Toolbar

  3. Tables

  • Create A Table
  • Working With Tables
  • Setting A Primary Key
  • Establishing Relationships
  • Working With Data Types
  • Inputmask Property

  4. Queries

  • Create A Query
  • Creating Parameter Queries
  • Creating Calculated Columns In Queries

  5. Forms

  • Using And Creating Forms
  • Working With Subforms

  6. Reports

  • Creating And Using Reports
  • Saving, Maintaining, And Printing Report