In the Lab: 2 Creating the Babbage Bookkeeping Database
Assignment 5: Creating the Babbage Bookkeeping DatabaseProblem: Babbage Bookkeeping is a local company that provides bookkeeping services to several small businesses in the area. The database consists of two tables. The Client table: This table contains information on the businesses that use Babbage’s services. The Bookkeeper table: This table contains information on the bookkeeper assigned to the business.Instructions: Perform the following tasks:Create a new database in which to store all the objects related to the bookkeeping data. 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.Create the Client table using the structure and data shown in the table below: Save the table as “Client Table.”Client TableField NameData TypeField SizePrimary KeyDescriptionClient NumberText3YesClient Number (Primary Key)NameText20Name of ClientAddressText15Street AddressCityText15CityZip CodeText5Zip Code (5 Character Version)BalanceCurrencyAmount Currently Owed for ServicesBookkeeper NumberText2Number of Client’s Bookkeeper Enter the data for the Client Table as shown in the table below:Create the Bookkeeper table using the structure and data shown in the table below: Save the table as “Bookkeeper Table.”Bookkeeper TableField NameData TypeField SizePrimary KeyDescriptionBookkeeper NumberText3YesBookkeeper Number (Primary Key)Last NameText10Last Name of BookkeeperFirst NameText8First Name of BookkeeperAddressText15Street AddressCityText15CityZip CodeText5Zip Code (5 Character Version)Hourly RateCurrencyHourly RateYTD EarningsCurrencyYear-to-Date Earnings Enter the data for the Bookkeeper Table as shown in the table below:Create a report as shown below: Save this report as “Balance Due Report” (Office Style)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. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- georgia small business economic profile
- this playbook consists of city of new york
- financial management for a small business
- small business youtube playbook for google search
- ada guide for small businesses
- big business in small business cloud services for
- programs services for small businesses
- the small business online marketing guide
- small business champion awards
- 3 2 fueling your business a guide to financing your
Related searches
- creating the wow experience
- creating passion in the workplace
- current events in the last 2 weeks
- what is the purpose of database normalization
- escience lab 2 answers
- creating engagement in the workplace
- article 2 section 2 of the constitution
- creating diversity in the classroom
- a rasin in the sun worksheet act 2 scene 1
- lab 2 answers
- 2 to the negative 2 power
- next experiment with the values in the calculator to complete the chart use up