Access 2013: Sorting and Filtering

Date/Time
Date(s) - 08/25/2015
1:30 pm - 3:00 pm

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 (Short Text vs. Number, for example), your sorting choices change.

A filter changes the displayed view without altering the design of the object. You base filters on criteria, which identify the values you are interested in viewing for a field. When you apply the filter, only records that match your criteria are included in the view. The rest of the records 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