Basic Access 2003 Tables Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number 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 (hours)
3.0
Lesson 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