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

Get Data Clean-Up and Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.