Question: The data file quiz3.accdb 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.accdb 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 Security Warning Certain content in the delabase has been deatied Optons All Tables CustomerName Address City State 2ipOrders Fresh Air Goods Bird Outfitter River Kites Mountain Goods The Essential Surfer Backyard Supplies Nautical Gear Store Rainy Day Gear Kite Hut Bird Boutique 2200 Merchant streetDayton 453 Franklin Way S Elm Drive 5 Pine View way 1200 Markket Street 1 Sea Breeze Way 45 Main Street 342 Waterford Street Lansing 100 Seawind Drive 45 Mercury Bouleward Seattle OH 45439 $67,855.00 48301 $3,542.00 66549 $12,034.00 OR 97701 $7,456.00 ansing 0167 10178 10180 0190 0198 0210 10237 Bend Newport Beach CA 91178$5,342.00 San Diego CA 92118 $7,722.00 AZ 85207 $14876.00 MI48901 8,976.00 432.00 OH 45227 $6154.00 WA 45439 $9.110.00 Long Beach CA 92660 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 1. 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
Get step-by-step solutions from verified subject matter experts
