Question: The data file quiz3.acedb or quiz3.mdb is a Microsoft Access database file and has one database table Customer. The Customer table consists of the followinng

 The data file quiz3.acedb or quiz3.mdb is a Microsoft Access database

The data file quiz3.acedb or quiz3.mdb is a Microsoft Access database file and has one database table Customer. The Customer table consists of the followinng fields: ID CustomerName Address City State Zip Orders Home Creale External Dala Dabese Tools Ac Datesheet _dseve ?seeing ? ??Advanced . Fter Rich Text Records Sort & FRer Security Werning Certan content in the datsbese has been dieatled Optin All Tables Address City, mill State ..ap .?. Orders Fresh Air Goods Bird Outfitter River Kites Mountain Goods The Essential Surfer Backyard Supplies Nautical Gear Store Rainy Day Gear Kite Hut Bird Boutique Freddy's surf shop Dayton 2200 Merchant Street 453 Franklin Way 5 Elm Drive 55 Pine View Way OH 45439 $67,855.00 MI 48901 3,542.00 66549 $12,034.00 OR 97701 $7,456.00 1200 Market Street Newport Beach CA 91178 5,342.00 10125 10134 10167 10178 10180 10190 10198 10210 10237 Riverview Bend IL 1sea Breeze Way 45 Main Street 342 Waterford Street 100 Seawind Drive 45 Mercury Boulevard San Diego CA 92118 $7,722.00 Lansing Long Beach CA 92660 Seattle Kirkland AZ 85207 $14,876.00 M 48901 $8,976.00 45200 OH 45227$6,354.00 WA 45439$9.130.00 Record M Input data file: quiz3.accdb or quiz3.mdb (Microsoft Access database file) Assumption: The number of records in quiz3.accdb or quiz3.mdb is unknown. You are required to develop a Java program to: I. 2. 3. Read data records from the Customer table into a data structure of your choice. Allow the user to display all records sorted in alphabetical order by CustomerName. Allow the user to search records by State

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!