Fill This Form To Receive Instant Help
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.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.