O'Reilly logo

Data Clean-Up and Management by Kenneth Furuta, Margaret Hogarth

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

12

Access queries

Abstract:

Queries extract data from Microsoft Access databases based on specified criteria. Filtering and sorting also allow certain data to display. Joining fields across tables allows for more complicated queries.

Key words

query

join

table

filter

sort

join

Sorting in Access

Sorting in Access is generally of two kinds: ascending and descending. Depending on whether it is numeric or textual data, the sort will be A–Z or Z–A, or smallest to largest or largest to smallest. There are two ways to sort in Access:

image Select the field > Home > Sort & Filter > choose Ascending, Descending, or Clear All Sorts.

 Select the field > Click ...

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