Question: Create a New Table in the database. Add the following fields to the new table: Field Type Field Name Short Text Battery Capacity Short Text

Create a New Table in the database. Add the following fields to the new table: Field Type Field Name Short Text Battery Capacity Short Text Vehicle Make Short Text Vehicle Model Short Text Vehicle Year Currency Purchase Price Currency Selling Price Number Mileage Change the ID field Name (Default record ID assigned by Access) to E-Vehicle ID. Save the table with Table Name "E-Vehicle Inventory" Add the following records to the table: (Note: When adding these records, the E-Vehicle ID field will automatically number each record so you do not need to enter anything into the E-Vehicle ID field.) Battery Capacity Vehicle Make Vehicle Model Vehicle Year Purchase Price Selling Price Mileage 98 kWh Ford F150 Lightning 2022 $50,000.00 $75,000.00 9000 88 kWh Ford Mustang Mach-E 2021 $40,000.00 $55,000.00 15550 78 kWh Tesla Model 3 2016 $25,000.00 $30,000.00 35117 112 kWh Audi eTron 2022 $110,000.00 $135,000.00 250 90 kWh KIA EV-6 2022 $45,000.00 $50,000.00 22000 Sort the table by the Selling Price field, in Ascending order. Filter the table to only show vehicles with the Vehicle Year of 2022. Compact, Repair, and Save your database

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 Accounting Questions!