Homework answers / question archive / New Perspectives Access 2019 | Module 8: SAM Project 1b Ridgedale College BUILDING CHARTS, APPLICATION PARTS, AND IMPORTING AND EXPORTING DATA   GETTING STARTED Open the file NP_AC19_8b_FirstLastName_1

New Perspectives Access 2019 | Module 8: SAM Project 1b Ridgedale College BUILDING CHARTS, APPLICATION PARTS, AND IMPORTING AND EXPORTING DATA   GETTING STARTED Open the file NP_AC19_8b_FirstLastName_1

MS Access

Share With

New Perspectives Access 2019 | Module 8: SAM Project 1b

Ridgedale College

BUILDING CHARTS, APPLICATION PARTS, AND IMPORTING AND EXPORTING DATA

GETTING STARTED

• Open the file NP_AC19_8b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_8b_FirstLastName_2.accdb by changing the “1” to a “2”.
  • If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
  • Support_AC19_8b_StatesPlus.xml
  • Support_AC19_8b_StatesPlus.xsd
  • Support_AC19_8b_TransferSchools.csv
  • Support_AC19_8b_Dept.csv
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

• PROJECT STEPS

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 GrantsByDepartment 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 <No Field> 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 GrantEntry form in Form View as shown in Figure 1, and then close it.

3. Open the ProfessorsByDepartment 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 <No Field> 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 ProfessorsByDepartment report.
4. Resize the chart to be about 6" wide and 3" tall, and then save the ProfessorsByDepartment report.
5. While still in Design View of the ProfessorsByDepartment report, change the chart type of the chart in the Report Footer section from 3D Column Chart to Column Chart. Save the ProfessorsByDepartment 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 ProfessorsByDepartment 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 ProfID field in the Professors table, do not sort the field, name the lookup column ProfID, 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 TransferSchools as the new table name.
   6. Do not save the import steps.
   7. Open the TransferSchools table in Datasheet View. It should have 50 records. Close the TransferSchools 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 StatePlus table in Datasheet View. It should have 59 records of US states plus US commonwealth and territories. Close the StatePlus table.
11. Export the ClassMasterList 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-ClassMasterList to HTML and do not include a Description.
12. Export the TAList 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-TAList to HTML and do not include a Description.
13. Export the TeachingAssistants 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-TeachingAssistants to XML and do not include a Description.

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.