WorksheetsRestricting the Type of Data in a Field in MS Access 2007
Total questions: 22
Worksheet time: 22mins
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.
It is an expression that can precisely define the information that will be
accepted in one or several fields in a record.
You can type validation rules in by hand, or you can use the __________ to create
them.
You can limit the options for entering information in a database by creating a combo box.
It is type of simple lookup list for only two options.
Check Box
Combo Box
Option Buttons
You can use the Lookup wizard for Creating a Multi-Column Lookup List
If you want to change information stored in the database only under certain circumstances you can create an...
update query
Use find and replace
This is not an Option on Access 2007
To maintain an efficient database, is a good idea to create a _______ to discard outdated
records from time to time.
Combo box
Simple Look up List
Update Query
Delete Query
The Query Design Option is located in the ____Tab
Create
Home
External Data
Database Tools
This utility first optimizes performance by rearranging how the file is stored on your hard disk, and then attempts to repair corruption in tables, forms, reports, and modules.
Compact and Repair Database
Performance Analyzer
Database Documenter
Analyze Table
This utility analyzes the objects in your database and
offers three types of feedback: ideas, suggestions, and recommendations. You
can instruct Access to optimize the file by following through on any of the
suggestions or recommendations.
Compact and Repair Database
Performance Analyzer
Database Documenter
Analyze Table
This tool produces a detailed report containing enough
information to rebuild the database structure if that were ever necessary.
Compact and Repair Database
Performance Analyzer
Database Documenter
Analyze Table
This wizard tests database tables for compliance with standard
database design principles, suggests solutions to problems, and implements those
solutions at your request.
Compact and Repair Database
Performance Analyzer
Database Documenter
Analyze Table
You can replace specific words or phrases by using the __________, or quickly
enact conditional changes by running an action query.
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
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
