91
ACC
4
your TASK
Your task is to create
an employee database
for The Hub to use
to store payroll
information and then
create a report that
shows only those
employees with a
Married filing status.
the SKILLS
· Createreports
· Sortrecords
K
eepingtrackofemployeeinformationiscriticalforpayrollprocessing.
Withoutknowinganemployee'sfilingstatusandnumberofexemption
allowances,theproperfederalandstateincometaxamountsmaynot
bewithheld.Adatabasecanstorepayrollinformationandemployee's
informationcanbeenteredandqueriedwhenneeded.
1. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftAccess,createanewdatabase.
2. SavethedatabaseasProjectACC-4EmployeeDatabaseinyour"Access"folder
under"TheHub"folder.
3. CreateaNEWtableinDesignView.
4. Setupthedatabasetablewiththestructureprovidedbelow.
Field Name
Data Type
Field Size
SocialSecurityNumber
text
9
FirstName
text
50
LastName
text
50
StreetAddress
text
50
City
text
50
State
text
2
Zip
text
5
PhoneNumber
text
10
FilingStatus
text
15
Allowances
number
Double
5. WhilestillinDesignView,clickontheSocialSecurityNumberfieldname.
6. ClicktheInputMasktextboxintheFieldPropertiespane.
7. ClickontheBuildbuttontotherightoftheInputMask.
8. SelecttheSocialSecurityNumberInputMask.
9. DonotchangetheInputMask.
10. StorethedatawithoutthesymbolsintheMask.
11. ClickonFinish.
12. SavethetableasEMPLOYEESwithoutdefiningaprimarykey.
13. GototheDatasheetViewandenterthedataforeachrecordasshowninFigure
ACC-4.1.
14. AdjusttheFieldNamecolumnwidthsasnecessary.
Employee Database
For Evaluation Purposes Only