Homework answers / question archive / New Perspectives Access 2019 | Module 4: SAM Project 1a Global Human Resources Consultants CREATING FORMS AND REPORTS GETTING STARTED ? Open the file NP_AC19_4a_ FirstLastName _1

New Perspectives Access 2019 | Module 4: SAM Project 1a Global Human Resources Consultants CREATING FORMS AND REPORTS GETTING STARTED ? Open the file NP_AC19_4a_ FirstLastName _1

MS Access

Share With

---

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

Global Human Resources Consultants

CREATING FORMS AND REPORTS

GETTING STARTED

?

Open the file

NP_AC19_4a_

FirstLastName

_1.accdb

, available for download from the

SAM website.

?

Save the file as

NP_AC19_4a_

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.

As project manager, you need to be able to view records for all consultants, clients, and

projects as well as prepare reports for various departments. Open the

ClientControl

form

in Design View and perform the following tasks:

a.

Resize the

Paid

text box to be the same size as the

ClientName

text box above it.

b.

Move the

Close

command button so that the left edge of the command button is at

the

6"

mark on the horizontal ruler.

c.

Add a label with the caption

Human Resources

to the Form Header section at the

3"

mark on the horizontal ruler.

Save the

ClientControl

form, switch to Form View as shown in Figure 1, then close

the form.

Figure 1: ClientControl Form in Form View

2.

Open the

ConsultantData

form in Design View and perform the following tasks:

a.

Add the

Reside

field to the form. Position the

Reside

text box so that the

left

edge

of the control aligns with the left edge of the other five text boxes.

b.

Delete

the

Reside

label.

Save the changes to the

ConsultantData

form and close it.

3.

Use the Form Wizard to create a form based on the

Client

table with the following

options:

a.

Include all fields from the

Client

table in the form.

b.

Select the

Columnar

layout for the form.

c.

Enter

ClientEntry

as the form title and then open it in Layout View.

4.

With the

ClientEntry

form open in Layout View, right-align the text in the five labels in

the Detail section.

Bold

the five labels in the Detail section. Save the form and open it in

Form View.

5.

Use the

ClientEntry

form to navigate to the record with

ClientID

field value

9

. Change the

Balance

field value of this record to

$25,000

.

6.

Use the

ClientEntry

form to add a new record to the

Client

table with the field values

shown in Table 1. (

Hint

: The

Total

field is a calculated field.) Close the form.

Table 1: New Record for ClientEntry Form

ClientID

ClientName

Paid

Balance

16

Intrazio

25,000

0

7.

Open the

ConsultantSalary

form in Design View and perform the following tasks:

a.

Delete

the

Human Resources

label control in the Form Header.

b.

Add the

StartDate

field to the form then position it just below the

Salary

label and

text box.

c.

Change the

Salary

label to

Current Salary

in the Detail section, and the

ConsultantSalary

label to

Consultant Salary

in the Form Header section by

adding a space between the words.

Save the

ConsultantSalary

form and close it.

8.

Use the

Report

button to create a report based on the

Country

table. Save the report

with the name

CountryList

. With the report open in Layout View, change the label to

Country Report

in the Report Header section. Save the report.

9.

Switch the

CountryList

report to Layout view, then change the

CountryCode

label to

Code

, and the

CountryName

label to

Name

. Resize the height of the text box that

counts the number of records in the left side of the Report Footer section to clearly

display the count, 13 as shown in Figure 2. Save the report and close it.

Figure 2: CountryList Report in Layout View

10.

Use the Report Wizard to create a report based on the

Project

and

Consultant

tables with

the following options:

a.

Include the

Description

and

Months

fields from the

Project

table and the

LastName

from the

Consultant

table in the report.

b.

Choose to view your data

by Consultant

.

c.

Use

LastName

as the grouping field.

d.

Sort the records by

Description

in ascending order.

e.

Select Stepped as the layout and Portrait as the orientation.

f.

Change the title of the report to

ProjectsByConsultant

and preview it.

Close the

ProjectsByConsultant

report.

11.

Open the

ConsultantsByProject

form in Layout View, open the property sheet, and

perform the following tasks:

a.

Change the border style

of the

Description

label to

Transparent

.

b.

Change the font size of the

Global Human Resources Consultants

label in the Form

Header to

20

. Save the

ConsultantsByProject

form and close it.

12.

Open the

Consultant

report in Design View and apply

conditional formatting

to the

values in the

Salary

text box so that if the field value is equal to 71,000, the field's font

color is set to

red

(row 7, column 2 on the standard color palette) and the font is

bold

.

Save the report.

13.

With the

Consultant

report still open in Design View, change the font color of the label in

the Report Header section to

dark blue

(row 7, column 9 in the Standard Colors palette.)

Save the

Consultant

report, view it in Report View to review the changes, and close the

report.

14.

Open the

ConsultantStartDate

form in Design View and perform the following tasks:

a.

Resize the width of the form to the

6.5"

mark on the horizontal ruler.

b.

Change the

background color

for the

Consultant StartDate Form

label in the Form

Header section to

Light

Blue 3

(row 4, column 5 in Standard Colors palette).

c.

Change the font for the

Consultant StartDate

Form

label in the Form Header

section to

Georgia

.

Save the

ConsultantStartDate

form and close it.

15.

Open the

ProjectLandscape

report in Layout View and apply the

Georgia

font scheme

from the theme fonts to this object only. Save and close the report.

16.

Open the

ConsultantResides

report in Layout View and perform the following tasks:

a.

Change the layout of the report to

Portrait

.

b.

Move the

Reside

column so that it appears between the

ConsultantID

and

LastName

columns.

Save the

ConsultantResides

report and close it.

17.

Open the

ClientFees

form in Design View and perform the following tasks:

a.

Delete the

=Date()

and =

Time()

text boxes in the Form Header section.

b.

Apply the Office Theme to this object only.

Save the

ClientFees

form and close it.

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.