Homework answers / question archive / Illustrated Access 2016 | Module 3: SAM Project 1b Conventions Database USING FORMS GETTING STARTED ? Open the file IL_AC16_3b_ FirstLastName _1

Illustrated Access 2016 | Module 3: SAM Project 1b Conventions Database USING FORMS GETTING STARTED ? Open the file IL_AC16_3b_ FirstLastName _1

MS Access

Share With

---

Illustrated

Access 2016 | Module 3: SAM Project 1b

Conventions Database

USING FORMS

GETTING STARTED

?

Open the file

IL_AC16_3b_

FirstLastName

_1.accdb

, available for download

from the SAM website.

?

Save the file as

IL_AC16_3b_

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 file dialog

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

?

To complete this Project, you will also need to download and save the following

support file from the SAM website:

o

Support_IL_AC16_3b_Logo.png

?

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.

Use the Form Wizard to create a form based on the

Conventions

table with the

following options:

a.

Include all fields from the

Conventions

table in the form.

b.

Select the

Columnar

layout for the form.

c.

Set the title of the form to

Convention Entry Form

, then open it in

Design View.

2.

With the

Convention Entry Form

open in Design View, set the Default value

property of the CountryName text box to

USA

. Save the form, then switch to

Form View.

3.

In the

Convention Entry Form

, navigate to the record with the

ConventionNo

field value 6. Change the

MaxAttendees

field value of this record from 1000 to

2000

.

4.

In the

Convention Entry Form

, add a new record to the

Conventions

table with

the field values shown in Figure 1 on the next page. (

Hint

: The

ConventionNo

field is an AutoNumber field.)

Figure 1: Convention Entry Form

5.

Switch to Layout View for the

Convention Entry Form

, then change the font of

the

Convention Entry Form

label in the Form Header section to

Verdana

and

change the label’s font size to

16 pt.

Save and close the

Convention Entry

Form

.

6.

Create a split form based on the

Conventions

table, then save the form as

Conventions Split Form

.

7.

Switch to Form View for the

Conventions

Split Form

. Navigate to the record with

the

ConventionNo

field value 16. Change the

ConventionName

field value for

this record from Distance Learning Institute to

Flexible Learning Institute

.

Save and close the

Conventions

Split Form

.

Use Figure 2 on the next page as a reference when modifying the

Attendees Information

Form

in Steps 8–18.

Figure 2: Attendees Information Form

8.

Open the

Attendees Information Form

in Design View, then change the

Attendees Form

label in the Form Header section to

Attendees Information

Form

.

9.

With the

Attendees Information Form

still open in Design View, delete the

“Company logo goes here”

label in the Form Header section.

10.

With the

Attendees Information Form

still open in Design View, complete the

following tasks:

a.

Insert the file

Support_IL_AC16_3b_Logo.png

, available for download

from the SAM website, at the top of the Form Header section, at the 4"

mark on the horizontal ruler.

b.

Resize the image to position it at the top of the Form Header section,

between the 4" and 5" marks on the horizontal ruler, and between the 0"

and 1" marks on the vertical ruler.

11.

In the

Attendees Information Form

, drag the right edge of the form to the left,

so that the form is only 5" wide.

12.

In the

Attendees Information Form

, drag the top edge of the Detail section up,

so that the Form Header section is 1" tall.

13.

In the

Attendees Information Form

, select all six labels in the Detail section of

the

Attendees Information Form

, then right-align the text within the labels.

(

Hint

: Do not right-align the controls in the form.)

14. 

In the

Attendees Information Form

, make the following changes:

a.

Delete the CompanyID label.

b.

Move the CompanyID text box to the right of the CompanyName text box.

c.

Position the CompanyID text box so that the left edge is at the 5" mark on

the horizontal ruler and the top edge is aligned with the top edge of the

CompanyName text box. (

Hint

: This will expand the form to about 6"

wide.)

15.

In the

Attendees Information Form

, resize the AttendeeFirst text box so that it is

approximately the same width as the AttendeeLast text box.

16.

In the

Attendees Information Form

, change the Tab Stop property for the

AttendeeNo text box to

No

.

17.

In the

Attendees Information Form

, change the tab order for the form so that

the

AttendeeFirst

field is first.

18.

In the

Attendees Information Form

, add a new text box to the Detail section of

the form below the CompanyName text box. Modify the new text box and its

associated label using the following options:

a.

Change the new label text to

Expenses

.

b.

Enter the expression

=[Transportation]+200*[Nights]

in the text box.

c.

Change the Format property for the new text box to

Currency

.

d.

Switch to Layout View, then move and resize the new label and text box as

shown in Figure 2 on the previous page.

e.

Save the

Attendees Information Form

.

19.

Switch to Form View for the

Attendees Information Form

, then navigate to the

last record in the form. (

Hint

: The

AttendeeNo

field value for this record is

384.) Change the

AttendeePhone

field value for this record to

555-222-4321

.

20.

In the

Attendees Information Form

, navigate to the second record. (

Hint

: The

AttendeeNo

field value for this record is 2.) Change the

AttendeeLast

value for

this record from Apple to

Green

.

21.

In the

Attendees Information Form

, use the Find feature to find the record in

which the

AttendeePhone

field value equals

555-111-3016

. Change the

AttendeeFirst

field value for this record from Stephen to

Steven

. Save and

close the

Attendees Information Form

.

Save and close any open objects in your database. Compact and repair your database,

close it, then exit Access. Follow the directions on the SAM website to submit your

completed project.