how will you prepare pay role using ms Acess
Answers
STEP 1: CREATE MAIN BASIC TABLe
STEP 2: CREATE QUERY FOR BASIC MAIN TABLE
STEP 3: CREATE PAY SHEET DETAILS
STEP 4: CREATE A SALARY SLIP
STEP 5: CREATE A FORM TO ENTER
DATA
STEP 6: ENTER STAFF DETAILS
# Capricorn answer .
Answer:
Payroll processing is an essential business function that involves arriving at the 'net pay' of the employees after the adjustment of necessary taxes and deductions. For an efficient payroll management process, the payroll administrator needs to plan the payroll process
Explanation:
Step 1
Launch Microsoft Access 2010 on your computer.
Step 2
Click "File" and then "New" on the menu ribbon bar. Click the "Time and Billing" sub-folder under the "Office.com Templates" heading.
Step 3
Wait for a list of thumbnail images to appear on the screen, and then click the "Time Card" image option
Step 4
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.
Step 5
Click the "Enable Content" button at the top of the screen if prompted to do so.
Step 6
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.
Step 7
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.
Step 8
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.