Create an update query based on the Drivers table.

Posted: January 12th, 2023

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Exp19_Access_Ch06_Cap – Insurance 1.0
Exp19 Access Ch06 Cap Insurance 1.0 
Access Chapter 6 Capstone – Insurance  
EX19_AC_CH06_GRADER_CAP
  
Project Description:
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 Exp19_Access_Ch6_Cap_Insurance. 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 Drivers table, 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 Special   drivers to Senior.   Run the query, save it as Update Class,   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 Senior   drivers. The query should make a new table named Non-Standard   Drivers   in the current database.
 
Run   the query, save it as Make Non-Standard   Drivers   and then close the query.
 
Make   a copy of the Make Non-Standard   Drivers query and save it as Append Non-Standard   Drivers.
 
Change   the query type to Append and   append records to Non-Standard Drivers.   Set the criteria to select Minor   drivers. Run, save, and then close the query.
 
Set   DriverID as the primary key field   of the Non-Standard Drivers table. Save and close the table.
 
Make   a copy of the Append Non-Standard   Drivers query and save it as Delete Non-Standard   Drivers.
 
Change   the query type to Delete. Set the   criteria to select Minor   or Senior drivers. Run, save, and then close the   query.
 
Create   a crosstab query based on the Non-Standard Drivers table. Set Class as the row heading field and Gender 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   the query so that Class displays   as the column heading and Gender   displays as the row heading. Save the query as Non-Standard   Drivers_Crosstab and run the query.
 
Modify   the database (Non-Standard Drivers table) so that the gender M displays as Male and F displays as Female.   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 DriverID   and FirstName fields 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 10010,   the DriverID as 341890123,   and the Agent as AS8842.   Populate the remaining fields (AutoType, AutoYear, TagID, and TagExpiration)   with data of your choice. Close the table. Run the Drivers Without Matching Insurance query 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.

For This or a Similar Paper Click To Order Now

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00