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