New Perspectives Access 365 | Modules 5-8: SAM Capstone 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: essayserviceusa@gmail.com
WhatsApp Link: https://wa.me/13433213276
#NewPerspectivesAccess365 #Modules5-8SAMCapstoneProjectA
#UniversityofWaterlooCo-opPlacement

New Perspectives Access 365 | Modules 5-8: SAM Capstone Project A
University of Waterloo Co-op Placement
IMPROVING TABLES, QUERIES, FORMS, AND REPORTS
PROJECT STEPS
1. The University of Waterloo has a variety of co-operative (co-op) degree programs where students are placed in co-op/intern job positions to gain work experience in their field. You work in the University of Waterloo co-op placement department as a senior placement manager. You are developing an Access database application to help manage and analyze companies, co-op jobs, students, and co-op placements. In this project, you will improve an existing database by modifying tables, queries, forms, and reports.

Open the Students table in Design View and complete the following:
a. After the existing Phone field add a new field named Email with a Hyperlink data type.
b. Add a second new field named Comments with a Long Text data type.

Save and close the Students table.
2. Open the CoopJobs table in Design View and complete the following:
a. Add Salary as the caption property to the StartingSalary field.
b. Add =Date() as the Validation Rule property for the PostingDate field.
c. Add Date must be today or later as the Field Validation Text property for the PostingDate field.

Save and close the CoopJobs table. If prompted to test data integrity click Yes.
3. Open the Companies table in Design View and complete the following:
4. Open the SubmissionListing query in Design View and complete the following:
5. Open the IndustrySalaries query in Design View and complete the following:
6. Create a new query in Design View and complete the following:
7. Open the CoopJobseekerEntry form in Design View and complete the following:
8. Open the CoopJobsEntry form in Design View and complete the following:
9. Open the CompanyEntry form in Design View and complete the following:
10. With the CompanyEntry form still open in Design View, change the Record Source to the CompaniesSortedByName query.
11. With the CompanyEntry form still open in Design View, change the tab order in the Detail section so that CompanyID is the first item in the list. Save the form and switch to Form View as shown in Figure 3, and then close the CompanyEntry form.
12. Open the CoopJobListing report in Design View and add a horizontal line above the text box in the Report Footer section that sums the StartingSalary. The line should be just above and approximately the same width as the text box. The line will be positioned between the Report Footer section bar and the text box and be approximately 1.7" wide that is the width of the text box. Save the CoopJobListing report.
13. With the CoopJobListing report still open in Design View complete the following:
14. With the CoopJobListing report still open in Design View, add a sort order under the existing CompanyName grouping field to sort the records in ascending order on the CoopJobTitle field. Save the report and display the CoopJobListing report in Print Preview as shown in Figure 4, then close the CoopJobListing report.
15. Open the CoopJobseekerListing report in Design View and complete the following:
16. Copy the CompanyListing report and paste it as the CompanySorted report.
17. Open the CompanySorted report in Design View and change the Record Source to the CompaniesSortedByName query. Save the CompanySorted report.
18. With the CompanySorted report still open in Design View, add page numbers to the report in an N of M format to the right of the Page Footer. Save the CompanySorted report, preview it, then close it.
19. Open the CoopJobsalaries report in Design View and use the Chart Wizard to create a chart at about the 0.5" mark on the horizontal ruler in the Report Footer section with the following information:
20. Export the Companies table as an HTML Document to the default folder with the default file name with the following information:
21. Export the CompanyListing report as an HTML Document to the default folder with the default file name with the following information:
a. Do not select an HTML template.
b. Use default encoding.
c. Save the export steps as Export-CompanyListing to HTML.
d. Do not include an export Description.
22. Import the Support_AC365_CS5-8A_StateProvs.csv file as a new table with the following information:
23. Export the CoopJobs table in an XML format to the default folder with the default file name with the following information:
a. Export both the Data XML and Schema XSD files.
b. Save the export steps as Export-CoopJobs to XML.
c. Do not include an export description.