How To Filter And Sort Data In Access 2010 Tables

The advantage of having direct access to the data tables is that you don't always have to write a query or a report in order to get to the data you want to see. Sometimes it is necessary to check for a specific record or alter something directly in the table, without having to write a SQL statement to do it. For example, imagine a colleague has told you a record was entered, but something on it needs to be changed and they do not have permissions to change it from the front end. When you open the relevant table you are confronted with over three thousand rows and need to find the exact record. Using filter and sort can help find the correct record on the table.

The full article appears here:
http://www.microsofttraining.net/article-1124-how-filter-and-sort-data-in-access-2010-tables.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com