Homework answers / question archive / Illustrated Access 2016 | Module 1: SAM Project 1a Volunteer Service Hours Database CREATING A TABLE AND BUILDING A RELATIONSHIP GETTING STARTED ? Open the file IL_AC16_1a_ FirstLastName _1

Illustrated Access 2016 | Module 1: SAM Project 1a Volunteer Service Hours Database CREATING A TABLE AND BUILDING A RELATIONSHIP GETTING STARTED ? Open the file IL_AC16_1a_ FirstLastName _1

MS Access

Share With

---

Illustrated Access 2016 | Module 1: SAM Project 1a

Volunteer Service Hours Database

CREATING A TABLE AND BUILDING A RELATIONSHIP

GETTING STARTED

?

Open the file

IL_AC16_1a_

FirstLastName

_1.accdb

, available for download

from the SAM website.

?

Save the file as

IL_AC16_1a_

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.

?

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.

Create a new table in Design View as follows:

a.

Add a field with the name

InvolvementID

and the AutoNumber data type.

b.

Set the

InvolvementID

field as the table’s primary key.

Save the table with the name

Involvement

, but do not close it.

2.

With the

Involvement

table still open in Design View, add a second field to the

table using the field name

MemberNo

and the Number data type.

3.

In Design View, add a third field to the

Involvement

table using the field name

EventName

and the Short Text data type.

4.

In Design View, add a fourth field to the

Involvement

table using the field name

EventDate

and the Date/Time data type.

5.

In Design View, add a fifth field to the

Involvement

table using the field name

HoursDonated

and the Number data type. Save the

Involvement

table and

switch to Datasheet View.

6.

In Datasheet View, enter the two records shown in Table 1 below into the

Involvement

table. Close the

Involvement

table and save it, if necessary.

Table 1: New Records for Involvement Table

InvolvementID

MemberNo

EventName

EventDate

HoursDonated

1

1

Adair Project

7/1/2019

5

2

2

Scout Camp

8/1/2019

7.

Open the

Members

table in Design View. Change the name of the field named

First

to

MemberFirst

, then change the name of the field named

Last

to

MemberLast

.

8.

With the

Members

table still open in Design View, change the data type

property of the

Bio

field to Long Text.

9.

In Design View, add a new field to the

Members

table after the

Bio

field. The

field should be named

CellPhone

and have the Short Text data type. Save and

close the

Members

table.

10.

Create a new relationship in the database as described below:

a.

Open the Relationships window, then add the

Involvement

table to it. Close

the Show Table dialog box.

b.

Create a one-to-many relationship between the

Members

and

Involvement

tables using the common

MemberNo

field.

c.

Enforce referential integrity on the relationship.

Save and close the Relationships window.

11.

Open the

Members

table in Datasheet View. Find, select, and delete the record with the

MemberNo

field value 32 (and the

MemberFirst

and

MemberLast

field values Taney

Wilson) from the

Members

table.

12.

With the

Members

table still open in Datasheet View, navigate to the record with the

MemberNo

field value 10 (and the

MemberFirst

and

MemberLast

field values Allie Pitt),

then change the

MemberLast

field value to

Espinoza

.

13.

With the

Members

table still open in Datasheet View, navigate to the record with the

MemberNo

field value 35 (and the

MemberFirst

and

MemberLast

field values Joshua

Parton), then change the

Street

field value to

202 Adams St.

(

Hint:

be sure to include

the period.) Close the

Members

table and save it, if necessary.

14.

Open the

Members

table in Datasheet View, then expand the subdatasheet for

MemberNo 2. (

Hint

: You should see one related record from the

Involvement

table.) In

the subdatasheet, change the value of the

EventName

field to

Boy Scout Camp

. Close

the

Members

table.

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

database using the Compact and Repair Database button on the Database Tools

tab of the Ribbon, close it, then exit Access. Follow the directions on the SAM

website to submit your completed project.