Illustrated Access 365 | Module 8: SAM Project A скачать в хорошем качестве

Illustrated Access 365 | Module 8: SAM Project A

Please contact us if you need this project or any other project in any subject to be completed. Whatsapp: +1-343-321-3276 Email: [email protected] #illustratedaccess365 #LighthouseCybersecurity Illustrated Access 365 | Module 8: SAM Project A Lighthouse Cybersecurity BUILDING CHARTS AND IMPORTING AND EXPORTING DATA PROJECT STEPS 1. You work as a project assistant for Lighthouse Cybersecurity, an information security consulting company in Tacoma, Washington. For high-level planning purposes, you have created an Access database to track new clients and their projects, services, and analysts. To provide graphic representations of data and use data with other sources, you will build charts and objects using Application Parts and import and export data using HTML and XML file formats. Open the ProjectData form in Form Design View and modify the form to add a chart as follows: a. Use the Chart Wizard to add a chart to the left side of the Form Footer section. b. Base the chart on the ClientFees query. Use the ProjectCode and Deposit fields on the chart. c. Create a Column Chart. d. Sum the Deposit field in the Data area. Use the ProjectCode field in the Axis area of the chart. e. Do not link the form and chart fields. f. Use Client Deposits for the chart title, and do not display a legend. Save the ProjectData form. 2. Resize the chart to be about 6" wide and about 3" tall. Save and display the ProjectData form in Form View as shown in Figure 1, and then close it. 3. Open the ClientRevenue report in Design View and modify the report to add a chart as follows: a. Use the Chart Wizard to add a chart to the left side of the Report Footer section. b. Base the chart on the ClientFees query. Use the ProjectCode and MonthlyFee fields on the chart. c. Create a 3D Column Chart. d. Use the ProjectCode field in the Axis area, and sum the MonthlyFee field in the Data area. e. Do not link the report and chart fields. f. Use Monthly Fees for the chart title, and do not display a legend. Save the ClientRevenue report. 4. Resize the chart to be about 7" wide and 3" tall, and then save the ClientRevenue report. 5. While still in Design View of the ClientRevenue report, change the chart type of the chart in the Report Footer section from 3D Column Chart to Clustered Column Chart to make the chart easier to interpret. (Hint: Delete the legend if it is inserted after changing the chart type.) Save the ClientRevenue report, display it in Print Preview, navigate to the last page of the report as shown in Figure 2, and then close the ClientRevenue report. 6. Use Application Parts to create a Contacts table to track client contact information. The Contacts table should not have a relationship to any other table in the database. 7. Use Application Parts to create a Tasks table as follows to track client tasks: a. One record in the Client table may be linked to many records in the Tasks table. b. Use the ClientID field in the Client table, do not sort the field, name the lookup column Client, and do not allow multiple values. 8. Import the Support_AC365_8A_States.csv text file to create a new table as follows: a. Specify a delimited format and select Tab as the delimiter (if necessary). b. Check the box that indicates that the first row contains field names. c. Do not modify the fields; accept the default field options. d. Choose StateAbbrev as the primary key field. e. Use StateProv as the new table name. f. Do not save the import steps. g. Open the StateProv table in Datasheet View. It should have 64 records. Close the StateProv table. 9. Import the Support_AC365_8A_NewAnalysts.csv text file and append the records into the Analyst table as follows to add data about new analysts: a. Specify a comma delimited format. b. Check the box that indicates that the first row contains field names. c. Do not save the import steps. d. Open the Analyst table in Datasheet View. It should now have 44 records. Close the Analyst table. 10. Import the Support_AC365_8A_Europe.xml file to create a new Access table as follows to list European countries. (Hint: The Support_AC365_8A_Europe.xsd file needs to be in the same folder as the Support_AC365_8A_Europe.xml file for the import to be successful.) a. Import both the structure and the data. b. Do not save the import steps. c. Open the Europe table in Datasheet View. It should have 47 records. Close the Europe table. 11. Export the Client table as an HTML document to the default folder as follows to provide client data as a web document: 12. Export the AnalystList report as an HTML document to the default folder as follows to provide analyst data as a web document: 13. Export the Region table as an XML file to the default folder as follows to provide region data in a universal format: a. Include the XML (data) and XSD (schema) files. b. Save the export steps with the name Export-Region to XML and do not include a Description.