2009-02-20

Case Study 2 - The Outsourcing Bookkeeping and Payroll Company

In this case, i have designed a relational database for a company that offers bookkeeping and payroll services to other companies. Then I have created database tables and populated them with data. Next, A form was created for the employees of the firm to record their hours worked for clients. Then, I have created two queries: one to list all the accounts in a given town, and another to calculate the number of hours worked on a given day for each client. This case has two reports: one to display client accounts grouped by town, and one to report the number of hours worked on each type of task.


Deliverables

1. Word-processed design of tables
2. Tables created in Access
3. Form: Jobs Input
4. Query 1: Sales Calls
5. Query 2: Hours Worked Per Client
6. Report 1: Clients by Zip
7. Report 2: Workers and Times for Each Client



1. Word-processed design of tables


2. Tables created in Access

Client Table

Employee Table

Transaction Table



3. Form: Jobs Input


4. Query 1: Sales Calls

Query Prompt

Query Result



5. Query 2: Hours Worked Per Client


6. Report 1: Clients by Zip


7. Report 2: Workers and Times for Each Client

8 Responses to “Case Study 2 - The Outsourcing Bookkeeping and Payroll Company”

  • Curtis says:
    July 18, 2011 at 10:54 PM

    I want to download some tools or software that can help me in studying the payrolling. Well, your blog has shared nice things regarding payrolling services. Thanks for sharing these things.

    payroll company

  • Curtis says:
    July 19, 2011 at 10:12 PM

    Outsourcing payroll is a cost effective solution, mostly if you outsource people located in countries that have economic status lower than yours. You can help them earn money and they can help you as well by providing efficient services with low costs.

    payroll service

  • ethanparker says:
    July 24, 2011 at 10:05 PM

    Payroll companies handle employee related issues along with federal and state regulatory issues as well. Payroll will also eliminate the necessity for you to become an expert on topics such as withholding amounts.
    payroll company

  • arronbond says:
    September 30, 2011 at 2:24 AM

    In accounting, payroll refers to the amount paid to employees for services they provided during certain period of time.

    Payrolling

  • Unknown says:
    February 17, 2012 at 10:21 PM

    Accounting outsourcing solutions is nothing but giving your human resources perform to be managed by a third party. Sales companies are run by professional professionals to do your perform and make you focus on Generation and Marketing of your goods and solutions.

    Taxation software

  • Uhlenbrock CPA says:
    January 12, 2018 at 4:51 AM

    I had a look with the tables that you made to help us to understand the details of the payroll services.
    Thanks for sharing such a great blog with the detailed information. I was searching for professional payroll service in San Antonio and got this blog.
    Waiting for your new blog.

  • Graphics says:
    September 19, 2021 at 12:54 PM

    Hi, I find reading this article a joy. It is extremely helpful and interesting and very much looking forward to reading more of your work.. Bookkeeping Vancouver

  • abaan sheikh says:
    October 13, 2021 at 4:52 AM

    This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Outsourced bookkeepers

Post a Comment