Access Assignment
Use the input document to create two tables in Access. You are creating a database for a fitness club.
The tables in the input document are only data for creating the tables in Access. They are not an example of what the finished product will look like
The field names for creating the tables are in the first row of each table. They are in bold to distinguish them from the data in the rows below them. They will not be in bold in Access.
In each table, use the field that uniquely identifies each record as the primary key
Do not use the ID/AutoNumber field as the primary key. You will select a field from the input tables to be the primary key as described above
All of the fields will be text data type except the Number of Clients field which will be Number data type and Pay Rate which will be Currency data type
In the trainer table, use a caption for the Pay Rate field. The caption will be Hourly Pay.
The fitness club has 3 locations. You will add a lookup field call Location and use codes for the locations as the lookup values. The values are:
BR
CM
LS
Create a relationship between the tables and apply referential integrity
Client Table
|
CLINET NUMBER
|
FIRST NAME
|
LAST NAME
|
ADDRESS
|
CITY
|
STATE
|
ZIP
|
PHONE NUMBER
|
TRAINER NUMBER
|
|
CN2314
|
Brenda
|
Kee
|
123 Main
|
Tacoma
|
WA
|
98401
|
253-555-1212 253-555-1212 FREE253-555-1212253-555-1212 FREE
|
26
|
|
CN2134
|
Jim
|
Bowles
|
1514 Oak
|
Tacoma
|
WA
|
98401
|
253-555-2629253-555-2629 FREE253-555-2629253-555-2629 FREE
|
25
|
|
CN2152
|
Susan
|
Jamie
|
1424 W.28th street
|
Tacoma
|
WA
|
98402
|
253-555-6542253-555-6542 FREE253-555-6542253-555-6542 FREE
|
26
|
|
CN1634
|
Karen
|
Quo
|
5436 Kensington
|
Tacoma
|
WA
|
98402
|
253-555-4875253-555-4875 FREE253-555-4875253-555-4875 FREE
|
25
|
|
CN2214
|
Bill
|
Simms
|
3258 Brentwood
|
Tacoma
|
WA
|
98401
|
253-555-0932253-555-0932 FREE253-555-0932253-555-0932 FREE
|
24
|
|
CN2331
|
Liz
|
Timmons
|
1862 Liberty
|
Tacoma
|
WA
|
98402
|
253-555-2178253-555-2178 FREE253-555-2178253-555-2178 FREE
|
25
|
|
CN2147
|
Tim
|
Dooley
|
6523 Dooley
|
Tacoma
|
WA
|
98401
|
253-555-9371253-555-9371 FREE253-555-9371253-555-9371 FREE
|
24
|
Trainer Table
|
Trainer number
|
First name
|
Last name
|
Address
|
City
|
State
|
Zip
|
Number of clients
|
Pay rate
|
|
24
|
Lucy
|
Leman
|
5847 Washington
|
Tacoma
|
WA
|
98402
|
2
|
20.00
|
|
25
|
Brain
|
Kasey
|
1827 35th street
|
Tacoma
|
WA
|
98401
|
3
|
25.00
|
|
26
|
Ken
|
Jacobs
|
6309 Brogan
|
Tacoma
|
WA
|
98402
|
2
|
20.00
|