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

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

Changchit, Chuleeporn CC Clipboard xternal Data Database Tools Help A Ascending Filter Z Descending & Advanced A Remove Sort \Toggle Filter Sort \& Filter Tell me what you want to do Find Client Update Form Sunday, February 14, 2021 12:49:09 PM Client Number Client Name Address City Zip Code Afton Mills 612 Revere Grant City 58120 A54 Client Type Balance Bookkeeper Number 00 00 00 .20 20 00 00 c0 0 200 Close Form Record: 14