New Perspectives Access 2019 | Module 10: SAM Project 1a Global Human Resources Consultants CREATING MACROS GETTING STARTED ? Open the file NP_AC19_10a_ FirstLastName _1

Subject:MS AccessPrice:19.99 Bought3

Share With

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

Global Human Resources Consultants

CREATING MACROS

GETTING STARTED

?

Open the file

NP_AC19_10a_

FirstLastName

_1.accdb

, available for download from the

SAM website.

?

Save the file as

NP_AC19_10a_

FirstLastName

_2.accdb

by changing the “1” to a “2”.

?

If you do not see the .accdb file extension in the Save As dialog box, do not type it. The

program will add the file extension for you automatically.

?

Open the

_GradingInfoTable

table and ensure that your first and last name is displayed

as the first record in the table. If the table does not contain your name, delete the file

and download a new copy from the SAM website.

PROJECT STEPS

1.

You work in the Software Division of Global Human Resources Consultants (GHRC) that

sells modular Human Resource (HR) software to large international companies. For high-

level planning purposes you have created an Access database to track new clients, the

HR software modules they have purchased, and the lead consultant for each installation.

In this project you will improve the database by creating macros. Complete the following:

a.

Create a new macro in Macro Design View and add the

OpenForm

macro action.

b.

Modify the

OpenForm

macro action to open the

ConsultantSalary

form in Form View

using the other default macro argument values.

c.

Save the macro with the name

OpenConsultantSalaryForm

and run it.

d.

Close the

ConsultantSalary

form, then close the

OpenConsultantSalaryForm

macro.

2.

Open the

OpenClientReports

macro in Macro Design View and complete the following:

a.

Collapse the first

OpenReport

action that opens the

ClientDetails

report.

b.

Expand the second

OpenReport

action and use

Report

as the value for the

View

argument.

c.

Delete the third

OpenReport

action that opens the

Revenue

report.

Save and close the

OpenClientReports

macro.

3.

Open the

OpenConsultantReports

macro in Macro Design View, complete the following:

a.

Expand both of the macro actions.

b.

Open the Action Catalog if it is not already open, and show all actions within it.

c.

Add the

DeleteObject

action in the macro.

d.

Change the

Object Type

argument to

Query

and the

Object Name

argument to

SortedConsultantImport

.

e.

Position the

DeleteObject

action as the second action in the macro.

Save and close the

OpenConsultantReports

macro.

4.

Open the

OpenObjects

macro in Macro Design View and complete the following:

a.

Collapse all existing macro actions within the

Submacro

, then collapse the

Submacro

.

b.

After the existing

Submacro

, add a new

Submacro

with the name

OpenQueries

and one action to open the

Revenue

query in

Datasheet

View.

Save and close the

OpenObjects

macro.

5.

Create a new macro in Macro Design View with the following instructions:

a.

Add an

If

program flow block.

b.

Use the conditional expression

[Reside] = "USA"

in the

If

block.

c.

Add a

SetProperty

macro action within the

If

block.

d.

Use

TravelAllowance

for the

Control Name

argument,

BackColor

for the

Property

argument, and

#00FF00

for the

Value

argument. (

Hint

: #00FF00 is green).

e.

Add an

Else

block and add a

SetProperty

macro action within it.

f.

Use

TravelAllowance

for the

Control Name

argument,

BackColor

for the

Property

argument, and

#FFFFFF

for the

Value

argument in the

Else

block. (

Hint

: #FFFFFF

is white).

Save the macro with the name

Travel

as shown in Figure 1, and then close it.

Figure 1: Travel Macro in Design View

6.

Open the

ConsultantSalary

form in Design View and complete the following:

a.

Attach the

Travel

macro to the

On Current

event of the form.

b.

Switch to Form View and navigate through several records. Those with

"USA"

in the

Reside

text box should display a green background in the

Travel Allowance

text

box. Save and close the

ConsultantSalary

form.

7.

Open the

ClientEntry

form in Design View and complete the following:

a.

Use

#0000FF

for the Hover Fore Color property for the

Close

command button.

(

Hint

: #0000FF is blue).

b.

Save the form, display it in Form View and hover over the

Close

command button

to test the change.

Close the

ClientEntry

form.

8.

In Design View of the

Consultant

table complete the following:

a.

Create a data macro on the

Before Change

event.

b.

If the

Reside

field value is

"USA"

and the

ContractEmployee

field value is

True

use

the

SetField

action to set the value of the

TravelAllowance

field to

2000

as

shown in Figure 2.

c.

Save and close the data macro then open the table in Datasheet View. (

Hint:

Select

Yes in the Microsoft Access window that appears asking if you want to save the

table now.) Check the

ContractEmployee

field value to

True (Yes)

for the first two

records,

ConsultantID 110345 Jenette Masterson

and

110347 Victorina Hogg

to test

your data macro.

Close the

Consultant

table.

Figure 2: Data Macro in Consultant Table

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 SAM website to submit your completed project.