Skip to Main Content
Office 2021 All-in-One For Dummies
book

Office 2021 All-in-One For Dummies

by Peter Weverka
February 2022
Beginner content levelBeginner
800 pages
19h 1m
English
For Dummies
Content preview from Office 2021 All-in-One For Dummies

Chapter 4

Sorting, Querying, and Filtering for Data

IN THIS CHAPTER

Bullet Sorting, or rearranging, records in a database table

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

Bullet Querying to collect and examine information stored in a database

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Office 2021 for Macs For Dummies

Office 2021 for Macs For Dummies

Bob LeVitus, Dwight Spivey
Microsoft Office 2021 – Das Handbuch

Microsoft Office 2021 – Das Handbuch

Rainer G. Haselier, Klaus Fahnenstich
The Frictionless Organization

The Frictionless Organization

Bill Price, David Jaffe

Publisher Resources

ISBN: 9781119831419Purchase Link