Question ID: 2208 22/30

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.



Other versions
Microsoft Access 2003Microsoft Access 2007Microsoft Access 2010Microsoft Access 2013Microsoft Access 2016