Restricting the Type of Data in a Field in MS Access 2007

When Restricting the Type of Data in a Field the field properties you can set to control input are:

• Required

  Allow Zero Length

  Field Size

  Input Mask

  Validation Rule

• No Required

  Length

  Field Size

  Output Mask

  Numeric Rule

• Set mask

  No length

  Vertical Mask

  Multiple Rule

What is the purpose of the 'Allow Zero Length' field property in Access?

• To allow the field to have a zero length value

• To restrict the field from having a zero length value

• To set the field size to zero

How does the 'Validation Rule' field property help in controlling input in Access?

• It allows any input without validation

• It restricts input based on a specified rule

• It sets the field size to a specific value

What is the significance of the 'Input Mask' field property in Access?

• It allows any type of input without any restrictions

• It enforces a specific format for input

• It sets the field size to a specific value

By setting the Field Size property to a value that allows the largest valid entry you...

• Prevent the user from entering certain types of invalid information.

• Allows the user to enter any data that he wants

• Will make the database more efficient.

When using the 'Numeric Rule' field property in Access, what type of input is allowed?

• Only numeric input is allowed

• Any type of input is allowed

• Alphanumeric input is allowed

When you use masks in tables or forms, people entering information can see at a glance.

• the color of the mask they are wearing
• the weather forecast for the day
• the format in which they should make entries and how long they should be
• the latest news headlines

It is an expression that can precisely define the information that will be

accepted in one or several fields in a record.

• Authentication regulation
• Verification principle
• Confirmation standard
• Validation rule

You can type validation rules in by hand, or you can use the __________ to create

them.

• Rule Creator
• Expression Builder
• Validation Builder
• Syntax Generator

You can limit the options for entering information in a database by creating a combo box.

• Not sure
• False
• True
• Maybe