Access 2016 In Practice Guided Project 1 2 Instructions AC2016

User Manual:

Open the PDF directly: View PDF .
Page Count: 6

Download
Open PDF In Browser	View PDF

USING MICROSOFT ACCESS 2016

Guided Project 1-2

Guided Project 1-2
American River Cycling Club is a local cycling club. For this project, you create a database, containing one table, to store
information about club members. After creating the database, add fields into the table, edit field properties, enter records,
modify the datasheet layout, import data and sort and filter the data in the table. This project has been modified for use
in SIMnet®.

Skills Covered in This Project
•
•
•
•
•

•
•
•
•
•

Create a table.
Edit the default primary key.
Add a new field into a table.
Edit properties in Datasheet view.
Save a table.

Enter records.
Change the datasheet layout.
Import records.
Sort data in a table.
Filter data in a table.

IMPORTANT: Download the resource file(s) needed for this project from the Resources link. Make sure to extract the
file(s) after downloading the resources zipped folder. Please visit the SIMnet instant help for step-by-step instructions.

Step 1:
Download
start file

1. Open the AC2016-GuidedProject-1-2 database start file.
a. Enable content in the security warning.
b. The file will be renamed automatically to include your name. Change the project file name if
directed to do so by your instructor.
c. Click the Table button [Create tab, Tables group] to create a new table. A new table opens
in Datasheet view.
2. Edit the default primary key and add new fields into the table.
a. Double-click the cell containing the ID field name (column header).
b. Type MemberID in the Field name and press the Enter key. The Click to Add column to the
right is selected so you can add the next field into the table.
c. Select the Short Text data type for this new field.
d. Type FirstName in the Field1 column header and press the Enter key.
e. Select the Short Text data type.
f. Type LastName in the Field1 column header and press the Enter key.
g. Add the remaining fields into the table using the information in the nearby table. Remember
that you select the data type first and then enter the field name. After you enter the last field
name, CellPhoneNumber, press the down arrow key to remain in that column.
Data Type

Fi eld Name

Short Text

Address

Short Text

City

Short Text

l

I

State

Short Text

ZIPCotle

Hyperlink

Emai!Address

Short Text

CellPhoneNumber

h. Press Ctrl+S to save all of the modifications you have made to the table.
i. Type Members as the new table name.
j.

Click OK.

Access 2016 Chapter 1 Creating a Database and Tables

Last Updated: 12/29/17 Page 1

USING MICROSOFT ACCESS 2016

Guided Project 1-2

3. Edit the field properties of the Members table.
a. Click the MemberID field name.
b. Click the Name & Caption button [Table Tools Fields tab, Properties group].
c. Type Member ID in the Caption property. Because the field names in this table provide
a clear description of the content, it is not necessary to enter anything into the
Description property.
d. Click OK.
e. Select the FirstName field name.
f. Click the Name & Caption button [Table Tools Fields tab, Properties group].
g. Type First Name in the Caption property.
h. Click OK.
i. Type 20 in the Field Size property [Table Tools Fields tab, Properties group].

j.

Change the remaining field properties in the table using the following information:

Last Name

k.

25

Address

45

City

25

State

2

ZIIPCode

ZIP

EmailAddress

Email

CellPhoneNu mber

Cell Phone

5

N/A

12

Click the Save button to save the changes to the table. With the changes to the field
properties saved, the table is ready for you to begin to enter data records. Remember that
even though you have changed the caption that displays as the column header in
Datasheet view, the field names have not changed.

4. Enter the member records into the Members table.
a. Click the FirstName cell in the append row.
b. Type Geneva. The Pencil icon displays, indicating that this record has not yet been saved.
c. Press the Tab key to move to the next field.
d. Type Lingle in the LastName field. Press the Tab key to move to the next field.
e. Type 1850 Stoneridge Court in the Address field. Press the Tab key.
f.

Type Cameron Park in the City field. Press the Tab key.

g. Type CA in the State field. Press the Tab key.
h. Type 95682 in the ZIPCode field. Press the Tab key.
i.

Type glingle@gmail.com in the EmailAddress field. Press the Tab key.

j.

Type 780-886-6625 in the CellPhoneNumber field. Press the Tab key. The Pencil icon no longer
displays. You move to the MemberID field in the append row.

Access 2016 Chapter 1 Creating a Database and Tables

Last Updated: 12/29/17 Page 2

USING MICROSOFT ACCESS 2016
k.

FirstName

Guided Project 1-2

Tab to the next field. Enter the following information into the Members table. Remember that
after you tab out of the CellPhoneNumber field you move to the MemberID field. Since that
is an AutoNumber field, do not enter a value and simply tab to the next field.

hiiifi::·IP·ffiiiii-lllmFJiM/1

Cheryl

Wilson

Ryan

Thomas

7105 High
Street
I

Roy

l"""'"

Folsom

EmailAddress

CellPhoneNumber

916-451-8325

CA

95630

cwilson@mcc.com

rthomas@gmail.com

I

I

I

2227
Alexandra
Drive

Aub urn

CA

95602

705 First
Street

Rocklin

CA

[ 95677

916-753-5586

[ my@<001nrl
column.
1-109 Records sorted on ZIP and Last Name
9. Filter the Members table using
Filter by Selection.
a. Select 916 in the Cell Phone cell for Member ID 2.
b. Click the Selection button [Home tab, Sort & Filter group].

Access 2016 Chapter 1 Creating a Database and Tables

Last Updated: 12/29/17 Page 4

USING MICROSOFT ACCESS 2016

Guided Project 1-2

c. Select Begins with “916” from the drop-down list (Figure 1-110). The datasheet should display
only the seven members who have a cell phone area code of 916.

T
inter

U Ase.ending

Filie.-

:, Spelling
D lcte •

Son:& ri1

:J

:I Totals

ew

SelKtJon •

Uoestendng

at Replace

Calibri

-+ GoTo•

8

Find

~ Select·

Remrds

916

(Gnf,,

Mote •

p

1 G@neva.
2 C1i@ryl
3 Ryan

Qor> Ni,t Coot•RI ~16"

ty

State

ZlP

•

Email

- C II Phone •

1850 5tcmetlcl,i Cameror> l'ar
7105 High SW Folsom

CA

95682 gli')J!le@'fill:!L

CA

95630

222 7 Ale~ nd1 Auburn

CA

Cilek the Selection
button

.A ·

Select916

Momb
Source Exif Data: 
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.6
Linearized                      : Yes
Author                          : Maggie Shores
Comments                        : 
Company                         : 
Create Date                     : 2017:12:29 13:57:27-05:00
Modify Date                     : 2017:12:29 14:35:38-05:00
Source Modified                 : D:20171229185709
Subject                         : 
Has XFA                         : No
Language                        : en
Tagged PDF                      : Yes
XMP Toolkit                     : Adobe XMP Core 5.6-c015 84.159810, 2016/09/10-02:41:30
Metadata Date                   : 2017:12:29 14:35:38-05:00
Creator Tool                    : Acrobat PDFMaker 18 for Word
Document ID                     : uuid:9477dad4-4a99-45c0-907c-89fcf47a0802
Instance ID                     : uuid:e21eb392-df29-4fe2-b01a-fa85e7178964
Format                          : application/pdf
Title                           : Access 2016 In Practice Guided Project 1-2 Instructions
Description                     : 
Creator                         : Maggie Shores
Producer                        : Adobe Acrobat Pro DC 18 Paper Capture Plug-in
Keywords                        : 
Page Layout                     : OneColumn
Page Count                      : 6

EXIF Metadata provided by EXIF.tools