Problem: The Babbage Bookkeeping is very happy with the database you created for them. The company realizes that there is a need to store the date a bookkeeper started as well as some notes concerning...

1 answer below »









Problem: The Babbage Bookkeeping is very happy with the database you created for them. The company realizes that there is a need to store the date a bookkeeper started as well as some notes concerning the bookkeeper’s training and abilities. Babbage Bookkeeping also would like to store a picture of the bookkeeper. In addition, the company wants a form that displays bookkeeper information and the clients for which they are responsible as well as a form that will allow them to update clients’ records.










Instructions: Use the database created in the Assignment7 for this assignment. Copy the file and rename the copying file to




Your Last Name + First Name + Assignment8


. Perform the following tasks:













1.


Open Bookkeeper table in Design view.







§





Add the Start Date field, “Date/Time” data type, set “Date” Input Mask.







§





Add the Comment field, “Long Text” data type.







§





Add the Picture field, “Attachment” data type.







§





Add appropriate descriptions to all added fields.







§





Add the image files as shown below to the Bookkeeper table.

















































































































Bookkeeper Number

















Start Date

















Comment

















Picture














22











03/10/2003











Has a BA in Accounting. Working toward CPA.














bookkeeper 1














24











01/15/2004











Has an AA in Accounting.














bookkeeper 3














34











09/09/2003











Has an AA in Records Management. Working toward BA.














bookkeeper 5



























§





Adjust the row and column spacing to best fit the data and save the changes.







2.


Create the “nice and neat” form as shown below for the Bookkeeper table.







§





Use “Bookkeeper Master Form” as the name of the form.







§





Use “Accounts Subform” as the name of the subform.







§





The Subform Column needs to show complete data (i.e., the column headers should be fully displayed-do not hide part of the data) in the fields.













3.


Create the form as shown below. Save the form as “Client Update Form.”










·





The “Bookkeeper Number” control box is a drop-down box displaying Bookkeeper Number, Bookkeeper First Name, and Bookkeeper Last Name of all bookkeepers in the Bookkeeper Table.







·





Two command buttons are added to add a record and to close the form.



















4.


Create a query to find all bookkeepers that have an AA degree and started during the last 6 months in 2003. Include the Bookkeeper Number, First Name, Last Name, Hourly Rate, and YTD Earnings in the query. Save the query as “Q51-Bookkeeper with AA and Started Last 6 Months of 2003 Query”




The first attachment is the instructions in a word doc.

Answered 1 days AfterFeb 18, 2024

Answer To: Problem: The Babbage Bookkeeping is very happy with the database you created for them. The company...

Sagar answered on Feb 20 2024
18 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here