MS Access 2007: Calculate highest, lowest and average mark

Asked By 0 points N/A Posted on -
qa-featured

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?

Microsoft Access 2007 pack

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

SHARE
Best Answer by evengecho
Best Answer
Best Answer
Answered By 0 points N/A #116142

MS Access 2007: Calculate highest, lowest and average mark

qa-featured

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 properties icon 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.

Answered By 0 points N/A #116143

MS Access 2007: Calculate highest, lowest and average mark

qa-featured

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

Related Questions