Length: 16 hours

Audience:

This course is designed for future users of MS-Access 2003 database management software, that don’t have basic knowledge about the use of this tool to create and use data bases.

Prerequisites:

A minimum experience in the use of personal computers under Windows 95/98/Me, Windows NT 4.0 Workstation, Windows 2000 Professional or Windows XP Professional operating system is required. The knowledge of another computer environment can be helpfull.

Course description:

This course provides basic elements need to create, to update and to query data base using MS-Access 2003 software.

Key topics:

• Data base concepts:

• Files and relational data base
• Fields and records
• Components and main dialog screen
• The use of an existing data base

• Tables

• Table creation and modifying its structure
• Adding new records in data base
• Displaying data
• Records selection
• Use of toolbar

• Data queries and views

• Select fields
• Sorting records
• Statistical operators on fields
• Use of toolbar

• Forms

• Masks
• Using template forms
• Create masks to print forms

• Reports

Use template reports,

Print of reports

• Data base with multiple tables