Assignment: Creating the Babbage Bookkeeping Database
Problem: Babbage Book keeping 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: contains information on the businesses that use Babbage's services.
2. The Bookkeeper table: contains information on the bookkeeper assigned to the business.
Instructions: Perform the following tasks:
1. Create a new database to store all the objects related to the bookkeeping data.
2. Save this database. The database must be named with Your Last Name + First Name + Assignment6. For example. if your name is John Smith, the file must be named: SmithlohnAssignment6. 5%will be deducted for the wrong filename.
3. Create the Client table using the structure and data shown in the table below: Save the table as "Client Table."
|
Client Table
|
|
Field Name
|
Data Type
|
Field Size
|
Primary key
|
Description
|
|
Client Number
|
Short Text
|
3
|
Yes
|
Client Number (Primary Key)
|
|
Client Name
|
Short Text
|
20
|
|
Name of Client
|
|
Address
|
Short Text
|
15
|
|
Street Address
|
|
City
|
Short Text
|
15
|
|
City
|
|
Zip Code
|
Short Text
|
5
|
|
Zip Code
|
|
Balance
|
Currency
|
|
|
Amount Currently Owed for Services
|
|
Bookkeeper Number
|
Short Text
|
2
|
|
Bookkeeper Number
|
Assignment link -
https://www.dropbox.com/s/pewqshz7oylv26w/Assignment.rar?dl=0