83
ACC
1
your TASK
The Hub would like
to design a custom
database in Access
to hold membership
information. Your task
is to create the field
names, types, and sizes
in a blank database
and then enter data
for ten new members.
Since The Hub gives
all employees a free
membership, enter an
eleventh record for
yourself.
the SKILLS
· Enterfieldnames
· Definefielddata
types
· Definefieldsize
· Enterdata
· Usedesignview
C
lubsandassociationsoftenneedeasywaystoaccesscriticalinformation
aboutmembers.Anelectronicdatabase,createdinaprogramlike
MicrosoftAccess,isonewaytoenter,display,andlookupmembers'
addresses,phonenumbers,andemailaddresses.Adatabasenotonlymakes
dataentryeffortless,itmakessearching,sorting,andreportingpainless.
1. Usethetabkeytomovequicklythroughfieldswhenenteringrecorddata.
2. Beconsistentwithcapitalizationandabbreviationswhenenteringdatainnew
records.
3. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftAccess,createanewdatabase.
2. SavethedatabaseasProjectACC-1MembershipDatabaseinyour"Access"
folderunder"TheHub"folder.
3. CreateaNEWtableinDesignView.
4. Setupthedatabasetablewiththestructureprovidedbelow.
Field Name
Data Type
Field Size
FirstName
text
50
LastName
text
50
StreetAddress
text
50
City
text
50
State
text
2
Zip
text
5
PhoneNumber
text
15
Email
text
50
5. WhilestillinDesignView,clickonthePhoneNumberfieldname.
6. ClicktheInputMasktextboxintheFieldPropertiespane.
7. ClickontheBuildbuttontotherightoftheInputMask.
8. SelectthePhoneNumberInputMask.
9. DonotchangetheInputMask.
10. StorethedatawithoutthesymbolsintheMask.
11. ClickonFinish.
12. SavethetableasADDRESSESwithoutdefiningaprimarykey.
13. GototheDatasheetViewandenterthedataforeachrecordasshowninFigure
ACC-1.1.
Note:
Be consistent with your method of entry. For example, type all the state
abbreviations in all caps.
Membership Database
For Evaluation Purposes Only