{"id":120969,"date":"2023-04-20T23:30:32","date_gmt":"2023-04-20T23:30:32","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp19_access_appcapstone_comp-drivers-1-0-computer-science-homework-help\/"},"modified":"2023-04-20T23:30:32","modified_gmt":"2023-04-20T23:30:32","slug":"exp19_access_appcapstone_comp-drivers-1-0-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp19_access_appcapstone_comp-drivers-1-0-computer-science-homework-help\/","title":{"rendered":"Exp19_access_appcapstone_comp \u2013 drivers 1.0 | Computer Science homework help"},"content":{"rendered":"
\n

Exp19_Access_AppCapstone_Comp \u2013 Drivers 1.0<\/strong><\/p>\n

\u00a0\u00a0<\/p>\n

In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate opening a report. Finally, you will create a pie chart in a report.<\/p>\n

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

Start \u00a0\u00a0Access. Open the file named Exp19_Access_AppCapstone_Comp_Drivers<\/em>. \u00a0\u00a0Grader has automatically added your last name to the beginning of the \u00a0\u00a0filename. Save the file to the location where you are storing your files.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0have discovered that the insurance company data that you want is stored in an \u00a0\u00a0external text file, so you will import the file as a table in the database, \u00a0\u00a0and not need to design the table from scratch.
\u00a0<\/p>\n

\u00a0\u00a0Create a table in the database by importing the downloaded delimited text \u00a0\u00a0file named Insurance_Text.txt<\/em>. Use \u00a0\u00a0the first row of the file as field names, use InsuranceID<\/strong> as the primary key, and then name the table InsuranceCos_Text<\/strong>. Accept all other default options. Do \u00a0\u00a0not save the import steps.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0will modify a table to add fields that store the websites and photos of \u00a0\u00a0agents, add a lookup field, and set data validation to ensure that valid \u00a0\u00a0values are entered in a field.
\u00a0<\/p>\n

\u00a0\u00a0Create a new field in the Agency Info \u00a0\u00a0table<\/strong> after InsPhone<\/em> named Website <\/strong>with the Hyperlink <br><\/strong>data type. Save the table. In Datasheet view, \u00a0\u00a0add the website http:\/\/William_Smith.com<\/strong> to the
William Smith<\/em> record (Record 1).<\/p>\n

\u00a0<\/p>\n

Create \u00a0\u00a0a new field in the Agency Info table after Website<\/em> named AgentPhoto<\/strong> \u00a0\u00a0with the Attachment data type<\/strong>. \u00a0\u00a0Save the table. In Datasheet view for Record 1 (William Smith<\/em>), add the downloaded picture file named WmSmith.jpg<\/em> to the AgentPhoto field<\/strong>.<\/p>\n

\u00a0<\/p>\n

Set \u00a0\u00a0the validation rule of the InsuranceCo \u00a0\u00a0field<\/strong> to accept the values AS<\/strong>, \u00a0\u00a0NAT<\/strong>, or SF<\/strong> \u00a0\u00a0only. Set the validation text to read Please enter AS, \u00a0\u00a0NAT, or SF.<\/strong> (include the period).<\/p>\n

\u00a0<\/p>\n

Make \u00a0\u00a0InsuranceCo<\/strong> a lookup field in the \u00a0\u00a0Agency Info table. Set the lookup to get values from the InsuranceID field<\/strong> in the InsuranceCos_Text table. Accept all \u00a0\u00a0other defaults and save the table. In Datasheet view, select the first InsuranceCo value<\/strong>, type AT<\/strong> and press ENTER<\/strong>. Click OK<\/strong> in the \u00a0\u00a0message box, press ESC, and then close the table.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0will create queries to locate records that have missing values, update values \u00a0\u00a0in a table, and delete specific records from the database.
\u00a0<\/p>\n

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

\u00a0<\/p>\n

Set \u00a0\u00a0the criteria in the TagExpiration \u00a0\u00a0field<\/strong> to find null values. Run the query (two records will display). Save \u00a0\u00a0and close the query.<\/p>\n

\u00a0<\/p>\n

Create \u00a0\u00a0a new query using Design view. From the Drivers table, add the Class field<\/strong>. Change the query type to \u00a0\u00a0Update<\/strong> and set the criteria to \u00a0\u00a0update drivers whose class is Minor<\/strong> \u00a0\u00a0to Junior<\/strong>. Run the query (eight records will \u00a0\u00a0update). Run the query again and note that there are no records to update. \u00a0\u00a0Save the query as Driver Class_Update<\/strong> \u00a0\u00a0and close the query. View the updates in the Drivers table and close the \u00a0\u00a0table.<\/p>\n

\u00a0<\/p>\n

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

\u00a0<\/p>\n

Change \u00a0\u00a0the query type to Delete<\/strong> and set \u00a0\u00a0the criteria to delete drivers whose class is Special<\/strong>. \u00a0\u00a0Run the query (one record will be deleted). Save and close the query. View \u00a0\u00a0the changes in the Drivers table and close the table.<\/p>\n

\u00a0<\/p>\n

Create \u00a0\u00a0a new query using Design view. From the Insurance table, add the InsuranceAgentID<\/strong>, AutoType<\/strong>, AutoYear<\/strong>, and TagID fields<\/strong> \u00a0\u00a0(in that order). Save the query as Agent_Parameter<\/strong>.<\/p>\n

\u00a0<\/p>\n

Set \u00a0\u00a0the criteria in the InsuranceAgentID \u00a0\u00a0field<\/strong> to display the prompt as Enter the Agent \u00a0\u00a0ID:<\/strong> \u00a0\u00a0and run the query. In the parameter prompt, enter AS8842<\/strong> \u00a0\u00a0and click OK<\/strong> to view the results \u00a0\u00a0(two records). Save and close the query.<\/p>\n

\u00a0<\/p>\n

The \u00a0\u00a0Performance Analyzer makes suggestions as to how a selected table can be made \u00a0\u00a0more efficient or to work better with other tables in the database.
\u00a0<\/p>\n

\u00a0\u00a0Use the Analyze Performance tool to analyze the Drivers table. Note the idea \u00a0\u00a0to change the data type of the Weight field from Short Text to Long Integer. \u00a0\u00a0In the Drivers table, set the data type of the Weight field<\/strong> to Number \u00a0\u00a0(Long Integer)<\/strong>, then save and close the table.<\/p>\n

\u00a0<\/p>\n

A \u00a0\u00a0navigation form enables users to select key objects in the database in a \u00a0\u00a0user-friendly manner. The form will launch automatically to present the \u00a0\u00a0frequently used forms and report to the end users.
\u00a0<\/p>\n

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

\u00a0<\/p>\n

Drag \u00a0\u00a0and drop the Drivers report<\/strong> onto \u00a0\u00a0the third tab of the Navigation form. View the form in Form view, click each \u00a0\u00a0of the tabs, and then save the form as Navigator<\/strong>. \u00a0\u00a0Close the form.<\/p>\n

\u00a0<\/p>\n

Set \u00a0\u00a0the option in the database so that the Navigator \u00a0\u00a0<\/strong>form launches automatically when the database opens. Close the database \u00a0\u00a0and reopen it to ensure that the Navigator form opens. Close the form.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0will modify the record source of a report to display specific records. The \u00a0\u00a0report will not rely on an underlying query to select records; the criteria are \u00a0\u00a0handled by the SQL statement. You will add a command button to a form that \u00a0\u00a0will open a form with associated records.
\u00a0<\/p>\n

\u00a0\u00a0Open the Drivers report in Design view. Modify the record source of the \u00a0\u00a0report using a SQL statement to select all Drivers<\/strong> \u00a0\u00a0records with a Class<\/strong> \u00a0\u00a0of Adult.<\/strong> Print Preview the report (eight \u00a0\u00a0records will display).<\/p>\n

\u00a0<\/p>\n

Modify \u00a0\u00a0the SQL record source to display Junior<\/strong> \u00a0\u00a0drivers. Print Preview the report (eight records will display). Save and \u00a0\u00a0close the report.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0will add a command button to a form that will open a form with associated \u00a0\u00a0records.
\u00a0<\/p>\n

\u00a0\u00a0Open the Drivers form in Design view, click to add a command button<\/strong> at the intersection of the 6-inch mark on the \u00a0\u00a0horizontal ruler and the 3-inch mark on the vertical ruler.<\/p>\n

\u00a0<\/p>\n

Set \u00a0\u00a0the command button to open the Insurance form. Use the default picture as the \u00a0\u00a0button. Set the name and the caption of the button to Open Insurance Form<\/strong>. Set the width of the button to 1.5″<\/strong>. Save the form. View the form in Form \u00a0\u00a0view and click the command button<\/strong>.<\/p>\n

\u00a0<\/p>\n

You \u00a0\u00a0will create a chart in a report that compares the number of licenses that \u00a0\u00a0were issued by year. The chart will graphically depict the mix of drivers \u00a0\u00a0according to the years of driving experience.
\u00a0<\/p>\n

\u00a0\u00a0Open the Auto Year report<\/strong> in \u00a0\u00a0Design view. Click the Report Footer \u00a0\u00a0section bar<\/strong>. Open the Property Sheet and set the height of the Report \u00a0\u00a0Footer section to 3″<\/strong>. Close \u00a0\u00a0the Property Sheet. Click in the blank \u00a0\u00a0space<\/strong> below the Count function.<\/p>\n

\u00a0<\/p>\n

Insert \u00a0\u00a0a pie chart by clicking at the 0.5″<\/strong> mark<\/strong> on the vertical ruler and the \u00a0\u00a02.5″<\/strong> mark<\/strong> on the horizontal ruler. In the Chart Settings pane, set the \u00a0\u00a0Auto Year_Parameter query<\/strong> as the \u00a0\u00a0data source. In the Axis (Category), select the AutoType check box<\/strong>, then in the parameter prompt, type 2012<\/strong>. Close the Chart Settings pane.<\/p>\n

\u00a0<\/p>\n

Click \u00a0\u00a0in the Chart Title box<\/strong> in the \u00a0\u00a0Property Sheet, and type Auto Type<\/strong>. \u00a0\u00a0Close the Property sheet, then save and close the report. Reopen the report \u00a0\u00a0and type 2010<\/strong> \u00a0\u00a0at the prompts. Note that the data in the report and chart displays according \u00a0\u00a0to the year input. Close the report.<\/p>\n

\u00a0<\/p>\n

Close \u00a0\u00a0all database objects. Close the database and then exit Access. Submit the \u00a0\u00a0database as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Exp19_Access_AppCapstone_Comp \u2013 Drivers 1.0 \u00a0\u00a0 In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate […]<\/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-120969","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/120969","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=120969"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/120969\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=120969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=120969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=120969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}