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.