Covert RAR files to Access

profilelatice1
chapter_1_lab1.rar
Home>Computer Science homework help>Covert RAR files to Access

Chapter 1 lab1/Dartt Offsite Services.accdb

Amount Paid Balance Due Client Number Client Name Street City State Postal Code Service Rep Number
¤ 3,524.00 ¤ 567.85 BBF32 Babbage CPA Firm 464 Linnell Dr. Austin SC 28796 24
¤ 4,445.65 ¤ 750.00 BCC76 Buda Community College 867 Ridge Ave. Buda NC 27032 21
¤ 0.00 ¤ 2,295.55 BMS53 Bavant Medical Services 134 Main St. Burles NC 28817 21
¤ 3,000.00 ¤ 1,100.50 CDS29 Carter Dental Services 123 Second St. Granger NC 27036 37
¤ 2,435.65 ¤ 1,345.75 GAD74 Grant Antique Dealers 78 Catawba Dr. Georgetown NC 28794 24
¤ 0.00 ¤ 6,500.00 GCF56 Granger City Foundation 65 Simpson Dr. Granger NC 27036 21
¤ 3,209.25 ¤ 1,210.87 HCH10 Hendley County Hospital 216 Rivard Blvd. Austin SC 28796 37
¤ 1,225.45 ¤ 895.95 KDS21 KAL Design Studio 116 Pine St. Georgetown NC 28794 24
¤ 2,345.45 ¤ 0.00 KGC04 Kyle Grocery Cooperative 421 First St. Kyle SC 28798 21
¤ 1,267.95 ¤ 989.75 MES14 Mike's Electronic Stop 234 Gilham St. Georgetown NC 28794 37
¤ 0.00 ¤ 2,367.25 PJN34 Patricia Jean Nursery 345 Magee Ave. Kyle SC 28798 37
¤ 3,800.00 ¤ 0.00 SLA77 Smarter Law Associates 764 Main St. Burles NC 28817 21
¤ 2,750.00 ¤ 1,200.00 TVS17 Theon Veterinary Services 346 Austin Ave. Buda NC 27032 37
¤ 1,567.45 ¤ 1,100.50 WEC05 Walburg Energy Company 12 Polk St. Walburg NC 28819 24
¤ 2,250.00 ¤ 1,600.00 WSC01 Wood Sports Complex 578 Central Ave. Walburg NC 28819 24
Last Name First Name Street City State Postal Code Start Date Monthly Salary Service Rep Number
Kelly Jenna 25 Paint St. Kyle SC 28797 5/14/12 ¤ 3,862.45 21
Scott Josh 1925 Pine Rd. Byron SC 28795 4/28/14 ¤ 3,062.08 45
Liu Mia 265 Marble Dr. Kyle SC 28797 1/7/13 ¤ 3,666.67 24
Martinez Mike 31 Steel St. Georgetown SC 28794 5/13/13 ¤ 3,285.00 37
SELECT Client.[Client Number], Client.[Client Name], Client.[Amount Paid], Client.[Balance Due], Client.[Service Rep Number] FROM Client;
SELECT DISTINCTROW * FROM Client;