RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Table Design
«Prev
Next»
Tables Queries Forms
Table Design Enhancement
Table Field Validation
Custom Validation Messages
Input Mask Mechanics
Specifying Input Mask
Access Lookup Fields
Data Type Aadvantages
Specifying Field Length
Enhancing Table Design
Refining Queries
Access Database Filters
Multiple Access Queries
Query Field Properties
Specifying Join Properties Queries
Total Queries Access
Crosstab Queries
Building Modifying Forms
Create Access Form
Add Format to Access Form
Insert Graphic Access Form
Access Form Properties
Changing Form Properties
Custom Form Properties
Aligning Sizing Multiple Controls
Customize Access Forms
Building Modifying Forms
Access Controls
Combo Box
Option Groups
Subform Control
Create Multipage Forms
Adding Chart to Form
Activex Controls
Calendar activex Control
Access Controls
Field Level Properties and Validation Purposes in MS Access - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which type of control does the Lookup Wizard create?
Please select the best answer.
A.
Text Box
B.
List Box
C.
Tab
D.
Combo Box
2.
The Validation Rule property allows you to specify the valid data that can be entered into a field. What does the Input Mask property do for you?
Please select the best answer.
A.
Specifies how to display the data on reports
B.
Controls how the data can be entered by providing a specific format
C.
Displays a custom error message for incorrect data
D.
Creates a combo box to display lookup values
3.
What is not a valid reason to specify the correct data type to be used for a field?
Please select the best answer.
A.
Access will run only if you do this.
B.
Access has built-in validation for some data types such as Date/Time, which you can take advantage of.
C.
Using the correct data types enhances performance in some cases.
D.
Some data types take up less space.
Correct answers:
Your Score: 0
Submit
Quiz Explanation