Find data in an Access app
Data is useless if you can’t find it when you need it, so Access apps provide several ways to zoom in on the data you need. These finding and filtering tools are included automatically when you create an Access app.
Finding data in a List view
A List view gets created automatically when you add any table to an app. To open this view, navigate to your app with your browser and click List in the View Selector (unless you have renamed the view caption). For more about adding tables to apps, see create an Access app. For more about working with List views, see using a list view in an Access app.
In List views that display a large number of records, locating a specific record can be difficult, so the search box feature makes this task easier. Each List view includes a search box by default, as shown here:
Enter a few characters in this box, press Enter, and the app immediately filters the list down to items that contain those search characters.
In this example, entering the characters “ad” finds “Adina”, Traders”, and “Mahadevan”. Access searches across multiple fields. In this example, Access found the search value in the First Name, Company, and Last Name fields of 3 different items.
To return to the unfiltered view, click the “x” in the search box. When you are viewing records in a List view, type the forward slash character / as a keyboard shortcut to move focus to the search box.
By default, Access searches across all fields visible in the List view when you enter a search criterion into the search box. You can refine your search in the search box to search only one field instead of all visible fields by entering the field name followed by a colon and then your search criteria. For example, in the previous example if you wanted to only search for the characters "ad" in the Company field, enter Company:ad into the search box and press Enter. In this case, Access searches across data in the Company field only and returns one record whose company name matches the search—the Northwind Traders record.
Access does not display the search box on the design grid when you're designing your List view; you'll see the search box only in runtime in your web browser. You cannot remove or hide the search box; it is part of the List Control in List and Summary views. The search box maintains the same width as the List Control, so if you reduce or increase the width of the List Control in the view, Access reduces or increases the width of the search box to match.
Finding data in a Summary view
A Summary view groups items by a value, such as task status:
Summary views include the same kind of search box as List views, but its filtering powers are limited to the list just below it, and do not extend to the detail information on the right. Still, it is a great way to find the group you need if you have a lot of groups displayed in your Summary view.
Finding data in a Datasheet view
Like the List view, a Datasheet view is created automatically for any table you add to an app, and is available by clicking Datasheet in the view selector (unless you have renamed the view caption) within your browser. Datasheet views don’t include a search box like the ones in the views above, but they do provide filtering features like those you would find in a spreadsheet program or an Access desktop database datasheet form. For more about datasheet views in Access apps, see use a web datasheet view in an Access app.
Hover over a column header, click the drop-down arrow, and click an option to sort or filter the list.
Select more options from the list to add more values to a column’s filter. Check marks appear next to the values you’ve selected.
To remove a filter on a column, click Clear Filter from the list of options.