MP9002: Desktop Computing - Designing and Building Tables > Access 2003

This course shows learners how to use Access 2003 to design and build tables and an index. It also covers working with fields, primary keys, and records. 

Topics:
Understanding database terminology
Working with fields
Differentiating flat files and relational databases
Building a database
Creating tables
Organizing with a primary key
Building table relationships
Creating an index
Opening databases and tables
Adding, modifying, and deleting records

Objectives:
Build a simple database
Create and open a table
Set up a primary key
Build relationships between tables
Create an index
Add, modify and delete records

Duration:
3 Hours