Access 2013: Sorting and Filtering

Date/Time
Date(s) - 04/24/2014
9:30 am - 11:00 am

Location
IML (Eggers Hall, room 062)

Category(ies)


 

Access 2013 logoNo matter how much information a database contains, it is useful only if you can locate the information you need when you need it. In a small database, you can find information simply by scrolling through a table until you find what you are looking for. However, as a database grows in size and complexity, locating and analyzing information becomes more difficult.

A sorted list helps users review and locate what they want without having to browse the data. You can fine-tune the results by sorting records on more than one field. Depending on the field data type (text vs. number data types, for example), your sorting choices change.

A filter changes the displayed view without altering the design of the object. You can think of a filter as a criterion, or a rule, that you specify for a field. The criterion identifies the field values that you are interested in viewing. When you apply the filter, only records that match your “rules” are included in the view. The rest are hidden until you remove the filter.

If you would like to learn how Access can manage your data by sorting and filtering, please join us for this workshop!

Register For ICT Training

 

Verification