Tutorial on MS Access Payroll Application

Written by bennett gavrish Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
Tutorial on MS Access Payroll Application
You can set up a payroll application in Microsoft Access using the time card template. (keyboard image by Fyerne from Fotolia.com)

The Microsoft Office software suite includes a database development program called Microsoft Access. When you start using the Access application, you have the option to either build a database from scratch or use one of the many template files provided. Microsoft Access comes with a time card template, which allows you to build a database application for tracking your organisation's payroll.

Skill level:


  1. 1

    Launch the Microsoft Access application on your PC computer and wait for the "Welcome" window to appear.

  2. 2

    Go to the "Business" tab in the list of template categories on the left side of the window.

  3. 3

    Highlight the "Time Card" template in the main part of the window.

  4. 4

    Enter a name for the database application you are creating, choose where you want to save it and then press the "Download" button. Access will now download a copy of the Time Card template and save it onto your computer.

  5. 5

    Enter employee names, pay rates and hours worked in the appropriate fields of the grid that appears.

  6. 6

    Click on the "Navigation Panel" on the far left side of the database screen to see a list of the payroll reports you can run.

  7. 7

    Click on the name of a report to view its contents. For example, the "Billable Hours by Employee" report will display the total number of hours and corresponding pay accrued by each employee in the database.

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 eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.