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.