Access database validation

What is the validation rule for a presence check?

• Between 1 and 4

• Is Not Null

• Like *?*@?*.??*"

• LL00LL

What is the validation rule to check that no number below 2 and no numbers above 5 can be entered into a field?

• Is Not Null

• Like "?*@?*.??*"

• Betwee 1 AND 6

• Between 2 AND 5

What validation rule could be used to check an email address has at least 1 character, but more are possible followed by an @ sign, then at least another character, but more are possible followed by a full stop and finally that at least 2 more characters must be entered, but more are possble?

• Like "?@?.?"

• Like ?*@?*.??*

• Like "?*@?*.??*"

• Like "???????"

What is a value lookup?

• Finding a value by searching a databse

• Creating a field with multiple vlaues to choose from

• Creating a link to a primary key

• Checking if an entered value is in another table

How would you set a value lookup on a field?

• Input multipe values in a cell

• Input multiple values in a form

• Use the lookup wizard to set the values

• Use the lookup wizard to set the table lookup values

What is a primary key?

• A field that links to another table

• A filed that has values from multiple tables

• A field that holds unique values

• A filed that has repeating values

What is a foreign key?

• A filed that holds unique values in the host table

• A field that is used to link to unique values in another table

• A way to unlock data about other countires

• A physical key to open a door or cabinet

On what fields are database relationships created, primary or foreign keys?

• Foreign keys

• Primary keys