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.