Access

analyze_fitness.accdb

Home >Computer Science homework help >Access

Customer Number	Last Name	First Name	Street	Balance	Trainer Number
AB10	Alber	Terry	23 Castor Ave.	¤ 95.00	23
BR16	Breed	Alec	68 Passmore St.	¤ 84.00	25
FE45	Felton	Pat	346 Magee Ave.	¤ 105.00	27
GM52	Gammond	Pete	212 Levick St.	¤ 0.00	25
HJ07	Helker	Barbara	314 Oakley St.	¤ 64.00	23
KL12	Klinston	James	456 Levick St.	¤ 90.00	23
MA34	Marsden	Bob	57 Fanshawe St.	¤ 125.00	27
PR80	Pretzi	Nancy	134 Castor Ave.	¤ 50.00	25
SA23	Sanbourn	Mike	44 Rising Sun Ave.	¤ 110.00	27
TR35	Trent	Eric	167 Martin Rd.	¤ 0.00	25

Trainer Number	Last Name	First Name
23	Levin	Josh
25	Rodgers	Thad
27	Sinson	Mary

SELECT Customer.[Customer Number], Customer.[Last Name], Customer.[First Name], Customer.Street, Customer.Balance FROM Customer WHERE (((Customer.Street)="Levick"));

SELECT Customer.[Trainer Number], Customer.[First Name], Customer.[Last Name], Customer.Balance FROM Customer ORDER BY Customer.[Trainer Number], Customer.[Last Name];