Building a Database
and the Files in the Database

in Microsoft Access 2000

Database name: VideoStore

Filenames: Customers, Videos, Employees

1) Create the Database

Blank Access Database

Enter database filename: VideoStore

2) Create the a table (file) in the database

Be sure that Tables is highlighted (to the left)

Create table in Design View

Create the structure of the table (file): Enter the field names and the field types

File

Save

Enter the filename – Customers

primary key? – respond yes

File

Close

Repeat these steps two more times in order to create the next two tables (files) in the VideoStore database: Videos and Employees

3) Fill the database structure with data

Double click on the table (file) you wish to fill with data.

Enter the data.

File

Save

File

Close

Repeat this for all three tables (files) in your VideoStore database.