Open the Loans, Officers, and Members report and check that the report shows five loans listing Fully Paid as Loan Status. View the layout of the report in Print Preview. Close the Loans, Officers, and Members report. Open the Loans, Officers, and Members query. Sort the query by LoanOfficer field in ascending order. 8 You are interested in quickly filtering the data in the Loans, Officers, and Members query 10 based on loan officer. Filtering by selection allows you to select your filtering criteria and apply it to the data. In this case, you would like to see only the loans managed by John Badman. Use filter by selection to show only the loans managed by the loan officer whose name is John Badman. 9 Sorting allows you to display data in various ways including alphabetically (A-Z & Z-A), in 10 ascending order, in descending order, newest to oldest etc. You want to display the query results alphabetically by LoanStatus. Sort the query by LoanStatus in alphabetical order. Save and close the query. 10 Now, you are interested in quickly filtering the data in the Loans table based on two different 12 fields. Filtering by form allows you to enter your filtering criteria into a form that is then applied to the data. Open the Loans table. Use Filter by Form to create a filter that will identify all loans with a term of 36 months that also have an interest rate less than .11. Apply the filter and preview the filtered table. Close the table and save the changes