Скачать или смотреть Illustrated Access 2019 | Module 3 SAM Project 1b |Ridgedale College|Access Module 3 SAM Project 1b

#Access_Module_3_SAM_Project_B #AccessModule3SAMProjectB #NP #AC19 #NP_AC19_3b #AccessModule3SAMProject1b #Access_Module_3 #AccessModule3 #Access_Module_3_SAM_Project_1b #NP_AC19_3b_FirstLastName_1.accdb #RidgedaleCollege


Contact us:

WhatsApp : +92 3019564454

WhatsApp Link:

http://bit.ly/3BZxAyG


Gmail : [email protected]

We can handle all online courses, Business and Management, Business and Finance, MylTLab all Courses, Excel Assignment, Word Assignment, PowerPoint Assignment, Acess Assignment


#Access Module 3 SAM Project B
#Access_Module_3_SAM_Project_B
#AccessModule3SAMProjectB
#Access Module 3 SAM Project 1b
#Access_Module_3_SAM_Project_1b
#AccessModule3SAMProject1b
#Access Module 3 SAM Project B Ridgedale College
#Access_Module_3_SAM_Project_B_Ridgedale_College
#AccessModule3SAMProjectBRidgedaleCollege
#New Perspectives Access 2019 Module 3 SAM Project 1b
#New_Perspectives_Access_2019_Module_3_SAM_Project_1b
#NewPerspectivesAccess2019Module3SAMProject1b
#shelly cashman access 2019 module 3 sam project 1b
#shellycashmanaccess2019module3samproject1b
#shelly_cashman_access_2019_module_3_sam_project_1b

Open the file IL_AC19_3b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as IL_AC19_3b_FirstLastName_2.accdb by changing the “1” to a “2”.
o 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.
• 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.

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 queries to help make reliable decisions.

Create a query based on the Professors and Grants tables in Design View with the following options:

a. Add the ProfFirstName and ProfLastName from the Professors table and the GrantName and AverageAward fields from the Grants table to the design grid in that order.
b. Sort the records in ascending order by ProfLastName.
c. Save the query using ProfGrants the query name.

Open the query in Datasheet View to view the selected data, and then close it.
2. Open the ProfessorAssignments query in Design View and make the following changes to the query:
a. Delete the Time field from the query design grid.
b. Add criteria to select only those records where the ClassNo field value equals CIS162.
c. Save the changes to the ProfessorAssignments query.

Open the query in Datasheet View to view the selected data, and then close it.
3. Open the MondayOr4 query in Design View and add criteria to select only those records where the Credits field value equals 4 or the MeetingDay field value equals M. Save the changes to the query. Open the query in Datasheet View to view 26 selected records, and then close the query.
4. Open the DepartmentOfferings query in Design View and make the following changes to the query:
a. Add the DeliveryMethod field from the Sections table to the query design grid immediately after the Description field.
b. Add criteria to select only those records where the Credits field value is less than or equal to 3.
c. Open the query in Datasheet View and sort the records by Description in ascending order.
d. Edit the first record changing the Description field value to Accounting for Nonprofit Organizations

5. Open the Hybrid query in Design View and make the following changes:
a. Move the Credits field to the first column of the query design grid.
b. Sort the records in descending order by the Credits field and in ascending order by ClassNo.

Save the query. Open the query in Datasheet View as shown in Figure 2. Close the Hybrid query.
6. Open the QuinnOnline query in Design View and add criteria to select only those records where the ProfLastName field value equals Quinn and the DeliveryMethod field value equals Online. Open the QuinnOnline query in Datasheet View, and then save and close the QuinnOnline query.