{"id":32688,"date":"2022-02-14T02:27:29","date_gmt":"2022-02-14T02:27:29","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/drivers-and-insurance-computer-science-homework-help\/"},"modified":"2022-02-14T02:27:29","modified_gmt":"2022-02-14T02:27:29","slug":"drivers-and-insurance-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/drivers-and-insurance-computer-science-homework-help\/","title":{"rendered":"Drivers and insurance | Computer Science homework help"},"content":{"rendered":"
\n

I need access database urgently \u00a0<\/p>\n

Drivers and Insurance<\/strong><\/p>\n

Project Description:\u00a0<\/strong><\/p>\n

In this project, you will add fields \u00a0to a table and set data validation rules. You will also import a text file \u00a0into a database, design advanced queries, and create a navigation form. \u00a0Additionally, you will use SQL to modify a record source and create an \u00a0embedded macro to automate opening a report.<\/em><\/p>\n

Instructions:\u00a0<\/strong><\/p>\n

For the purpose of grading the project you are required \u00a0to perform the following tasks:\u00a0<\/p>\n

\u00a0\u00a0\u00a0<\/p>\n

Step<\/strong><\/p>\n

Instructions<\/strong><\/p>\n

Points Possible<\/strong><\/p>\n

\u00a0<\/p>\n

1<\/strong><\/p>\n

Start Access. Open the file named exploring_a_capstone_grader.accdb<\/em>. \u00a0\u00a0\u00a0Save the database as exploring_a_capstone_grader_LastFirst<\/strong>.<\/p>\n

0<\/p>\n

\u00a0<\/p>\n

2<\/strong><\/p>\n

Create a table in the database by \u00a0\u00a0\u00a0importing the downloaded delimited text file named Insurance_Text.txt<\/em>. Use the first row of the file as field \u00a0\u00a0\u00a0names, use InsuranceID as the primary key, and then name the table InsuranceCos_Text<\/strong>. \u00a0\u00a0\u00a0Accept all other default options. Do not save the import steps.<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

3<\/strong><\/p>\n

Create a new field in the Agency \u00a0\u00a0\u00a0Info table after InsPhone named Web site <\/strong>with the Hyperlink data type. Save \u00a0\u00a0\u00a0the table. In Datasheet view, add the Web site http:\/\/William_Smith.com<\/strong> to \u00a0\u00a0\u00a0the
William Smith<\/em> record (1).<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

4<\/strong><\/p>\n

Create a new field in the Agency \u00a0\u00a0\u00a0Info table after Web site named AgentPhoto<\/strong> with the Attachment data type. \u00a0\u00a0\u00a0Save the table. In Datasheet view for Record 1 (William Smith<\/em>), add the downloaded picture file named a00c2WmSmith.jpg<\/em> to the AgentPhoto \u00a0\u00a0\u00a0field.<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

5<\/strong><\/p>\n

Set the validation rule of the \u00a0\u00a0\u00a0InsuranceCo field to accept the values AS<\/strong>, NAT<\/strong>, or SF<\/strong> only. Set the validation \u00a0\u00a0\u00a0text to read Please \u00a0\u00a0\u00a0enter AS, NAT, or SF.<\/strong> (include the period).<\/p>\n

7<\/p>\n

\u00a0<\/p>\n

6<\/strong><\/p>\n

Make InsuranceCo a lookup field in \u00a0\u00a0\u00a0the Agency Info table. Set the lookup to get values from the InsuranceID \u00a0\u00a0\u00a0field in the InsuranceCos_Text table. Accept all other defaults and save the \u00a0\u00a0\u00a0table. In Datasheet view, click in \u00a0\u00a0\u00a0any InsuranceCo cell and click the arrow to view the options. Close the \u00a0\u00a0\u00a0table.<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

7<\/strong><\/p>\n

Create a new query using Design \u00a0\u00a0\u00a0view. From the Insurance table, add the DriverID, AutoType, TagID, and \u00a0\u00a0\u00a0TagExpiration fields (in that order). Save the query as Missing Tag Dates<\/strong>.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

8<\/strong><\/p>\n

Set the criteria in the \u00a0\u00a0\u00a0TagExpiration field to find null values. Run the query (two records will \u00a0\u00a0\u00a0display). Save and close the query.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

9<\/strong><\/p>\n

Create a new query using Design \u00a0\u00a0\u00a0view. From the Drivers table, add the Class field. Change the query type to \u00a0\u00a0\u00a0Update and set the criteria to update drivers whose class is Minor<\/strong> \u00a0\u00a0\u00a0to Junior<\/strong>. \u00a0\u00a0\u00a0Run the query (eight records will update). Save the query as Driver \u00a0\u00a0\u00a0Class_Update<\/strong> and close the query. View the updates in the Drivers \u00a0\u00a0\u00a0table and close the table.<\/p>\n

9<\/p>\n

\u00a0<\/p>\n

10<\/strong><\/p>\n

Create a new query using Design \u00a0\u00a0\u00a0view. From the Drivers table, add the Class field. Save the query as Driver \u00a0\u00a0\u00a0Class_Delete<\/strong>.<\/p>\n

4<\/p>\n

\u00a0<\/p>\n

11<\/strong><\/p>\n

Change the query type to Delete and \u00a0\u00a0\u00a0set the criteria to delete drivers whose class is Special<\/strong>. Run the query (one \u00a0\u00a0\u00a0record will delete). Save and close the query. View the changes in the \u00a0\u00a0\u00a0Drivers table and close the table.<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

12<\/strong><\/p>\n

Create a new query using Design \u00a0\u00a0\u00a0view. From the Insurance table, add the DriverID, AutoType, AutoYear, and \u00a0\u00a0\u00a0TagID fields (in that order). Save the query as Auto Year_Parameter<\/strong>.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

13<\/strong><\/p>\n

Set the criteria in the Auto Year \u00a0\u00a0\u00a0field to display the prompt as Enter the auto year:<\/strong> and run the query. In \u00a0\u00a0\u00a0the prompt, enter 2007<\/strong> and click OK to view the results (two \u00a0\u00a0\u00a0records). Save and close the query.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

14<\/strong><\/p>\n

Use the Performance Analyzer to \u00a0\u00a0\u00a0analyze the Drivers table. Note the idea to change the data type of the \u00a0\u00a0\u00a0Weight field from Short Text to Long Integer. In the Drivers table, set the \u00a0\u00a0\u00a0data type of the Weight field to Number (Long Integer) and save and close \u00a0\u00a0\u00a0the table.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

15<\/strong><\/p>\n

Create a Navigation form based on \u00a0\u00a0\u00a0the Vertical Tabs, Left template. Drag and drop the Drivers form onto the \u00a0\u00a0\u00a0first tab of the form. Drop the Insurance form onto the second tab.<\/p>\n

7<\/p>\n

\u00a0<\/p>\n

16<\/strong><\/p>\n

Drag and drop the Drivers report \u00a0\u00a0\u00a0onto the third tab of the Navigation form. View the form in Form view, click \u00a0\u00a0\u00a0each of the tabs, and then save the form as Navigator<\/strong>. Close the form.<\/p>\n

4<\/p>\n

\u00a0<\/p>\n

17<\/strong><\/p>\n

Open the Drivers report in Design \u00a0\u00a0\u00a0view. Modify the record source of the report using a SQL statement to select \u00a0\u00a0\u00a0all Drivers<\/strong> \u00a0\u00a0\u00a0records with a Class<\/strong> of Adult.<\/strong> Print Preview the \u00a0\u00a0\u00a0report (eight records will display). Save and close the report.<\/p>\n

5<\/p>\n

\u00a0<\/p>\n

18<\/strong><\/p>\n

Open the Drivers form in Design \u00a0\u00a0\u00a0view, click to add a command button at the intersection of the six-inch mark \u00a0\u00a0\u00a0on the horizontal ruler and the three-inch mark on the vertical ruler.<\/p>\n

3<\/p>\n

\u00a0<\/p>\n

19<\/strong><\/p>\n

Set the command button to open the \u00a0\u00a0\u00a0report named Drivers. Use the default picture as the button. Set the name \u00a0\u00a0\u00a0and the caption of the button to Open Drivers Report<\/strong>. Save the form. View \u00a0\u00a0\u00a0the form in Form view and click the command button.<\/p>\n

6<\/p>\n

\u00a0<\/p>\n

20<\/strong><\/p>\n

Close all database objects, close \u00a0\u00a0\u00a0the database, and then exit Access. Submit the database as directed.<\/p>\n

0<\/p>\n

\u00a0<\/p>\n

Total Points<\/strong><\/p>\n

100<\/strong><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

I need access database urgently \u00a0 Drivers and Insurance Project Description:\u00a0 In this project, you will add fields \u00a0to a table and set data validation rules. You will also import a text file \u00a0into a database, design advanced queries, and create a navigation form. \u00a0Additionally, you will use SQL to modify a record source and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-32688","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=32688"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32688\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=32688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=32688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=32688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}