RelationalDB
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Finding, Filtering, Sorting
«Prev
Next»
Data Manipulation
Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Sorting Access Records
Filter Records to Display Subset
Display Record Subset
Filter Records Multiple Criteria
Filter Records Complex Criteria
Advanced Filter Uses
Single Table Access Conclusion
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Form
Access Auto Form
Displaying Records Access Form
Edit Access Database
Create Access Forms
Form Design View
Save Access Form
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
Sorting and Finding Access Data - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Use the Sort feature if you want to
Please select all the correct answers.
A
Find the earliest date in a field
B
Find the biggest value in a field
C
Put projects in order by due date
D
Find a particular client
2.
You can use the Find and Replace dialog box to
Please select all the correct answers.
A
Find the entire contents of a field
B
Find a portion of the contents of a field
B
Find the largest value in a field
D
Find text in the same case that you type in the Find What box
3.
In the toolbar shown above, which of the numbered icons are used to perform a sort on your data?
Please select the best answer.
A
3 & 4
B
4 & 5
C
1 & 2
D
1 & 4
4.
To display the Find and Replace dialog box you can
Please select all the correct answers.
A
Press Ctrl-F
B
Click on the
button
C
Click on the
button
D
Click on the
button
E
Choose Edit>>Find from the menu
F
Click on the
button and thenchoose Edit>>Find.
5.
In the Find and Replace dialog box, you can specify where you want to look for the text within the table by using the
Please select the best answer.
A
Match Case option
B
Match option
C
Look In option
D
Find What option
Submit