У нас вы можете посмотреть бесплатно New Perspectives Access 365 | Modules 5-8: SAM Capstone Project A | University of Waterloo Co-op или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
New Perspectives Access 365 | Modules 5-8: SAM Capstone Project A | University of Waterloo Co-op 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/4B6N... 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. 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: a. Use the Lookup Wizard to lookup values for the Industry field. b. The lookup field should get its values from the Industries table. c. Select the Industry field and sort the records in ascending order by the Industry field. d. Widen the Industry field to get the best fit for all of the values in the list. e. Enable data integrity with Restrict Delete on the relationship and use Industry as the label for the lookup field. f. Save the table if prompted. Close the Companies table. 4. Open the SubmissionListing query in Design View and complete the following: a. Add =[Enter minimum salary] as parameter criteria to the StartingSalary field. b. Run the query using 70000 when prompted. Save and close the SubmissionListing query. 5. Open the IndustrySalaries query in Design View and complete the following: a. Add the Total row to the query grid. b. Group By the Industry field, Count the CompanyName field, and Avg (average) the StartingSalary field. c. Switch to Datasheet View and widen each column to see all data and field names as shown in Figure 1 with the following measurements: Change the Industry column field width to 35, the CountOfCompanyName to 22, and the AvgOfStartingSalary to 19. Save and close the IndustrySalaries query. Figure 1: Final IndustrySalaries Query in Datasheet View 6. Create a new query in Design View and complete the following: a. Add the Companies and CoopJobs tables. b. Add the Industry field from the Companies table and the CoopJobTitle and StartingSalary field from the CoopJobs table to the query grid. c. Change the query from a Select query to a Crosstab query. d. Put the Industry field in the Column Heading area and the CoopJobTitle field in the Row Heading area. e. In the Value area, Avg (Average) the StartingSalary field. f. Use CoopJobCrosstab to name and save the query. g. Switch to Datasheet View and widen each column to see all data and field names as shown in Figure 2. Save and close the CoopJobCrosstab query. Figure 2: Final JobCrosstab Query in Datasheet View 7. Open the CoopJobseekerEntry form in Design View and complete the following: a. Add a combo box to the Form Header section at about the 4" mark on the horizontal ruler using the Combo Box Wizard. b. The combo box should find a record. c. Select the LastName and then FirstName fields for the combo box list. d. Use FIND as the label for the new combo box. e. Save the form and open it in Form View. f. Use the new combo box to find the Baker, Camila record. Close the CoopJobseekerEntry form. 8. Open the CoopJobsEntry form in Design View and complete the following: a. Add a subform control below the Posting Date label using the Subform Wizard. b. The subform should contain all the fields from the SubmissionDates query. c. Show SubmissionDates for each record in CoopJobs using CoopJobID. d. Use the default name for the subform.