New Perspectives Access 2019 | Module 1: SAM Project 1a | Instructions_NP_AC19_1a

#Module1SAMProject1a #SAMProject1a #Access2019

Contact Me:
WhatsApp : +92 3115298219
Email : [email protected]

Direct WhatsApp Link:
https://tinyurl.com/4wjb4d63





#New Perspectives Access 2019 | Module 1: SAM Project 1a
#New Perspectives Access 2019
#Perspectives Access 2019
#Access 2019
#Module 1: SAM Project 1a
#SAM Project 1a
#Project 1a
#Module 1: SAM Project
#SAM Project
#Project
#Instructions_NP_AC19_1a
#NP_AC19_1a
#AC19_1a


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.