Access project

profiley73t20851
SampleDemoDB_General_Hardware_Co.accdb
Home>Information Systems homework help>Access project
Customer Number Customer Name HQ City Salesperson Number
121 Main St. Hardware New Yord 137
839 Jane's Stores Chicago 186
933 ABC Home Stores Los Angeles 137
1047 Acme Hardware Store Los Angeles 137
1525 Fred's Tool Store Atlanta 361
1700 XYZ Stores Washington 361
1826 City Hardware New York 137
2198 Western Hardware New York 204
2267 Central Stores New York 186
Office Number Telephone Size
1209 5553108 95
1227 5550364 100
1253 5554276 120
1284 5557335 120
Product Number Product Name Unit Price
16386 Wrench 13
19440 Hammer 18
21765 Drill 33
24013 Saw 26
26722 Pliers 12
Quantity Salesperson Number Product Number
473 19440
170 24013
688 26722
1745 16386
2529 19440
1962 21765
3071 24013
809 21765
734 26722
3729 16386
3110 21765
2738 26722
Salesperson Number Salesperson Name Commisson Percentage Year of Hire Office Number
137 Baker 10 1995 1284
186 Adams 15 2001 1253
204 Dickens 10 1998 1209
361 Carlyle 20 2001 1227