Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Sorting, Querying, and Filtering for Data
Chapter 4: Sorting, Querying,
and Filtering for Data
In This Chapter
Sorting, or rearranging, records in a database table
Filtering records in a table to see only the records you need
Querying to collect and examine information stored in a database
Looking at different kinds of queries
Now that you’ve laid the groundwork, you can put your database
through its paces and make it do what databases are meant to do —
provide information of one kind or another. This chapter explains how to
pester a database for names, addresses, dates, statistical averages, and
what not. It shows how to sort records and filter a database table to see
records of a certain kind. You also find out how to query a database to get it
to yield its dark secrets and invaluable information.
Sorting Records in a Database Table
Sorting rearranges records in a database table so that the records appear in
alphabetical, numerical, or date order in one field. By sorting the records in
a database, you can locate records faster. What’s more, being able to sort
data means that you don’t have to bother about the order in which you
enter records because you can always sort them later to put them in a
particular order.
Ascending vs. descending sorts
Records can be sorted in ascending or descending order:
Ascending order: Arranges records in alphabetical order from A to Z,
numbers from smallest to largest, and dates chronologically from earliest
to latest.
Descending order: Arranges text from Z to A, numbers from largest to
smallest, and dates chronologically from latest to earliest.
Search JabSto ::

Custom Search