RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Refining Queries
«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
Creating Parameter Queries
Multiple Access Queries
Query Field Properties
UsingIndexes With Queries
Specifying Join Properties Queries
Different Types AccessQueries
Creating Action Queries
Total Queries Access
Crosstab Queries
Refining Queries Conclusion
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
Optimizing queries with indexes - Quiz
Working with query field properties and optimizing queries with indexes
Each question is worth one point. Select the best answer or answers for each question.
1.
Which property is not a query field property?
Please select the best answer.
A.
Format
B.
Validation Rule
C.
Caption
D.
Input Mask
2.
To improve query performance, you would place an index on which two fields?
Please select all the correct answers.
A.
Fields that cannot be used in criteria
B.
Sorted fields
C.
Fields used in calculated expressions
D.
Joined fields
3.
When you have more than one criteria in a query, you will get the best performance by taking which action?
Please select the best answer.
A.
Creating separate indexes for each field used
B.
Creating a composite index for all the fields used in the criteria
C.
Not creating any indexes
D.
Creating an index for only one of the fields used in the criteria