Navigate to the record 147 and change the value of the Renting Terms field to Weekend and the value of the CustomersCode field to 4 (Stergiopoulou Despina). Save the record and close the form.

Create a new form, in columnar layout, that will display all fields of the Movies table. Then save it as MoviesForm.

Change the header text Customers Form of the open form to Partners and apply Times New Roman, 12pt, bold and italics font. Save and close the form.

Delete the RentingForm form.

Open the RentingForm form and navigate to the record 123.

Navigate to the record 209 of the current form. Do not close the form.

Navigate to the first record of the current form. Do not close the form.

Navigate to the last record of the current form. Do not close the form.

Navigate to the next record of the current form. Do not close the form.

Navigate to the previous record of the current form. Do not close the form.

Use the open form to enter a new record with the following values:

Code: 888771

Description: All Time Classic

Price: 888772

Save the record but do not close the form.

Use the open form to find and delete the record where the value of the Code field is set to 524. Do not close the form.

Use the open form to find the record where the value of the Description field contains the phrase 791XV

Then, change the value of the Price field from 50 to 1024. Save the record but do not close the form.

Insert a label to display the text Products in the header of the ProductForm form. Format the label in Arial, 12pt, bold white font, with red background color and transparent border style. Save and close the form.

Insert two text boxes in the footer of the ProductForm form. The first one will display the lowest value of the Price field of the records displayed in the form and the second one will display the highest value of the Price field. Save and close the form.

Insert two text boxes in the footer of the ProductForm form. The first one will display the average of the Price field values displayed in the records of the form and the second one will display the total number of the records in the form. Format the average value displayed in the text box in Fixed format with 2 decimal places. Save and close the form.

Show the page Header and page Footer of the open form. Save the form.

Insert the Price field in the current form. Save the form.

The Customers3 form contains a button called Close. Make sure the macro CloseForm is executed when the user clicks on it.

Create a blank form named StartForm. Insert a button to display the text Customers, which will open the Customers form and will display all of its records, when the user clicks it. Insert another button to display the text Orders, which will open the Orders form.

Insert a button in the Detail Section of the ProductForm form displaying the text Report
The button should open the R_Products report in print preview. Save the form.

Insert a button in the ProductsForm form to display the text Question, to execute the PhotosJPG query. Save the form.