1. You work in the Admissions Office at Ridgedale College to help track grants awarded to professors as well as teaching assistant assignments by class. You have created an Access database to organize these details. In this project, you will build charts and objects using Application Parts. You will also import and export data using HTML and XML file formats.
   
   Open the GrantEntry form in Design View and complete the following:
   
   
   1. Use the Chart Wizard to add a chart to the left side of the Form Footer section. (Hint: Use the Chart button in the Controls group versus the Insert Chart button to invoke the Chart Wizard.)
   2. Base the chart on the Grants ByDepartment query. Use the Department and Award fields on the chart.
   3. Create a Column Chart.
   4. Sum the Award field in the Data area. Use the Department field in the Axis area of the chart.
   5. Choose for both the Form Fields and Chart Fields to not link the form and chart fields.
   6. Use Grants By Department for the chart title, and do not display a legend.
2. Resize the chart to be about 6" wide and about 3" tall. Save and display the Grant Entry form in Form View as shown in Figure 1, and then close it
3. Open the Professors By Department report in Design View, and complete the following:
   
   
   1. Use the Chart button to add a chart to the left side of the Report Footer section. (Hint: Use the Chart button in the Controls group versus the Insert Chart button to invoke the Chart Wizard.)
   2. Base the chart on the Professors table. Use the Department and Salary fields on the chart.
   3. Create a 3D Column Chart.
   4. Use the Department field in the Axis area, and sum the Salary field in the Data area.
   5. Choose for both the Report Fields and Chart Fields to not link the report and chart fields.
   6. Use Salaries By Department for the chart title, and do not display a legend. Save the Professors By Department report.
4. Resize the chart to be about 6" wide and 3" tall, and then save the Professors By Department report.
5. While still in Design View of the Professors By Department report, change the chart type of the chart in the Report Footer section from 3D Column Chart to Column Chart. Save the Professors By Department report, display it in Print Preview, and navigate to the last page of the report to see the chart as shown in Figure 2, and then close the Professors By Department report.
6. Use Application Parts to create a Comments table. The Comments table should not have a relationship to any other table in the database.
7. Use Application Parts to create an Issues table with the following instructions:
   
   
   1. One record in the Professors table may be linked to many records in the Issues table.
   2. Use the Prof ID field in the Professors table, do not sort the field, name the lookup column Prof ID, and do not allow multiple values.
8. Import the Support_AC19_8b_TransferSchools.csv file as a new table using the following instructions:
   
   
   1. Specify a comma delimited format.
   2. Check the box that indicates that the first row contains field names.
   3. Do not modify the fields; accept the default field options.
   4. Let Access add a primary key field.
   5. Use Transfer Schools as the new table name.
   6. Do not save the import steps.
   7. Open the Transfer Schools table in Datasheet View. It should have 50 records. Close the Transfer Schools table.
9. Import the Support_AC19_8b_Dept.csv file located in the default folder and append the records into the existing Departments table using the following instructions:
   
   
   1. Specify a comma-delimited format.
   2. Check the box that indicates that the first row contains field names.
   3. Do not save the import steps.
   4. Open the Departments table in Datasheet View. It should now have 13 records. Close the Departments table.
10. Import the Support_AC19_8b_StatesPlus.xml file as a new Access table using the following instructions. (Hint: The Support_AC19_8b_StatesPlus.xsd file needs to be in the same folder as the Support_AC19_8b_StatesPlus.xml file for the import to be successful.)
    
    
    1. Import both the structure and the data.
    2. Do not save the import steps.
    3. Open the State Plus table in Datasheet View. It should have 59 records of US states plus US commonwealth and territories. Close the State Plus table.
11. Using the External Data group on the ribbon, export the Class Master List table as an HTML document to the default folder using the following instructions:
    
    
    1. Do not include formatting and layout.
    2. Save the export steps with the name Export-Class Master List to HTML and do not include a Description.
12. Using the External Data group on the ribbon, export the TA List report as an HTML document to the default folder using the following instructions:
    
    
    1. Do not open the file after the export is complete.
    2. Do not use an HTML template, but do use default encoding.
    3. Save the export steps with the name Export-TA List to HTML and do not include a Description.
13. Using the External Data group on the ribbon, export the Teaching Assistants table as an XML file to the default folder using the following instructions:
    
    
    1. Include the XML (data) and XSD (schema) files.
    2. Save the export steps with the name Export-Teaching Assistants to XML and do not include a Description.