How to find the average grade in access

access method to find the average score: first open the database; then select the Create Query Design button; then double-click tScore in the pop-up dialog box; finally select double-click the student number and grade fields, and select the average in the average score , click the execute button.

The operating environment of this article: Dell G3 computer, Windows 7 system, access2019 version.

Open the database

Select the Create Query Design button

The pop-up dialog box double-clicks tScore

Select double-click the student number and grade fields

Enter the average score in the grade field:

Select the summary button

Select the average in the average score

Click the execute button

You can see the results

Close the saved file

Save and rename it

Recommended: "access database tutorial"

The above is the detailed content of How to find the average grade in access. For more information, please follow other related articles on the PHP Chinese website!