Create an update query to change all the entries in the Client Type column to RET. This will be the type of most clients. Run this query and save the query as Q31-Update Client Type to RET Query.

Set the following properties to the fields in the Client table and save the changes to the table.

Increase the size of the Client Name field to 25.

Make the Client Name field a required field.

Specify the legal values (i.e., set the validation rule) of MAN, RET, and SER for the Client Type field. Include an appropriate validation text.

Set the Format property to ensure that any letters entered in the Client Number field appear as uppercase.

Specify that balance must be between $0.00 to $1,500.00. Include an appropriate validation text.

Make the Client Type field a Lookup field (i.e., a field with the drop-down value).

Assign a default value of RET to the Client Type field.

Make the following changes to the Client table. You can use either the Find button or Filter By Selection to locate the records to change:

Change the client type for clients G56, J77, and T45 to SER.

Change the client type for clients B26 and S56 to MAN.

Change the client name of the client S56 to SeeSaw Industries.

Add the following clients to the Client table:

Client Number	Client Name	Address	City	Zip Code	Client Type	Balance	Bookkeeper Number
C21	Crompton Meat Market	72 Main	Empeer	58216	RET	$0.00	24
L50	Lous Salon	124 Fulton	Grant City	58121	SER	$125.00	34

Resize the Client Name column to best fit the new data, and save the changes to the layout of the table. Change the font to Courier New and font size to 9. Change gridline color (not the alternate color) to blue. We learn how to do this in chapter 1 (hope you do not forget it yet )

Open the Client table and use Filter by Selection to find all records where the client has a balance of $0.00 AND has the Client Type of SER. Delete these records. Remove the filter.

Create the report as shown below for the Client table. Group the report by Client type and sort the records within Client Type by Client Name. Save the report as Client Income Report. Note that you will have to rearrange the order of the columns under the Design view after the report is created.