answersLogoWhite

0

Validation rules limit what can go into a field. You might want to only allow values that are over 500 in a field, so the validation would be:

>500

You might want dates that are before the 1st of January 2010, so that would be like this:

<#01/01/2010#

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What are the advantages of using a validation rules?

The advantage of using validation rules in Microsoft Access is that you get clean and consistent data in your database.


What are rules the user must follow when entering data?

validation rules


What are rules that the data entered by a user must follow in access?

Validation Rules


Is the process of comparing data with a set of rules or values to find out if the data is correct?

Data validation.


Why do you use validation rules?

A validation rule is simply to make sure that the data is entered correctly into the database (go onto bitesize-ICT-validation and verification for more info)


Can validation rules make sure that a users entry falls within a range of values?

Yes, but it depends on the validation routines used.


What are the examples of Java script?

validation of forms, date &amp; time.


What is a set of constraints or rules that help control how data is entered into a field?

Validation.


what type of attack that can be avoided by using proper input validation rules?

buffer overflow


Explain how validation rules can help maintain The integrity of a database?

Validation rules help maintain the integrity of a database by enforcing data accuracy and consistency. They ensure that only valid data entries are allowed, preventing errors such as incorrect data types, values out of range, or missing values. This helps in maintaining data quality and reliability within the database.


Which features restrict the entry of excel cell?

Validation allows users to restrict what can be entered, by setting up validation rules, like specifying a minimum value that can be entered, or that a cell can only accept dates for example. There are a lot of other ways validation can be used.


What are some examples of safety?

examples of water safety rules is like when you're entering a boat always wear a life jacket