O'Reilly logo

Office 2016 All-In-One For Dummies by Peter Weverka

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4

Sorting, Querying, and Filtering for Data

In This Chapter

arrow Sorting, or rearranging, records in a database table

arrow Filtering records in a table to see only the records you need

arrow Querying to collect and examine information stored in a database

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required