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 an Access database for names, addresses, dates, statistical averages, and whatnot. 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 ...
Get Office 2021 All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
