Access Module 1 SAM Project 1a | Global Human Resources Consultants | NP_AC365_2021_1a
Автор: Cengage MidNap
Загружено: 2025-01-27
Просмотров: 61
Access Module 1 SAM Project 1a | Global Human Resources Consultants | NP_AC365_2021_1a
#Access_Module_1_SAM_Project_1a #AccessModule1SAMProject1a #Global_Human_Resources_Consultants #GlobalHumanResourcesConsultants #NP_AC365_2021_1a #AC365_2021_1a #Access_Module_1_SAM_Project_1a #AccessModule1SAMProject1a #Global_Human_Resources_Consultants #GlobalHumanResourcesConsultants #NP_AC365_2021_1a #AC365_2021_1a
Contact Me:
WhatsApp : +92 3219349506
Email : [email protected]
Direct WhatsApp Link:
https://tinyurl.com/mr2fb6z5
PROJECT STEPS
1. You are a project manager for Global Human Resources Consultants, an organization that provides human resources services to emerging companies located in eastern Europe. To better manage consultants and the projects on which they work, you have decided to create an Access database.
Create a new table in Datasheet View with the following options:
a. Rename the default primary key ID field CountryCode and change the data type to Short Text.
b. Change the field size of the field to 3.
c. Add a new field with the name CountryName and the Short Text data type.
Save the table, using Country as the new name.
2. With the Country table still open in Datasheet View, add the four records shown in Table 1. Save and close the Country table.
Table 1: New Records for Country Table
CountryCode CountryName
BEL Belarus
BGR Bulgaria
ROU Romania
SRB Serbia
3. Create a new table in Design View to store the clients of Global as follows:
a. Add a field with the name ClientID and the AutoNumber data type.
b. Apply ClientID as the table's primary key.
Save the table with the name Client but do not close it.
4. With the Client table still open in Design View, add a second field to the table with the field name ClientName and the Short Text data type. Save the table and then close it.
5. Open the Consultant table in Design view and update the Last field, using LastName as the new value.
6. With the Consultant table still open in Design View, change the data type property for the ConsultantID field from Number to Short Text.
7. In Design View, add a new field to the Consultant table after the LastName field. The field should be named StartDate and have the Date/Time data type. Save and close the Consultant table.
8. Open the Consultant table in Datasheet View, navigate to the seventh record (which has a ConsultantID field value of 110460), and delete the record.
9. With the Consultant table still open in Datasheet View, navigate to the fourth record (which has a ConsultantID field value of 110351) and update the FirstName record, using Sidney as the new value. Close the Consultant table.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
