Question: how to find the average in a query?
Answer: Click the "Create" tab and click "Query Design" to display the Show Table dialog window. ...  Double-click the field you want to use and click the "Totals" icon.