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. Yo
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.pdf. Click OK. Using the same technique, for the Jan Meyer record, add the certificate that is in the Meyer_Cert.pdf 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.docx
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.pdf. Click OK. Using the same technique, for the Jan Meyer record, add the certificate that is in the Meyer_Cert.pdf 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.
|
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.pdf
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.pdf
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 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.pdf. Click OK. Using the same technique, for the Jan Meyer record, add the certificate that is in the Meyer_Cert.pdf 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.
|
