How to Create a Payroll Application With Microsoft Access
As your business grows, it becomes harder to perform payroll tasks manually. While it is too difficult to calculate earnings for a couple of employees, a computer payroll accounting application makes things easier. Payroll applications, however, can be expensive and take time to implement and master. Microsoft Office Professional comes with a powerful database application, Microsoft Access, which is ideal for performing these types of tasks. In fact, Microsoft provides owners of Access with an easy-to-use sample database that they can quickly customize to meet their business payroll needs.
Launch Microsoft Access 2010 on your computer.
Click "File" and then "New" on the menu ribbon bar. Click the "Time and Billing" sub-folder under the "Office.com Templates" heading.
Wait for a list of thumbnail images to appear on the screen, and then click the "Time Card" image option.
Enter a name for the new payroll database in the "File Name" field on the right side of the screen. Click the "Download" icon. Wait for the template to download from the Office.com website. Once the template downloads to your computer, it automatically opens in Access.
Click the "Enable Content" button at the top of the screen if prompted to do so.
Click the "Employee List" tab in the new payroll database. Enter name, email address and pay rate information for each employee in the data entry form.
Click the "Work Hours List" tab. Enter information on date and times worked by each employee. Select an employee name from the drop-down list. Click the calendar button on the form to select the date worked and then enter start and end times for the employee's shift.
Click the "Navigation Pane" on the left side of the screen to open it. Click and select one of the payroll reports listed to review amounts due to employees or summary totals for a specific time or pay period.
References & Resources
- Microsoft Office: Getting Started with Access 2010
- City University of New York: Microsoft Access 2007 Tutorial
- "Exploring Microsoft Office Access;" Robert T. Grauer, Maruie Wigman Lockley, and Keith Mulbery; 2008
- "Using Microsoft Access 2010;" Allison Balter; 2010
- "Access 2010 Bible"; Michael R. Groh; May 2010
- Microsoft Office: Introduction to the Access 2010 Templates