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.EX19_AC_CH06_GRADER_CAP_AS_Instructions.docx
Grader – Instructions Access 2019 Project
Exp19_Access_Ch06_Cap – Insurance 1.0
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.
Steps to Perform:
Step
Instructions
Points Possible
1
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.
0
2
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.
8
3
Set the criteria to update
Special drivers to
Senior. Run the query, save it as
Update Class, and then close the query.
6
4
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.
10
5
Run the query, save it as
Make Non-Standard Drivers and then close the query.
4
6
Make a copy of the
Make Non-Standard Drivers query and save it as
Append Non-Standard Drivers.
4
7
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.
6
8
Set
DriverID as the primary key field of the Non-Standard Drivers table. Save and close the table.
4
9
Make a copy of the
Append Non-Standard Drivers query and save it as
Delete Non-Standard Drivers.
4
10
Change the query type to
Delete. Set the criteria to select
Minor or
Senior drivers. Run, save, and then close the query.
6
11
Create a crosstab query based on the Non-Standard Drivers table. Set
Class as the
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.