Microsoft Access 2C: Lookup Data From Another Table: Lookup Wizard, Delete Relationships

Relational Database:

In this assignment you will see the benefits of a relational database as opposed to simple database programs.

School Database:

One of the tasks in a school database is to assign each student to a particular class.

One way of doing this would be to have a field in tblStudents for class (but of course students take more than one class).

You could have several fields in tblStudent (eg. class1, class2 etc.)

This is one way of entering the data.

Another (better) way is to create a seperate table called tblTimetable where there is droplist that allows you to select a student, and another to select a class.

Why is this better (you will see later).

Lookup Values:

You have created lookup values (droplists) previously in section 1, however you had to key in the entries (e.g. Mr. Mrs. and Ms.) to create the drop list.

You can create a lookup value (droplist) where you don't have to key in what will appear in the droplist--it will come from a table.

In this assignment you will create a droplist to select a student, however instead of keying in 1,000 names for the droplist the droplist will get the data from the table tblStudents.

This will make more sense as you actually do the assignement.

The advantage of using a droplist which gets the data from another table is that everytime you enter a new name in tblStudents, the droplist will then contain the new student which can be selected in a different table.

 

This website is copyright protected see contact page for details.