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.

2151

Create a new form, based on the OrdersProducts query and named OrdersProducts in tabular layout. The form will display the OrderDate, Description, Quantity and Price fields (following this order). Then create a form named Customers in columnar layout based on the Customers table that will display all fields of the table. Insert the OrdersProducts form as subform in the Customers form. Set the CustomerID as link field between the two forms. Save and close the form.

2152

Insert a new text box in the ProductList form to calculate the price of the product multiplied by 1.19.

Select Euro as currency format. Insert a label to the form header with a caption to display the text Value with tax.

Save the changes to the form.

2153

Change the tab order of Customers form so that the sex field is set next to last and the CustomerID field last.

2156

Delete the text boxes which display the Name and Surname fields from the Customers form. Insert a new text box named FullName that will display Customer_Name and Customer_Surname with a space in between. The caption will display the text FullName.

Save the form.

2157

Locate the CustomersFindPC form and make sure that the myRefresh macro is executed each time the pc_find text box changes.

2170

Locate the Customers form and set the default view of the subform to Continuous Forms.

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.

2193

Navigate to the Orders form and apply limit to list option to combo box.

2230

Locate the Detail section of the ProductForm form and insert a new text box without control source (Unbound).

2231

Locate the Detail section of the ProductForm form and insert a new text box that will calculate and display the VAT from the VAT field, in percentage format with 2 decimal places. (e.g.19 -->19.00%)

2232

Insert a new text box in the Detail section of the ProductForm form to display the VAT value of product's price in standard format with 2 decimal places.

2233

Insert a new text box in the Detail section of the ProductsPhoto form that will calculate the size of the uncompressed photo in kB and will display it in standard format with 2 decimal places. To find the photo size in bytes use the Height*Width*3 formula.

2234

Insert a new option button group in the Detail section of the Customers form and connect it with the Sex field applying the following labels: Male (value=1), Female (value=2). Set Male as the default option. Save and close the form.

2235

Insert a new Combo box in the Detail section of the Customers form and connect it with the Sex field applying the following labels: Male (value=1), Female (value=2). Do not display the column containing values 1 and 2. Set Male as the default option. Change the label caption of the combo box to Sex. Save and close the form.

2236

Locate the Detail section of the Orders form and insert a List box that will store values in the CustomersCode field. Display only the FirstName and Surname fields of the Customers table and apply sorting by Surname in ascending order. Also rename the label connected to the list box into Customers. Save and close the form.

2237

Insert a combo box in the Detail section of the Orders form that will display only the Description field of the Products table in an ascending order and connect it with the ItemCode field. Also rename the label of the combo box to Products. Save and close the form.

2238

Change the tab order of the Customers form as follows: Surname, FirstName, TelephoneNumber, Address, Area, City, PC. Save and close the form.

2781

In the Customers form insert a check box that will be bound to the NewCustomer field. Enable the triple state property. Set the value Null to the Costas Goutoudis customer entry. Save the record.

2783

Apply the appropriate changes to the ProductsPhoto form so that page number is displayed in the following format: Page 1 from 5, at the bottom part of every printed page.

2784

Set the Orders2 form as subform of the Customers2 form instead of the Orders form.

2789

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

2798

Insert one more text box in the FormProducts form to display the double of the Price field value. Save the changes.

2805

Apply the appropriate settings to the Customers form so that the msg macro is executed after saving a new record.

2807

There is a combo box named Category in the Customers form. Insert a fourth option named Wholesale-Export Price

Save the changes.

2808

There is a combo box named Category in the Customers form. Insert a fourth option named Wholesale - Export Price. Save the changes.

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.

2810

Change the Option Button of the Customers form to Check Box. Save the changes.

2811

Insert a third option named Retail-Export Price in the option group of the Customers form. Change the type of all three options to Toggle Button.

2839

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.

2840

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