Need Microsoft ACCESS
dylune
access_table.docxClient 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 |
26 |
|
CN2134 |
Jim |
Bowles |
1514 Oak |
Tacoma |
WA |
98401 |
253-555-2629 |
25 |
|
CN2152 |
Susan |
Jamie |
1424 W.28th street |
Tacoma |
WA |
98402 |
253-555-6542 |
26 |
|
CN1634 |
Karen |
Quo |
5436 Kensington |
Tacoma |
WA |
98402 |
253-555-4875 |
25 |
|
CN2214 |
Bill |
Simms |
3258 Brentwood |
Tacoma |
WA |
98401 |
253-555-0932 |
24 |
|
CN2331 |
Liz |
Timmons |
1862 Liberty |
Tacoma |
WA |
98402 |
253-555-2178 |
25 |
|
CN2147 |
Tim |
Dooley |
6523 Dooley |
Tacoma |
WA |
98401 |
253-555-9371 |
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 |
