MS Access 2007: Calculate highest, lowest and average mark

Asked By malakasilon 0 points N/A Posted on - 08/19/2011

I am using Microsoft Access 2007. I created a database for all students. I want to calculate the highest, lowest and average marks of all students. Is it possible to calculate in Microsoft Access?

Who is familiar with this kind of work? Please help me.

• Status: Open
• Question Views: 1807
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by evengecho

Go To Solution

Best Answer

Best Answer

Answered By evengecho 0 points N/A #116142

MS Access 2007: Calculate highest, lowest and average mark

To determine the average mark of all the students, you:

• Reveal the data using Design view, this will help you modify the data.
• Select the Text Box Tool, this will enable you to add controls to the data.
• Put the Text Box on the data header.
• Choose the Text Box then select Properties  from the tool bar.
• On the Control Source Property space, write the AVG mark to determine an average.

To calculate the highest and lowest value on your data, you highlight the data then select the Sort box in the query design grid choose the arrows that appear then select "ascending" to get the highest value and "descending" to get the lowest value.

About evengecho

Questions
0

Answers
7

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/19/2011
• Question Category: MS Access

Answered By arafat hossain 0 points N/A #116143

MS Access 2007: Calculate highest, lowest and average mark

Solve

Hello Mr. Malakasilon,

I read your problem, but I think this is not a very critical problem. Now I will try to give some workable solutions for your problem. Please read the solution below and work step by step then I think you will cover up the problem.

If you want to calculate the highest, lowest and average of mark of all student, first you should highlight the data then the box which is sort in the query design grid choose the arrows which appear and select ascending to get the highest and lowest value. 

To find out the average you can follow these steps:

• Let slip the data using the DESIGN view to modify the data.
• Select the Text Box Tool to add controls to the data.
• Put the Text Box on the data header.
• Choose the Text Box then select Properties from the tool bar.
• In the Control Source Property space, write the AVG mark to determine an average.

I hope your problem has been solved by this solution.

Thanks from.

Arafat Hossain

About arafat hossain

Questions
0

Answers
20

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 08/19/2011
• Question Category: MS Access