Database homework

ACLab1GardenNaturallyDatabase.accdb

Home >Computer Science homework help >Database homework

Customer Number	Customer Name	Address	City	State	Postal Code	Amount Paid	Balance Due	Sales Rep Number
AA30	All About Gardens	47 Berton St.	Greer	PA	19158	¤ 1,190.00	¤ 365.00	26
CT02	Christmas Tree Farm	483 Cantor Rd.	Pleasantburg	NJ	07025	¤ 2,285.50	¤ 825.35	29
GG01	Garden Gnome	10 Main St.	Gossett	PA	19157	¤ 1,300.00	¤ 297.50	29
GT34	Green Thumb Growers	26 Jefferson Hwy.	Pleasantburg	NJ	07025	¤ 3,325.45	¤ 865.50	32
LH15	Lawn & Home Store	33 Maple St.	Chambers	NJ	07037	¤ 895.00	¤ 515.00	26
ML25	Mum's Landscaping	196 Lincoln Ave.	Quaker	DE	19719	¤ 0.00	¤ 1,805.00	29
OA45	Outside Architects	234 Magnolia Rd.	Gaston	DE	19723	¤ 4,205.50	¤ 945.00	32
PL10	Pat's Landscaping	22 Main St.	Chesnee	NJ	07053	¤ 1,165.00	¤ 180.00	26
PN18	Pyke Nurseries	10 Grant Blvd.	Adelphia	PA	19159	¤ 2,465.00	¤ 530.00	32
SL25	Summit Lawn Service	345 Oaktree Rd.	Chesnee	NJ	07053	¤ 3,225.45	¤ 675.50	26
TG38	TriState Growers	24 Main St.	Gaston	DE	19723	¤ 1,075.00	¤ 0.00	29
TW34	TAL Wholesalers	234 Cantor Rd.	Pleasantburg	NJ	07025	¤ 4,125.00	¤ 350.00	26
TY03	TLC Yard Care	24 Berton St.	Greer	PA	19158	¤ 1,845.00	¤ 689.45	29
YS04	Yard Shoppe	124 Elm St.	Quaker	DE	19719	¤ 445.00	¤ 575.00	32
YW01	Young's Wholesalers	5239 Lancaster Hwy.	Adelphia	PA	19156	¤ 1,785.50	¤ 345.60	32

Sales Rep Number	Last Name	First Name	Address	City	State	Postal Code	Start Date	Commission Rate	Salary YTD
26	Jones	Pat	43 Third St	Greer	PA	19158	5/16/16	0.05	¤ 33,100.50
29	Gupta	Rufus	678 Hillcrest Rd.	Gossett	PA	19157	6/1/15	0.06	¤ 35,075.30
32	Ortiz	Gloria	982 Victoria Ln	Chesnee	NJ	07053	9/12/15	0.05	¤ 32,555.65
35	Sinson	Mike	45 Elm St.	Quaker	DE	19719	8/28/17	0.04	¤ 1,500.00

SELECT Customer.[Customer Number], Customer.[Customer Name], Customer.[Amount Paid], Customer.[Balance Due], Customer.[Sales Rep Number] FROM Customer;