Homework answers / question archive / Shelly Cashman Access 2016 | Module 5: SAM Project 1b All Around Outside Maintenance MULTIPLE-TABLE FORMS GETTING STARTED ? Open the file SC_AC16_5b_ FirstLastName _1

Shelly Cashman Access 2016 | Module 5: SAM Project 1b All Around Outside Maintenance MULTIPLE-TABLE FORMS GETTING STARTED ? Open the file SC_AC16_5b_ FirstLastName _1

MS Access

Share With

---

Shelly Cashman

Access 2016 | Module 5: SAM Project 1b

All Around Outside Maintenance

MULTIPLE-TABLE FORMS

GETTING STARTED

?

Open the file

SC_AC16_5b_

FirstLastName

_1.accdb

, available for download

from the SAM website.

?

Save the file as

SC_AC16_5b_

FirstLastName

_2.accdb

by changing the “1” to

a “2”.

o

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.

Open the

Client

table in Design View. Use the Input Mask Wizard to create an

input mask for the

Phone

field. Accept the default input mask for a Phone

Number field. Store the data without the symbols in the mask. Save the change

to the

Client

table without closing it.

2.

Switch the

Client

table to Datasheet View, and then add a new field named

Client Notes

at the end of the table. Use

Long Text

as the data type for the

field. Save the change to the table.

3.

With the

Client

table still open in Datasheet View, update the record for Cherry

Hill Group (which has the ClientNumber CHG05) as described below:

a.

Using the input mask, enter

856-555-2883

in the

Phone

field.

b.

Enter the text

Manages condo complexes

in the

Client Notes

field.

Close the table.

4.

Open the

Property

table in Design View, and then add a new field named

Property Details

following the

Services

field. Use

Attachment

as the data

type for the field. Save the change to the table, and then close it.

5.

Modify the

Manager Data Entry Form

to match Figure 1 on the following page by

completing the tasks below:

a.

Open the

Manager Data Entry Form

in Design View.

b.

Open the field list for the form.

c.

Add the

PhoneNumber

field to the form in the position shown in Figure 1.

Save and close the

Manager Data Entry Form

.

Figure 1: Manager Data Entry Form – Design View

6.

Select the

Client Types

table, and then create a new form in Design View.

Update the form to match Figure 2 on the following page by completing the

tasks below:

a.

Add the

TypeID

and

Description

fields (from the

Client Types

table) to the

Detail section of the form, in the approximate location shown in Figure 2. If

necessary, reposition the controls and their labels after adding them to

the form.

b.

Save the form with the name

Client Types Data Entry Form

without

closing the form.

c.

Add a title to the form that matches the name of the form.

Save and close the

Client Types Data Entry Form.

Figure 2: Client Types Data Entry Form – Design View

7.

Open the

Manager Master Form

in Design View, and then ensure that the Use

Control Wizards button is selected.

With the

Manager Master Form

still open in Design View, use the

Subform/Subreport Wizard to add a subform with the following options:

a.

Use the

Client

table for the subform.

b.

Select the

ClientNumber

field, the

ClientName

field, and the

Balance

field

from the

Client

table to add to the subform.

c.

Accept the default link (“Show Client for each record in Manager using

ManagerID”) to link the main form to the subform.

d.

Save the subform as

Client subform

(which is the default name).

e.

If necessary, reposition the subform to match the approximate location

shown in Figures 3a and 3b on the following two pages.

Save and close the form.

Figure 3a: Manager Master Form – Form View

Figure 3b: Manager Master Form – Design View

8.

Open the

State-Property Form

in Design View, and then modify it to match

Figures 4a and 4b on the following two pages by resizing the width of the

subform as shown in the figures. (

Hint

: The right edge of the subform is at the

7.0" ruler mark.) Save but do not close the form.

9.

With the

State-Property Form

still open in Design View, modify the form title to

match Figures 4a and 4b by completing the following tasks:

a.

Change the font color of the title to

Dark Red

(1

st

column, 7

th

row of the

Standard Colors palette).

b.

Change the font size of the title text to

20 pt.

c.

Apply the

Sunken

special effect to the title.

Save and close the form.

Figure 4a: State-Property Form – Form View

Figure 4b: State-Property Form – Design View

Shelly Cashman

Access 2016 | Module 5: SAM Project 1b

10.

Open the

Client Financial Form

in Design View, and then modify it by completing

the following tasks:

a.

Delete the

ManagerID

control and its accompanying label.

b.

Change the label for the

ClientType

control to

Business

. (

Hint

: Do not

type the period.)

Save and close the form.

11.

Open the

Property Contact Form

in Design View, and then modify it to match

Figure 5 on the following page by completing the tasks below:

a.

Select the

Address

,

City

, and

State

controls and labels simultaneously.

b.

Adjust the spacing of these fields to have

Equal Vertical

spacing.

Save but do not close the form.

12.

With the

Property Contact Form

still open in Design View, change the tab order

so that users tab to the

ClientName

field immediately after the

PropertyID

field.

(

Hint

: Move the

ClientName

field upward in the tab order.) Save and close the

form.

Figure 5: Property Contact Form – Design View

13.

Open the

Basic Client Form

in Design View, and then change the background

color of the form to

Light Gray 2

(1

st

column, 3

rd

row of the Standard Colors

palette). Save the form, but do not close it.

14.

With the

Basic Client Form

still open in Design View, modify the form to match

Figure 6 on the following page by completing the tasks below:

a.

Select the

ClientName

label,

ClientName

control,

ClientType

label, and

ClientType

control simultaneously. Align the controls to the

Top

.

b.

Select the

AmountPaid

control,

Balance

control, and

TotalAmount

control

simultaneously. Do not select any labels, and make sure the

ClientType

control is

not

selected. Align the controls to the

Left

.

Save but do not close the form.

15.

With the

Basic Client Form

still open in Design View, add a title to the form

using

Basic Client Form

as the name. (

Hint

: This is the default name.) Save,

but do not close the form.

16.

With the

Basic Client Form

still open in Design View, change the Tab Stop

property for the

ClientType

field to

No

. Save and close the form.

Figure 6: Basic Client Form – Design View

17.

Open the

Manager Skills Query

in Design View, and then modify the query to

find all managers who have a

StartDate

before 1/1/2016 and who have skills in

carpentry. (

Hint

: The

Skills

field has the Long Text data type. The query should

return one record.)

Run the query, and then save and close it.

 

Shelly Cashman Access 2016 | Module 5: SAM Project 1b

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.