Question

what helps you to filter records in a table to view only certain records

Answer 1

Filtering is a useful way to see only the data that you want displayed. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object. This article explains the types of filters in Access and how to apply, save or remove filters in an Access 2010 client database. This article does not apply to filtering records in an Access 2010 web database.