#Access_Module_3_SAM_Project_A #AccessModule3SAMProjectA #NP #AC19 #NP_AC19_3a #AccessModule3SAMProject1a #Access_Module_3 #AccessModule3 #Access_Module_3_SAM_Project_1a #NP_AC19_3a_FirstLastName_1.accdb #Global_Human_Resources_Consultants #GlobalHumanResourcesConsultants
Contact Me
Email :cengagesolutions@gmail.com
WhatsApp:+923096000718
WhatsApp Direct Chat : wa.link/sspsfs
#Access Module 3 SAM Project A
#Access_Module_3_SAM_Project_A
#AccessModule3SAMProjectA
#Access Module 3 SAM Project 1a
#Access_Module_3_SAM_Project_1a
#AccessModule3SAMProject1a
#Access Module 3 SAM Project A Global Human Resources Consultants
#Access_Module_3_SAM_Project_A_Global_Human_Resources_Consultants
#AccessModule3SAMProjectAGlobalHumanResourcesConsultants
#New Perspectives Access 2019 Module 3 SAM Project 1a
#New_Perspectives_Access_2019_Module_3_SAM_Project_1a
#NewPerspectivesAccess2019Module3SAMProject1a
#shelly cashman access 2019 module 3 sam project 1a
#shellycashmanaccess2019module3samproject1a
#shelly_cashman_access_2019_module_3_sam_project_1a
#Global Human Resources Consultants
#GlobalHumanResourcesConsultants
#Global_Human_Resources_Consultants
#CREATING QUERIES, SORTING RECORDS, CHANGING THE APPEARANCE OF THE DATASHEET
#CREATING_QUERIES_SORTING_RECORDS_CHANGING_THE_APPEARANCE_OF_THE_DATASHEET
#CREATINGQUERIESSORTINGRECORDSCHANGINGTHEAPPEARANCEOFTHEDATASHEET
#NP_AC19_3a_FirstLastName_1.accdb
#NP_AC19_3a_FirstLastName_2.accdb
#NP_AC19_3a
#cengage
#np
#AC19
#Cengage_Access_Module_3_SAM_Project_A
PROJECT STEPS
1. As project manager, you need to be able to query the database to help make decisions and answer questions from other managers. Create a query based on the Consultant table in Query Design View with the following options:
a. Add the ConsultantID, LastName, and FirstName fields to the design grid in that order.
b. Sort the records in ascending order by LastName.
c. Save the query with the name LastNameSorted.
Open the query in Datasheet View and then close it.
2. Open the ResideCriteria query in Design View and make the following changes to the query:
a. Delete the ConsultantID column from the design grid.
b. Add criteria to select only those records where the Reside field value equals USA.
c. Save the changes to the ResideCriteria query.
Open the query in Datasheet View and then close it.
3. Open the PaidOrBalance query in Design View and add criteria to select only those records where the Paid field value equals 0 or the Balance field value equals 0. Save the changes to the query. Open the query in Datasheet View, confirm that four records appear in the PaidOrBalance query results, and then close the query.
4. Open the ComparisonSalary query in Design View and make the following changes to the query:
a. Add the FirstName field to the query design grid. The FirstName field should immediately follow the ConsultantID field.
b. Add criteria to select only those records where the Salary field value is greater than 70,000.
c. Sort the records by LastName in descending order.
d. Run the query.
e. With the query open in Datasheet view, edit the first record by changing the FirstName value to Melodie from Melodee.
#AccessModule1SAMProjectA
#AccessModule1SAMProjectB
#AccessModule2SAMProjectA
#AccessModule2SAMProjectB
#AccessModule3SAMProjectA
#AccessModule3SAMProjectB
#AccessModule4SAMProjectA
#AccessModule4SAMProjectB
#AccessModule5SAMProjectA
#AccessModule5SAMProjectB
#AccessModule6SAMProjectA
#AccessModule6SAMProjectB
#AccessModule7SAMProjectA
#AccessModule7SAMProjectB
#AccessModule8SAMProjectA
#AccessModule8SAMProjectB
#AccessModule9SAMProjectA
#AccessModule9SAMProjectB
#AccessModule10SAMProjectA
#AccessModule10SAMProjectB
#AccessModule11SAMProjectA
#AccessModule11SAMProjectB
#AccessModule12SAMProjectA
#AccessModule12SAMProjectB
#NP_AC19_1a_FirstLastName_1.accdb
#NP_AC19_1b_FirstLastName_1.accdb
#NP_AC19_2a_FirstLastName_1.accdb
#NP_AC19_2b_FirstLastName_1.accdb
#NP_AC19_3a_FirstLastName_1.accdb
#NP_AC19_3b_FirstLastName_1.accdb
#NP_AC19_4a_FirstLastName_1.accdb
#NP_AC19_4b_FirstLastName_1.accdb
#NP_AC19_5a_FirstLastName_1.accdb
#NP_AC19_5b_FirstLastName_1.accdb
#NP_AC19_6a_FirstLastName_1.accdb
#NP_AC19_6b_FirstLastName_1.accdb
#NP_AC19_7a_FirstLastName_1.accdb
#NP_AC19_7b_FirstLastName_1.accdb
#NP_AC19_8a_FirstLastName_1.accdb
#NP_AC19_8b_FirstLastName_1.accdb
#NP_AC19_9a_FirstLastName_1.accdb
#NP_AC19_9b_FirstLastName_1.accdb
#NP_AC19_10a_FirstLastName_1.accdb
#NP_AC19_10b_FirstLastName_1.accdb
#NP_AC19_11a_FirstLastName_1.accdb
#NP_AC19_11b_FirstLastName_1.accdb
#NP_AC19_12a_FirstLastName_1.accdb
#NP_AC19_12b_FirstLastName_1.accdb
#NP_AC19_1a
#NP_AC19_1b
#NP_AC19_2a
#NP_AC19_2b
#NP_AC19_3a
#NP_AC19_3b
#NP_AC19_4a
#NP_AC19_4b
#NP_AC19_5a
#NP_AC19_5b
#NP_AC19_6a
#NP_AC19_6b
#NP_AC19_7a
#NP_AC19_7b
#NP_AC19_8a
#NP_AC19_8b
#NP_AC19_9a
#NP_AC19_9b
#NP_AC19_10a
#NP_AC19_10b
#NP_AC19_11a
#NP_AC19_11b
#NP_AC19_12a
#NP_AC19_12b
Негізгі бет Access Module 3 SAM Project A Global Human Resources Consultants | Access Module 3 SAM Project 1a
Пікірлер