clydebalaman

2009-02-23

WIKI Assignment

Clyde Balaman - 3:05 AM - 0 comments

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

2009-02-20

Case Study 2 - The Outsourcing Bookkeeping and Payroll Company

Clyde Balaman - 5:26 PM - 8 comments

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

2009-02-06

Case Study 1 - The Misty Valley Country Inn

Clyde Balaman - 10:44 PM - 0 comments

Here's my case study 1 The Misty Valley Country Inn.
Setting up a relational database to create tables, queries, and reports. In this case, I have created a relational database for a country inn. Then, I have also created three tables and populate them with data. Next, the two queries: a Summation query and a Parameter query. Finally, the report that shows the revenue received from customers.

DELIVERABLES


     1. Printouts of three tables
     2. Query output: Money Generated by Room
     3. Query output: Rooms Booked the Week of 12/12/05
     4. Report: Revenue From Customers—December 2005
     5. Link to the database file

1.Printouts of three tables