:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

 

Microsoft Access - Class 3 - Part V

> Back

Sorting data

Sorting is the process of rearranging records in a specified order or sequence. When you sort data in a database, Access does not change the sequence of the records in the underlying tables. Only the records in the query datasheet are rearranged according to your specifications. Sort keys can be text, number, date/time, currency, AutoNumber, or yes/no fields, but not memo, OLE object, or hyperlink fields.

Condition is a criterion, or rule, that determines which records are selected. To define a condition for a field, you place the condition in the field's Criteria text box in the design grid.

 


Print this page

 

 

Copyright © 2006 Consultation SOS