2015

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.

2016

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

2018

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.

2038

Delete the RentingForm form.

2041

Open the RentingForm form and navigate to the record 123.

2078

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

2079

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

2080

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

2081

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

2082

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

2083

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.

2084

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.

2085

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.

2086

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.

2087

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.

2088

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.

2182

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

2183

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

2789

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

2809

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.

2839

Insert a button in the ProductForm form to display the text Report, in the Detail Section, to open the R_Products report in print preview. Save the form.

2840

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