Assignment 6: 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: 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. Design a new database to store all the objects related to the bookkeeping data.

1. Save this database. The database

1. Designthe 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

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

KeyAssignment6: Database- E:\\NK Documents\\A Classes\\ Class-SBS-CAB\\A Office 365\\Access Assignment-SBS\\KeyAssignment6.accdb (Access 2007 - 2016 file format) - Access Changchit, Charles - X H 9 File Home Create External Data Database Tools Help Table Fields Table Tell me what you want to do X Cut 2 Ascending Selection New E Totals " Replace Calibri (Detail) 11 [ Copy Save bc Spelling - Go To View Filter A J Descending Advanced Refresh Find Paste Format Painter Select ~ BIUAL M. BEER Remove Sort Y Toggle Filter All ~ X Delete . More Views Clipboard Sort & Filter Records Find Text Formatting > > Client Table > Client Number . Client Name . Address City - Zip Code . Balance . Bookkeeper Number . Click to Add . A54 Afton Mills 612 Revere Grant City 58120 $315.50 22 A62 Atlas Suppliers 227 dandelion Empeer 58216 $500.00 24 B26 Blake-Scripps 557 Maum Grant City 58120 $229.50 D76 Dege Grocery 446 Linton Portage 59130 $485.75 34 G56 Grand Cleaners 337 Abelard Empeer 58216 $265.00 22 H21 Hill Shoes 247 Fulton Grant City 58121 $228.50 24 177 Jones Plumbing 75 Getty Portage 59130 $0.00 34 M26 Mohr Craft 665 Maum Empeer 58216 $312.50 22 $56 SeeSaw Ind 31 Liatris Portage 59130 $362.50 34 T45 Tate Repair 824 Revere Grant City 58120 $254.00 24 $0.00 Navigation Pane Record: 14 4 1 of 10 > > > No Filter Search Num Lock N Client Number (Primary Key)Table Tools KeyAssignment6 : Database- E:\\Nid Document\\A Classes\\Class-SBS-CAB\\Acc... Changchit, Chuleeporn ? X File Home Create External Data Database Tools Fields Table ? Tell me what you want to do To Cut 24 Ascending Ty Selection . New _ Totals O aac Replace Calibri (Detail) BE Copy Al Descending Advanced Save ARE Spelling Go To * View Paste Filter Refresh Find Format Painter 2. Remove Sort Toggle Filter All - X Delete . More Select - BIU AZ . M . = = = 4. 8. Clipboard Sort & Filter Records Find Text Formatting VIEWS Bookkeeper Table Bookkeeper . Last Name . First Name - Address City Zip Code * Hourly Rate . YTD Earnings . Click to Add + 22 Lewes Johanna 26 Cotton Portage 59130 $14.50 $19,245.00 + 24 Rodriguez Mario 79 Marsden Grant City 5812 $13.50 $18,745.50 + 34 Wong Choi 263 Topper Empeer 58216 $14.00 $17,750.25 Navigation Pane Record: 14 4 1 of 3 , No Filter Search Num Lock Client Number (Primary Key) e 9 S Desktop " - * 17 ENG 2:26 PMKeyAssignment6 : Database- E:\\Nid Document\\A Classes\\Class-SBS-CAB\\Access 2013\\Access Assignment-SBS\\KeyAssignment6.accdb (Acces. Changchit, Chuleeporn ? X File Home Create External Data Database Tools ? Tell me what you want to do & Cut 24 Ascending Ty Selection New E Totals O Gac Replace Calibri (Detail) BE Copy Al Descending Advanced Save Spelling Go To * View Paste Filter Refresh Find Format Painter 2. Remove Sort Toggle Filter X Delete . More Select - BIU AZ . M . = = = 4. 8. All - Clipboard Sort & Filter Records Find Text Formatting > > Q29-City-Bookkeeper Crosstab Query City Total Of Balance . 22 24 34 Empeer $1,077.50 $577.50 $500.00 Grant City $1,027.50 $315.50 $712.00 Portage $848.25 $848.25 Navigation Pane Record: 14 4 1 of 3 , No Filter Search City Num Lock SQL I e 9 S Desktop >> - PENG 2:27 PM