Populating the Database

· If you are in Design View (the field name and properties appear), then click on the Datasheet button. Otherwise, just double-click the tables name in the main dialog. This will take you to the Datasheet view, where you can see the table you’ve just designed. You will notice that it looks similar to Excel. Like a spreadsheet, clicking on a cell and type in the information to enter data. You can switch between Datasheet and Design Views by the button- on the toolbar. On the main dialog box, double click on the Student table. This brings up the empty student table.

• Type in the following student entries. After a row has been entered Access will automatically create a new row.

· Save the table entries.

· Enter the following data for the tables.

Table: Course

CID Course Name

003 Physics-01

045 Database

810 English

Table: Professor

PID First Name Last Name

001 Adam Hollioake

002 Ben Hollioake

004 Jeff Donahoo

Table: Takes

SSN CID

1234 003

1234 045

1267 003

2000 003

2000 810

1345 045

Table: Taught

PID CID

001 003

002 003

004 045

001 810

Main | Prev | Next