New Perspectives Access 365/2021 | Module 2: SAM Project 1b | Ridgedale College

Описание: New Perspectives Access 365/2021 | Module 2: 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 are a graduate teaching assistant for Ridgedale College, a private college in the Midwest. To help the college better manage their course scheduling, you have created an Access database and are working on the tables and table relationships.

Some of the data that you need for the Ridgedale College database is currently stored in Excel workbooks. Use the Import Spreadsheet Wizard to import the data from the Support_AC365_2021_2b_TeachingAssistants.xlsx support file and append it to the TeachingAssistants table. Do not analyze the table after importing the data and do not save the import steps. Open the TeachingAssistants table in Datasheet View as shown in Figure 1. Close the TeachingAssistants table.
Figure 1: Updated TeachingAssistants Table



2. In addition to their teaching duties, teaching assistants and professors also work on grants that you want to track in the database. Use the Import Spreadsheet Wizard to import the data from the Support_AC365_2021_2b_Grants.xlsx support file as a new table. The first row contains column headings, but no other changes need to be made to the fields. Let Access add a primary key to the table. Name the table Grants and do not save the import steps. Open the Grants table in Datasheet View as shown in Figure 2. Close the Grants table.
Figure 2: New Grants Table



3. Open the Professors table in Design View. Use Professor as the Default Value property for the ProfTitle field. Save the change but do not close the Professors table.
4. With the Professors table open in Design View, change the Input Mask property for the HireDate field to Short Date using the default options of the Input Mask Wizard. Save and close the Professors table.
5. Open the ClassMasterList table in Design View. Use Yes as the Required property for the Description and Credits fields. Save the changes to the ClassMasterList table and then close the table. (Hint: Because you changed the Required property, the "Data Integrity rules have been changed" warning message appears. The existing data is valid. Click Yes to confirm this for all records.)
6. Open the Professors table in Datasheet View. Apply the Currency format to the Salary field. Save but do not close the table.
7. With the Professors table still open in Datasheet View, move the Salary field so that it appears immediately after the ProfLastName field. Save and close the Professors table.
8. Open the ClassMasterList table in Datasheet View and make the following changes:
a. Resize the Description field so that all field values are completely visible.
b. Add a new field following the Credits field with the field name LabFees and the Number data type. Save and close the ClassMasterList table.
9. Open the Professors table in Datasheet View. Delete the Extension field and save the table as shown in Figure 3.
Figure 3: Updated Professors Table



10. With the Professors table still open in Datasheet View, decrease the number of decimal places for the Salary field to 0. Save and close the Professors table.
11. Open the TeachingAssistants table in Datasheet View and make the following changes to the Stipend field:
a. Use 1000 as the Default Value property value.
b. Increase the number of decimal places for the Stipend field to 2. Save and close the TeachingAssistants table.
12. In the Navigation Pane, rename the DepartmentList table. Use Departments for the new name.
13. Open the Grants table in Design View and add a new field below the AverageGrantAward field named ProfID with a Short Text data type. This field will serve as the foreign key field to allow one record in the Professors table to link to many records in the Grants table. Save and close the Grants table.
14. Open the Relationships window, add the Grants table and the Departments table, and create a one-to-many relationship between the Professors and Grants tables using the common ProfID field. Enforce referential integrity on the relationship.