Posted: March 12th, 2023

GO19_AC_CH04_GRADER_4G_AS – Human Resources 1.0

GO19_AC_CH04_GRADER_4G_AS.zipGO19_AC_CH04_GRADER_4G_AS_Instructions xGO19_AC_CH04_GRADER_4G_AS

 GO19_AC_CH04_GRADER_4G_AS – Human Resources 1.0

  

Project Description:

In this project, you will append data from one table to another, modify the design of a table, and, after adding an Attachment field, you will attach a Word document to a database record. You will also create a table to organize special events offered to employees.

     

Start   Access. Download, open, and save the database named Student_Access_4G_Human_Resources.accdb.

 

Save   a copy of the Management table as the Employees   table.

 

Copy   the Trainees table and then paste the table, appending the data from it into   the Employees table (the appended table will contain eleven records).

 

Open   the Employees table in Design view. Change the data type for the Empl ID   field to Short Text.

 

In   the Empl ID field, limit the field size to 4   characters.

 

Add   a new Monthly Salary field below the Annual Salary field,   with the data type set to Calculated. In the Expression Builder dialog box,   enter the calculation as [Annual Salary]/12   and change the Result Type to Currency.

 

Between   the ZIP field and the Annual Salary field, add a new Certificate field to the table with the data type   set to Attachment.

 

Select   the ZIP field. In the Input Mask box, type 00000\-9999.   Limit the field size to 10   characters. Make entry of data into the field required. View the table in   Datasheet view, and save your changes. In the warning message box, click Yes   to continue, and then click Yes to continue.

 
In   the Michael Chin record, in the Attachment field, double-click, and then from   the student data files, attach Chin_Cert .   Click OK. Using the same technique, for the Jan Meyer record, add the   certificate that is in the Meyer_Cert   file. Close the table.
 

Create   a table in Design view. In the first Field Name box, type

Activity

ID

, and select an AutoNumber data type.   On the Design tab, in the Tools group, click the Primary Key button.

 

In   the second Field Name box, type Activity.   In the third Field Name box, type

Shift

  and select a Lookup Wizard data type. Type the look up list to include

Day

,

Evening

,   

Overnight

, and

Weekend

.

 

Switch   to Datasheet view, saving the table as Employee   Activities.

 

Populate   the table with the following data, and then adjust the column widths so all   data is visible.

  
Activity ID
Activity
Shift
 
1

Luncheon

Day
 
2

Appetizer Buffet

Evening
 
3

Donuts/Coffee

Overnight
 
4

Softball Game

Evening
 
5

Bowl-a-thon

Weekend
 

Save   and close the database, and then submit for grading.

Merone_Access_4G_Human_Resources.accdb

Empl ID
Last Name
First Name
Street
City
State
ZIP
Annual Salary

3933
Houser
Mary Lou
4300 E. Main Street
Hugo Park
CA
96268
98465

5645
Irwin
Phil
7700 Delmar
Golden Grove
CA
96265
82413

6531
Peters
Stephanie
897 Oak Forest Rd
Golden Grove
CA
96265
88465

8311
Warner
Tom
322 Waterway Ct
San Juarito
CA
96263
71324

8420
Chin
Michael
800 Rockbridge Rd
San Juarito
CA
96263
100154

9426
Vasquez
Marco
125 Fee Fee Rd
Hugo Park
CA
96268
92135

9764
Sapple
Janet
3879 Olive Branch Rd
Golden Grove
CA
96265
63555

ID
mSysRowId

1

Empl ID
First Name
Last Name
Street
City
State
ZIP
Annual Salary

1301
Stephen
Jenson
220 Skagway Ct
San Juarito
CA
96263
36458

1495
Julie
Soko
400 Winehaus Ln
Hugo Park
CA
96268
32145

1544
Larry
Singer
970B Forest Ridge
Golden Grove
CA
96265
48563

1678
Jan
Meyer
651 Orchardview
Golden Grove
CA
96265
39565

GO19_AC_CH04_GRADER_4G_AS_Instructions x
Grader – Instructions Access 2019 Project

GO19_AC_CH04_GRADER_4G_AS – Human Resources 1.0

Project Description:

In this project, you will append data from one table to another, modify the design of a table, and, after adding an Attachment field, you will attach a Word document to a database record. You will also create a table to organize special events offered to employees.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Download, open, and save the database named
Student_Access_4G_Human_Resources.accdb.

0

2

Save a copy of the Management table as the
Employees table.

10

3

Copy the Trainees table and then paste the table, appending the data from it into the Employees table (the appended table will contain eleven records).

12

4

Open the Employees table in Design view. Change the data type for the Empl ID field to Short Text.

8

5

