Read: How to add Totals in Reports in Microsoft Access. 2] Filtering Records in Access There are three methods you can use to filter data. Method 1 is to click the drop-down arrow next to the field.