Basic Access 2003 Tables

Overview/Description
To create and modify tables in Access 2003

Target Audience


End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level

Prerequisites


Familiarity with the Microsoft® Office environment

Expected Duration


180 Minutes

Objectives :

Basic Access 2003 Tables

  • add a table to an Access database.
  • add a table using the Design and Datasheet views.
  • modify fields to define a table's features.
  • use masked input fields and apply indexing to fields.
  • create and modify a specific table in Access 2003.
  • manage the data in records.
  • identify the steps involved in creating the various types of relationships between tables.
  • modify table data and edit relationships between tables.
  • create a database containing relational tables in response to a business requirement.


    • Course Number: 125947_eng