Office 2016 All-In-One For Dummies

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 ...