New Perspectives Access 2019 | Module 8: SAM Project 1b | Ridgedale College скачать в хорошем качестве

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

New Perspectives Access 2019 | Module 8: SAM Project 1b | Ridgedale College #newperspectives If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6NMKKBK... Whatsapp Number: +919116641093 +918005564456 Gmail Id: [email protected] We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English. 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: a. 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.) b. Base the chart on the GrantsByDepartment query. Use the Department and Award fields on the chart. c. Create a Column Chart. d. Sum the Award field in the Data area. Use the Department field in the Axis area of the chart. e. Choose No Field for both the Form Fields and Chart Fields to not link the form and chart fields. f. 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. Figure 1: Final GrantEntry Form in Form View 3. Open the ProfessorsByDepartment report in Design View, and complete the following: a. 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.) b. Base the chart on the Professors table. Use the Department and Salary fields on the chart. c. Create a 3D Column Chart. d. Use the Department field in the Axis area, and sum the Salary field in the Data area. e. Choose No Field for both the Report Fields and Chart Fields to not link the report and chart fields. f. 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. Figure 2: Last Page of Final ProfessorsByDepartment Report in Print Preview 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: a. One record in the Professors table may be linked to many records in the Issues table. b. 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: a. Specify a comma delimited format. 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. Let Access add a primary key field. e. Use TransferSchools as the new table name. f. Do not save the import steps. g. 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: 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 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.) a. Import both the structure and the data. b. Do not save the import steps. c. Open the StatePlus table in Datasheet View. It should have 59 records of US states plus US commonwealth and territories. Close the StatePlus table.