Computer Science > DISCUSSION POST > Drivers and Insurance 2021 (All)
Drivers and Insurance 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 repeating values. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access database named exploring_a06_Grader_a1. Save the database as exploring_a06_Grader_a1_LastFirst. 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 NonStandard 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 NonStandard Drivers. 4 Step Instructions Points Possible 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 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. 8 12 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. 6 13 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. 6 14 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. 11 15 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. 11 16 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 with appropriate data. 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. 6 17 Save the database. Close the database, and then exit Access. Submit the database as directed. 0 Total Points 100 [Show More]
Last updated: 1 year ago
Preview 1 out of 2 pages
*NURSING> DISCUSSION POST > NR 603 Discussion; Cardiovascular Week 3 Case (All)
NR 603 Week 3 Case Discussion; Cardiovascular What leads demonstrate the ST depression? Is Lorene Hypertensive per ACA 2017 Guidelines? Compare the ACA guidelines to JNC 8 Guidelines and discuss wha...
By Amanda Rosales , Uploaded: Mar 04, 2021
$7
*NURSING> DISCUSSION POST > NR 507 Week 3 Discussion. Congestive Heart Failure. (All)
A 64-year-old woman presents to the primary care office with shortness of breath, leg swelling, and fatigue. She has a history of type 2 diabetes and hypertension. She reports that recently she had...
By Academia1434 , Uploaded: Oct 24, 2020
$9.5
*NURSING> DISCUSSION POST > NR565 / NR 565 Advanced Pharmacology Of Nursing Discussion. Q & A (Latest Update). NR 565 Chamberlain College (All)
Discussion Questions & Answers for NR565
By quiz_bit , Uploaded: Jan 02, 2021
$9
*NURSING> DISCUSSION POST > NR 503 Week 4 Open Forum Discussion | Already GRADED A (All)
You can use this time to have a non-structured conversation about the web site exploration links below. Provide one fact or element from the web site exploration that applies to the topics from the fi...
By A+ Solutions , Uploaded: Feb 02, 2022
$7
*NURSING> DISCUSSION POST > NR-503 Week 5 Discussion: Open Forum Discussion (All)
All students are required to make one post. You are not required to provide reply posts. You can use this time to have a non-structured conversation from the Podcast and web site links below. Provi...
By A+ Solutions , Uploaded: Feb 02, 2022
$7
*NURSING> DISCUSSION POST > NR 534 Week 1 Discussion: Creating a Philosophy of Leadership: Part 1 Individual, Part 2 With Your Group (RATED A) (All)
Part 1: Individual Whether or not it is written or verbally articulated, everyone has an idea or belief system about leadership that influences their behavior as a leader and a follower. Many factor...
By A+ Solutions , Uploaded: Feb 02, 2022
$5
*NURSING> DISCUSSION POST > NR 503 Week 7 Discussion: Global and Environmental Health – Disease Outbreaks Globally (All)
Please go to a lay press newspaper, for example, The Washington Post, The New York Times, or other national publication. Locate an article that has global health implications, such as malaria, untreat...
By A+ Solutions , Uploaded: Feb 02, 2022
$18.5
*NURSING> DISCUSSION POST > NR-503 Week 6 Discussion: Open Forum Discussion (All)
All students are … to make one post. You are not … to provide reply posts. You can use this time to have an unstructured conversation about genetics, current population health news or other course...
By A+ Solutions , Uploaded: Feb 02, 2022
$5
*NURSING> DISCUSSION POST > NR 503 Week 8 Discussion: Health Policy and Ethics – Maryland (All)
Go to your state government web page. Find one health policy enacted within the last two (2) years at the state level. Write down the bill number and the sponsors of the bill and include this informa...
By A+ Solutions , Uploaded: Feb 02, 2022
$18
*NURSING> DISCUSSION POST > NR 507 Advanced Pathophysiology Week 3 Discussion 2; Congestive Heart Failure. Chamberlain College of Nusrsing (All)
NR 507 Advanced Pathophysiology Week 3 Discussion 2; Congestive Heart Failure. Chamberlain College of Nusrsing Jesse is a 57-year-old male who presents with gradual onset of dyspnea on exertion and f...
By Academia1434 , Uploaded: Oct 24, 2020
$9.5
Connected school, study & course
About the document
Uploaded On
Oct 03, 2021
Number of pages
2
Written in
This document has been written for:
Uploaded
Oct 03, 2021
Downloads
0
Views
80
Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students
Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.
Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality
Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·