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

All Around Outside Maintenance

MACROS, NAVIGATION FORMS, CONTROL LAYOUTS

GETTING STARTED

Open the file

SC_AC16_8b_

FirstLastName

_1.accdb

, available for download

from the SAM website.

Save the file as

SC_AC16_8b_

FirstLastName

_2.accdb

by changing the “1” to

a “2”.

o

Hint

: If you do not see the

.accdb

file extension

in the Save As dialog box,

do not type it. Access will add the file extension for you automatically.

Open the

_

GradingInfoTable

table a

nd 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

Preview Client Financial Report

macro in Design View. Change the

View argument to

Print Preview

. Save the change to the macro, and then

close the

Preview Client Financial Report

macro.

2.

The

Open Basic Property List

macro contains an error. Complete the following

tasks to correct the macro:

a.

Open the

Open Basic Property List

macro in Design View.

b.

Click the

Single-Step

button.

c.

Run the macro.

d.

Correct the error. (

Hint

: The macro should open the

Basic Property List

report in Print Preview mode.)

e.

Click the

Single-Step

button again to deselect it.

Save and close the

Open Basic Property List

macro.

3.

Create a new macro with two submacros by following the directions below:

a.

When the Macro Design window opens, display the Action Catalog.

b.

Add the first submacro to the macro, using

Open Property Table

as the

name for the submacro.

c.

In the first submacro, use the OpenTable action to open the

Property

table

in Datasheet View and in Edit data mode.

d.

Add a second submacro to the macro, using

Open Client Table

as the

name for the macro.

e.

In the second submacro, use the OpenTable action to open the

Client

table

in Datasheet View and in Edit data mode.

f.

Save the macro with the name

OpenTables

.

Confirm that your macro matches Figure 1 below, and then close the macro.

Figure 1: OpenTables Macro

4.

Open the

Client Types

table in Datasheet View, and then create a data macro

for the table by completing the following tasks:

a.

Click the

Before Change

button on the Table Tools tab.

b.

Create the macro shown in Figure 2 on the next page.

Save and close the macro, and then save and close the

Client Types

table.

Figure 2: Data Macro for a Before Change Event

5.

Create a Datasheet form based on the

State

table, and then save the form with

the default name

State

. Close the form.

6.

Create a Navigation form for the database with the following options:

a.

Use the

Horizontal Tabs

layout.

b.

Add the

Manager

,

Client

, and

Property

Datasheet forms to the Navigation

form in that order.

c.

Change the title (in the Form Header) to

Basic Navigation Form

. (

Hint:

Do not type the period.)

d.

Save the navigation form with the name

Basic Navigation Form

. (

Hint:

Do not type the period.)

Confirm that your form matches Figure 3 on the next page. Save and close the

Basic Navigation Form

Figure 3: Basic Navigation Form – Form View

7.

Open the

Client

form

in Datasheet View, and then complete the following tasks

to create a UI macro for the form:

a.

Select the

ClientNumber

column. (

Hint

: The

ClientNumber

column has the

caption “CL#”.)

b.

Click the

Property Sheet

button.

c.

Click the

Build

button for the On Click event, and then select

Macro

Builder

.

d.

Create a macro that opens the

Client Master Form

when a user selects a

value in the

ClientNumber

column. The macro actions are shown in Figure

4 on the next page.

Save and close the macro, and then save and close the form.

pur-new-sol

Related Questions