Materi Microsoft Access : How to create filter and an advanced filter to field

How to filter by a field in Datasheet view

1. Select the field you want to filter by, and then click Filter in the Sort & Filter group on the Home tab.
2. In the menu that Access displays, clear the check box for Select All.
3. Select the check box for each field value you want to view, and then click OK

How to filter by selection in Datasheet view

1. Select the value or the portion of a value you want to use as the filter.
2. In the Sort & Filter group on the Home tab, click Selection.
3. In the menu Access displays, select the expression for the filter (Equals, Does Not Equal, or another filtering option).
4. Click Toggle Filter to remove the filter from the table.

How to filter by form

1. In the Sort & Filter group on the Home tab, click Advanced and then click Filter By Form.
2. In the Filter by Form window, on the Look for tab, enter the value in the field or fields you want to use as the filter. 
3. Click the Or tab to set up OR conditions. 
4. In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.

How To create an advanced filter

1. On the Home tab, in the Sort & Filter group, click Advanced,and then click Advanced Filter/Sort.
2. In the Advanced Filter/Sort window, in the Field row in the grid, select the fields you want to use in the filter.
3. In the Criteria row, specify the expression to use in the filter.
4. In the Sort & Filter group, click Toggle Filter to apply the filter. Click Toggle Filter again to remove the filter.