Homework answers / question archive / Shelly Cashman Access 2016 | Module 8: SAM Project 1a West Coast Outdoor Advertisers MACROS, NAVIGATION FORMS, CONTROL LAYOUTS GETTING STARTED   Open the file SC_AC16_8a_ FirstLastName _1

Shelly Cashman Access 2016 | Module 8: SAM Project 1a West Coast Outdoor Advertisers MACROS, NAVIGATION FORMS, CONTROL LAYOUTS GETTING STARTED   Open the file SC_AC16_8a_ FirstLastName _1

MS Access

Share With

---

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

West Coast Outdoor Advertisers

MACROS, NAVIGATION FORMS, CONTROL LAYOUTS

GETTING STARTED

 

Open the file

SC_AC16_8a_

FirstLastName

_1.accdb

, available for download

from the SAM website.

 

Save the file as

SC_AC16_8a_

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 Advertiser Financial Report

macro in Design View. Change the

View argument to

Print Preview

. Save the change to the macro, and then

close the

Preview Advertiser Financial Report

macro.

2.

The

Open Basic Billboards List

macro contains an error. Complete the following

tasks to correct the macro:

a.

Open the

Open Basic Billboards

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 Billboards List

report in Print Preview mode.)

e.

Click the

Single-Step

button again to deselect it.

Save and close the

Open Basic Billboards 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 Billboard Table

as the

name for the submacro.

c.

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

Billboard

table

in Datasheet View and in Edit data mode.

d.

Add a second submacro to the macro, using

Open Rentals Table

as the

name for the macro.

e.

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

Rentals

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

Rentals

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.i

5.

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

Rentals

table.

Figure 2: Data Macro for a Before Change Event

6.

Create a Datasheet form based on the

States

table, and then save the form with

the default name

States

. Close the form.

7.

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

a.

Use the

Horizontal Tabs

layout.

b.

Add the

AdRep

,

Advertiser

, and

Rentals

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

8.

Open the

Advertiser

form

in Datasheet View, and then complete the following

tasks to create a UI macro for the form:

a.

Select the

AdvertiserID

column. (

Hint

: The

AdvertiserID

column has the

caption “AdvID”.)

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

Advertiser Master Form

when a user

selects a value in the

AdvertiserID

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.

Figure 4: UI Macro Associated with an On Click Event in the Advertiser

Form

9.

Open the

Main Menu Navigation Form

in Layout View, and then complete the

following tasks:

a.

Add the

Forms List

form to the

Main Menu Navigation Form

as the last

horizontal tab.

b.

Rename the Forms List tab as

Master Forms

. (

Hint:

Do not type the

period.)

c.

Move the AdRep tab so that it appears first in the list.

Confirm that the form matches Figure 5 on the next page, and then save and

close the form.

Figure 5: Main Menu Navigation Form – Form View

10.

Open the

Open Master Forms

form

in Design View, and then add a command

button to the form in the approximate position shown in Figure 6 on the next

page. Use the Command Button wizard to create the command button while

incorporating the following options:

a.

Select

Miscellaneous

as the category and

Run Macro

as the action.

b.

Select

Forms Macro.Open Rentals Master Form

as the macro.

c.

Select the

Text

option, and then enter the text

Open Rentals Master

Form

. (

Hint

: Do not type the period.)

d.

Name the command button

Open_Rentals_Master_Form

. (

Hint

: Do not

type the period.)

Save the changes to the form.

11.

With the

Open Master Forms

form still open in Design View, complete the

following tasks:

a.

Select the three buttons on the form, and then use the Size/Space menu

to adjust the size to

To

Widest

.

b.

Use the Size/Space menu to adjust the spacing of the button controls to

Equal Vertical

.

c.

Align the buttons to the

Left

.

d.

Anchor the controls to the

Top Left

corner of the form.

Confirm that your form matches Figure 6, and then save and close the

Open

Master Forms

form.

Figure 6: Open Master Forms Form – Design View

12.

Open the

AdRep Layout Form

in Layout View, and then modify the form to

match Figure 7 on the next page by completing the following tasks:

a.

Select the cell containing the value for the

FirstName

field, and then split

the cell

horizontally

.

b.

Delete the

LastName

label.

c.

Move the cell containing the value for the

LastName

field to the position

shown in Figure 7 (to the right of the

FirstName

field in the cell created in

Step 11a).

d.

Change the

FirstName

label to

AdRep Name

(including the space), as

shown in Figure 7.

e.

Move the

DateHired

label and

DateHired

field to the position shown in

Figure 7.

f.

Select the control layout for the form, and then change the control

margins to

Medium

and the control padding to

Narrow

.

Save and close the form.

Figure 7: AdRep Layout Form – Layout View

13.

Open the

States and Billboards Tabular Report

in Layout View. Select the control

layout, and then change the report layout to

Stacked

as shown in Figure 8 on

the next page. (

Hint

: To select a control layout, click the four-headed arrow in

the upper-left corner of the report.) Save the change to the report, and then

close it.

Figure 8: States and Billboards Tabular Report – Layout View

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.