In the Empl ID field, limit the field size to
4 characters.

8

6

Add a new
Monthly Salary field below the Annual Salary field, with the data type set to Calculated. In the Expression Builder dialog box, enter the calculation as
[Annual Salary]/12 and change the Result Type to Currency.

8

7

Between the ZIP field and the Annual Salary field, add a new
Certificate field to the table with the data type set to Attachment.

8

8

Select the ZIP field. In the Input Mask box, type
00000\-9999. Limit the field size to
10 characters. Make entry of data into the field required. View the table in Datasheet view, and save your changes. In the warning message box, click Yes to continue, and then click Yes to continue.

8

9

In the Michael Chin record, in the Attachment field, double-click, and then from the student data files, attach
Chin_Cert . Click OK. Using the same technique, for the Jan Meyer record, add the certificate that is in the
Meyer_Cert file. Close the table.

8

10

Create a table in Design view. In the first Field Name box, type
Activity ID, and select an AutoNumber data type. On the Design tab, in the Tools group, click the Primary Key button.

8

11

In the second Field Name box, type
Activity. In the third Field Name box, type
Shift and select a Lookup Wizard data type. Type the look up list to include
Day,
Evening,
Overnight, and
Weekend.

10

12

Switch to Datasheet view, saving the table as
Employee Activities.

2

13

Populate the table with the following data, and then adjust the column widths so all data is visible.

Activity ID

Activity

Shift

1

Luncheon

Day

2

Appetizer Buffet

Evening

3

Donuts/Coffee

Overnight

4

Softball Game

Evening

5

Bowl-a-thon

Weekend

10

14

Save and close the database, and then submit for grading.

0

Total Points

100

Created On: 07/05/2019 1 GO19_AC_CH04_GRADER_4G_AS – Human Resources 1.0

Chin_Cert

Employee Training Certificate

Michael Chin
has completed the Diversity Awareness Training Program:

Supervisor signature Date

Michael Chin

has completed the Diversity Awareness Training Program:

Employee Training Certificate

Meyer_Cert

Employee Training Certificate

Jan Meyer
has completed the Diversity Awareness Training Program:

Supervisor signature Date

Michael Chin

has completed the Diversity Awareness Training Program:

Employee Training Certificate

Grader – Instructions Access

2

0

1

9

Project

GO19_AC_CH0

4

_GRADER_4G_AS – Human Resources 1.0

Project Description:

In this project, you will append data from one table to another, modify the design of a table, and, after adding an Attachment field, you will attach a Word document to a database record. You will also create a table to organize special events offered to employees.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Download, open, and save the database named
Student_Access_4G_Human_Resources.accdb.

0 2

Save a copy of the Management table as the
Employees table.

10

3

Copy the Trainees table and then paste the table, appending the data from it into the Employees table (the appended table will contain eleven records).

12

4

Open the Employees table in Design view. Change the data type for the Empl ID field to Short Text.

8

5

In the Empl ID field, limit the field size to
4 characters.

8

6

Add a new
Monthly Salary field below the Annual Salary field, with the data type set to Calculated. In the Expression Builder dialog box, enter the calculation as
[Annual Salary]/12 and change the Result Type to Currency.

8

7

Between the ZIP field and the Annual Salary field, add a new
Certificate field to the table with the data type set to Attachment.

8

8

Select the ZIP field. In the Input Mask box, type
00000\-9999. Limit the field size to
10 characters. Make entry of data into the field required. View the table in Datasheet view, and save your changes. In the warning message box, click Yes to continue, and then click Yes to continue.

8

9

In the Michael Chin record, in the Attachment field, double-click, and then from the student data files, attach
Chin_Cert . Click OK. Using the same technique, for the Jan Meyer record, add the certificate that is in the
Meyer_Cert file. Close the table.

8

10

Create a table in Design view. In the first Field Name box, type
Activity ID, and select an AutoNumber data type. On the Design tab, in the Tools group, click the Primary Key button.

8

11

In the second Field Name box, type
Activity. In the third Field Name box, type
Shift and select a Lookup Wizard data type. Type the look up list to include
Day,
Evening,
Overnight, and
Weekend.

10

12

Switch to Datasheet view, saving the table as
Employee Activities.

2

13

Populate the table with the following data, and then adjust the column widths so all data is visible.

Activity ID

Activity

Shift

1

Luncheon

Day

2

Appetizer Buffet

Evening

3

Donuts/Coffee

Overnight

4

Softball Game

Evening

5

Bowl-a-thon

Weekend

10

14

Save and close the database, and then submit for grading.

0

Total Points

100

Created On: 07/05/2019 1 GO19_AC_CH04_GRADER_4G_AS – Human Resources 1.0