Assignment 5: Creating the Babbage Bookkeeping Database

Problem: Babbage Bookkeeping is a local company that provides bookkeeping services to several small businesses in the area. The database consists of two tables.

  1. The Client table: This table contains information on the businesses that use Babbage’s services.
  2. The Bookkeeper table: This table contains information on the bookkeeper assigned to the business.

Instructions: Perform the following tasks:

  1. Create a new database in which to store all the objects related to the bookkeeping data.
  1. Save this database. The database must be named with Your Last Name + First Name + Assignment5. For example, if your name is John Smith, the file must be named: SmithJohnAssignment5. 5% will be deducted for the wrong filename.
  1. Create the Client table using the structure and data shown in the table below:Save the table as “Client Table.”

ClientTable

1

Field Name / Data Type / Field Size / Primary
Key / Description
Client Number / Text / 3 / Yes / Client Number (Primary Key)
Name / Text / 20 / Name of Client
Address / Text / 15 / Street Address
City / Text / 15 / City
Zip Code / Text / 5 / Zip Code (5 Character Version)
Balance / Currency / Amount Currently Owed for Services
Bookkeeper Number / Text / 2 / Number of Client’s Bookkeeper

1

  1. Enter the data for the Client Table as shown in the table below:

  1. Create the Bookkeeper table using the structure and data shown in the table below:Save the table as “Bookkeeper Table.”

Bookkeeper Table

1

Field Name / Data Type / Field Size / Primary
Key / Description
Bookkeeper Number / Text / 3 / Yes / Bookkeeper Number (Primary Key)
Last Name / Text / 10 / Last Name of Bookkeeper
First Name / Text / 8 / First Name of Bookkeeper
Address / Text / 15 / Street Address
City / Text / 15 / City
Zip Code / Text / 5 / Zip Code (5 Character Version)
Hourly Rate / Currency / Hourly Rate
YTD Earnings / Currency / Year-to-Date Earnings

1

  1. Enter the data for the Bookkeeper Table as shown in the table below:
  1. Create a report as shown below:Save this report as “Balance Due Report” (Office Style)

  1. Once you have completed an assignment, copy and paste the file in the "Drop Of" box in the computer lab. No other means of submission will be accepted.Make sure that the filename is correct before dropping it.

Reminder: The file must be named as Your Last Name + First Name + Assignment5. For example, if your name is John Smith, the file must be named: SmithJohnAssignment5. 5% will be deducted for the wrong filename.

1