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.