spectives Access $365/2021$

Module I: SAM Project la

Global Human Resources Consultants

CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS

GETTING STARTED

Open the file NP$\_$AC$365\_2021\_1$a$\_$FirstLastName$\_1.$accdb, available for

Save the file NP$\_$AC$365\_2021\_1$a$\_$FirstLastName$\_1.$accdb as NP$\_$AC$365\_2021\_1$a$\_$FirstLastName$\_2.$accdb

Edit the file name by changing $"1"$ to $"2".$

If you do not see the $.$accdb file extension, do not type it$.$ The file exte be added for you automatically.

With the file NP$\_$AC$365\_2021\_1$a$\_$FirstLastName$\_2.$accdb open, ensure first and last name is displayed as the first record in the $\_$GradingInfoTable to

If the table does not display your name, delete the file and download a

PROJECT STEPS

You are a project manager for Global Human Resources Consultants, an orga that provides human resources services to emerging companies located in ea Europe. To better manage consultants and the projects on which they work, 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 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 dat Save the table, using Country as the new name.

$2.$ With the Country table still open in Datasheet View, add the four records she $1.$ Save and close the Country table.

Table $1$: New Records for Country Table

$\backslash$table$[[$CountryCode$,$CountryName$],[$BEL$,$Belarus$],[$BGR$,$Bulgaria$],[$ROU$,$Romania$],[$SRB$,$Serbia$]]$

tives Access $365/2021$

I Module I: SAM Project la

New Perspectives Access $365/2021|$ Module $1$: SAM Project la

$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.

$10.$ You also need to view individual consultant records. Use the Form Wizard to create a form for the Consultant table with the following options:

a$.$ Include all fields from the Consultant table in the form.

b$.$ Select Columnar as the layout for the form.

Save the form with the name Consultant Data Form and confirm that the form matches Figure $1.$ Close the form.

Altemative Formats

up

Nettutor

$64F$

Cloudy

New Perspectives Access $365/2021|$ Module I: SAM Project la

$11.$ Use the Simple Query Wizard to create a query based on the Skill table with the following options:

a$.$ Include all fields from the Skill table in the query.

Save the query with the name Skill Query $($which is the default name$)$ and then close the query.

$12.$ You need to refer to a printed copy of the Skill table when assigning consultants to projects. Use the Report Wizard to create a report based on the Skill table with the following options:

a$.$ Include all fields from the Skill table in the report.

b$.$ Do not include any grouping levels.

c$.$ Sort the report by SkillCode in ascending order.

d$.$ Select Tabular as the layout of the report and Portrait as the orientation of the report.

Save the report with the name Skill Report. Confirm that the report matches Figure $2$ and then close the report.

New Perspectives Access $365/2021|$ Module $1$: SAM Project la

Figure $2$: Skill Report in Print Preview

$\backslash$table$[[$Skill Report$],[$Skillcode$,$Skill Name$],[$EMPR$,$Employee Relations$],[$HRIS$,$HR Information Software$],[$ICOM$,$Internet Communications$],[$ONBD$,$Onboarding$],[$PMGT$,$Performance Management$],[$RECR$,$Recruiting$],[$SCRE$,$Screening$]]$

In the Navigation Pane, rename the Skill form, using Skill Data Form as the new value.

Save and close any open objects in your database. Compact and repair your database, close it$,$ and then exit Access. Follow the directions on the website to submit your completed project.