WIKI Assignment

Here is the complete list of our wiki topics. Subject for approval. Please do let me know about your comments and changes.

Assigned Wiki Topic

click here

Summarized Topics

click here

click here to link Zachman Business Enterprise Framework
download ZachmanFramework.pdf mirror1
download ZachmanFramework.pdf mirror2
start your article here itpro20809 wiki

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