Additional Instructions for CS 115 Access Project – Professor Toffler

The tables you create in the project are as follows:

Passenger Table Data Type Size

PassengerID AutoNumber N/A (Key Field)

Name Text 50

Address Text 40

City Text 20

State Text 2

ZipCode Text 5

Note: N/A means not applicable. In the case of field size, certain data types have fixed lengths. This is true for AutoNumber and Date/Time data types. The default length of an AutoNumber is “Long Integer”.

Flight Table Data Type Size

FlightID Number N/A (Key Field, not an “AutoNumber” in this case)

Origin Text 35

DepartureTime Date/Time N/A

Destination Text 35

Arrival Time Date/Time N/A

Cost Currency N/A

Booking Table Data Type Size

BookingID AutoNumber N/A (Key Field)

PassengerID Number N/A

FlightID Number N/A

* Note that the Primary Keys from the Passenger Table and Flight Table are included in the Booking Table in order to link the Tables for Query purposes.

You need to link the tables together using the “relationships” tool. Under the “Tools” menu (top of page in Access), select “Relationships”. You will see a window with your three tables displayed. Connect the PassengerID in you Passenger Table with the PassengerID in the Booking Table. Connect the FlightID in the Flight Table with the FlightID in the Booking Table. See picture below