Finding, Filtering, Sorting
Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Filter Records to Display Record Subset
Filter Records Complex Criteria
Creating Access Queries
Query Access Database Window
Query Design View
Ways to Save Query Design
Editing Query Design
Adding Criteria to Queries
Multiple Queries in Access
Creating Calculated Fields
Creating Access Forms
Access Auto Form
Displaying Records Access Form
Form Design View
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
Apply Filters Sorts to Database - Exercise
Apply filters and sorts to your project database
Apply filters and sorts to your project database.
This exercise is worth 5 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
Now that you have learned how to apply sorts and filters to your data, how about trying the following tasks in your Consulting database. If you completed the exercises in the
Building a Database
class, you can use the Consulting database you created during that course. If you do not have that database, download the Consulting_02.mdb database and use it as the basis for all the exercises in this course. That database can be downloaded from the Resources page.
Open the Consulting.mdb database, and try the following tasks:
Find your one client in Casa Grande.
Find the earliest start date in the Projects table.
Find projects for Lizard Web, Inc.
Find projects for Network Consultants that are not complete.
Find projects due in 2000 that have a start date in 1999.
Take note of how you solve these tasks. I will share how I approached the tasks in the Results page.