2032

In the Customers table insert a new field named sex in text data type and set field size in 50. The user will be able to choose between Male or Female only. Save and close the table.

2033

In the Customers table insert a new field named Sex, in Number data type and byte field size. The user should be able to choose either Male or Female (where Male=1, Female=2). Numbers will not be displayed. Save and close the table.

2034

Apply a validation rule to the RetailPrice field in the Movies table, so that prices higher than 100 are not accepted. Save and close the table.

2035

Apply a validation rule to the RetailPrice field in the Movies table to allow entering only prices equal to or higher than 2 and equal to or lower than 100. When the user types different prices, the system will return the message Acceptable values from 2 to 100

Save and close the table.

2069

Locate the Description field of the open table and apply an input mask to display the word new always at the beginning followed by an empty space and a maximum of 10 letters chosen by the user. Save and close the table.

2070

Change the Date field format of the open table to Long date and the input mask into Short date. Save and close the table.

2071

Set a validation rule in the Date field of the open table to allow entering equal or greater dates than the current date. Save and close the table.

2139

Set the Price field of the Products table to display values in Euro format. Save and close the table.

2140

Use the month/day/year form which displays each item in two digits (e.g. 07/14/13) to set an input mask to the OrderDate field of the Orders table. Save and close the table.

2141

Insert one more field named Sex at the end of the Customers table that will allow only one of the following two values: M for male and F for female. Apply the text Data Type and 1 character size to the field. Set the value M as the default value. Apply Limit to List. Modify the records which should display the F option manually. Save and close the table.

2142

Insert one more field named Comments at the end of the Customers table that will allow entering a text of more than 1000 characters in lower case format. Save and close the table.

2158

Delete the Products table. Create a link to the Products file located in the IL-ates\Excel folder on your desktop. Name the linked table Products.

2159

Delete the Products table. Import the Products file from the IL-ates\Excel folder of your desktop. Name the table Products. Make sure the ID field does not allow entering duplicates.

2160

Set number 100 as default value of the Price field in the Products table. Save and close the table.

2201

Set the display control of the ItemCode field in the Orders table as List Box. Make sure the Row Source Type property is Table/Query and the data are derived from the Products table. Save and close the table.

2202

Set the display control as combo box in the ItemCode field of the Orders table. Make sure the Row Source Type property is set to Table/Query and the data are derived from the Products table, the column count is 2 and the column heads are displayed. Save and close the table.

2203

Set the display control of the ItemCode field in the Orders table as combo box, and the Row Source Type property to Table/Query. Derive data for the Code and Description fields from the Products table and apply sorting by Description in ascending order. Make sure the first column (Code field) is not displayed, the count column is 2, the column headers are not displayed and there is a limit to the list. Save and close the table.

2204

Set the appropriate validation rule in the Price field of the Products table to allow the input of prices equal or higher than 0 and equal or lower than 2900, or one of the following prices: 3000, 4000, 5000. Use the text Wrong price as validation text. Save and close the table.

2205

Create the suitable Input Mask in the OrderDate field of the Orders table so that users can enter up to 2 digits for day, month and year. Use the symbol # as placeholder. Save and close the table.

2206

Remove the Input Mask from the PC field of the Customers table and set the appropriate property to require data entry in this field. Save and close the table.

2207

In the PC field of the Customers table set the appropriate property to require data entry in this field. Use 54645 as default value of the field. Save and close the table.

2208

Navigate to the Price field of the Products table and set the appropriate validation rule to allow the input of prices equal or higher than 0 and equal or lower than 1000. Use the phrase Wrong price as validation text, the value 100 as default value. Set the appropriate property to require data entry in this field.

Finally, set an Index that allows duplicates. Change the respective field values to make sure that an error message is not displayed when saving the table due to the validation rule. Save and close the table.

2772

In the Products table change the size of the Description field to 5 characters. Open the table in Datasheet View.

2773

In the Orders table change the type of the OrderDate field to Text which will hold up to 5 characters. Open the table in Datasheet View.

2774

Apply the appropriate settings to the products table so that the VAT field is required. Make sure there are not any errors after the table is saved.

2792

Remove the default value from the AddDate field of the Customers table. Save the table.

2793

Set AirMail and Courier as available options in the ShippingMethod field of the Customers table.
Save the table and make sure all records of the table display AirMail as shipping method.

2794

Apply the appropriate settings to the DateOfOrder field of the Orders table to allow entering dates greater than 01/01/2004 only. If the user attempts to enter other dates, the system will display message with the text Wrong date

Save the table.

2802

Insert a new field named email as hyperlink in the Customers table. Also apply lowercase format and save the changes.

2812

Apply the appropriate mask to the Surname field of the Customers table, that will display the first letter of all Surnames in upper case and the rest of them in lower case. Save the changes.