You have been asked to modify a database that tracks driver data and insurance details. You will update, add to, and delete records from tables. You will also create queries that aggregate data, find unmatched, and find duplicate values. Start Access. Open the downloaded Access file named . Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. Open the , observe the data, and then close the table. Create an update query based on the Drivers table. Include all of the fields from the table. Set the criteria to update drivers to . Run the query, save it as , and then close the query. Create a make table query based on the Drivers table. Include all of the fields from the table. Set the criteria to select drivers. The query should make a new table named in the current database. Run the query, save it as and then close the query. Make a copy of the and save it as . Change the query type to and append records to . Set the criteria to select drivers. Run, save, and then close the query. Set as the primary key field of the Non-Standard Drivers table. Save and close the table. Make a copy of the and save it as . Change the query type to . Set the criteria to select or drivers. Run, save, and then close the query. Create a crosstab query based on the Non-Standard Drivers table. Set as the row heading field and as the column heading field. Summarize the data by counting the DriverIDs. Save the query using the default name, and view the query results. Modify th
e query so that displays as the column heading and displays as the row heading. Save the query as and run the query. Modify the database (Non-Standard Drivers table) so that the gender displays as and displays as . Run the crosstab query again to display the changes. Close the query. Create a find duplicates query based on the Drivers table where there is a repeated LastName and Street value. Add the and to the query results. Save the query using the default name, and view the query results. Note that Eric and Kirk Abelson live at the same address, but have two different DriverIDs. In the Drivers table, expand the Subdatasheet for Eric and notice that he carries insurance for both household vehicles. Close the table and the query. Create an unmatched query to find drivers in the Drivers table who have no insurance listed in the Insurance table. Include all fields from the Drivers table. Save the query using the default name, and view the query results. For the driver named Lawrence Alexander, add a record to the Insurance table. Enter the InsuranceID number as , the DriverID as , and the Agent as . Populate the remaining fields (AutoType, AutoYear, TagID, and TagExpiration) with data of your choice. Close the table. Run the again. Note that Lawrence Alexander no longer appears in the results, as you have used the query to identify missing data and corrected the error. Kirk Abelson is covered under the same policy as Eric, his father. Close the query. Close all database objects. Close the database and then exit Access. Submit the database as directed.