DBWebApplications 





Finding, Filtering, Sorting  «Prev  Next»
Lesson 3 Sorting records
Objective Sort records in a table using one or more fields.
You may find that there are times when you need to look at the data in a table in a certain order. The Sort buttons available in the datasheet view allow you to quickly sort a datasheet. Once sorted, you can easily find the earliest or latest date in a field, or the largest or smallest value.
To be sure, sorting a datasheet is a rather primitive way of sorting data in your database, you can also sort a query. Most likely you will find that you want your data formatted and sorted--in that case you will want to create a sorted report. However, for some tasks sorting the table datasheet is sufficient and it's also easy. The SlideShow below shows you how.



Sorting access records
In the next lesson you will learn how to filter records to display a subset of records in a table.
Sorting Finding Access - Quiz
Test your knowledge on using the Find and Replace and Sort features.
Sorting Finding - Access - Quiz