How to build an employee database with Microsoft Access

Written by andy madeley Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to build an employee database with Microsoft Access
Microsoft's Access database can make light work of HR reporting. (Microsoft Corporation)

Microsoft Access 2013 database software is simple to use yet sophisticated enough to create powerful database applications, if you know how to use it properly. Microsoft have helped get you started by including a range of templates to enable you to quickly build a useful employee database.

Skill level:
Moderately Easy

Things you need

  • Internet connection

Show MoreHide


  1. 1

    Click on the Microsoft Access icon found on Windows 8 Start screen or right-click on an empty area of the desktop, click on "All Apps" then find and click the Microsoft Office icon.

  2. 2

    Enter "time card" in the Search box at the top of the Access start-up screen,

  3. 3

    Click the "Time Card" icon then enter a name for the database in the "File Name" box then click "Create."

  4. 4

    Click "Enable Content" underneath the menu bar if prompted to do so by a security warning.

  5. 5

    Click the "Employee List" tab to add names, email addresses and pay rates for each employee.

  6. 6

    Click the "Work Hours List" tab to add date and times worked. Select an employee name from the drop-down list then click the calendar button on the form to select the date worked and then enter start and end times for the employee's shift.

  7. 7

    Click the "Save" icon on the menu bar to save the changes to your database.

Tips and warnings

  • You can use the Microsoft Access “Help” feature for ideas and assistance.
  • You will need an Internet connection for Access to find and automatically download the time card template.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.