Get premium membership and access questions with answers, video lessons as well as revision papers.

What is the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does...

      

Discuss the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does two CATs namely English and Kiswahili.

  

Answers


Maurice
(a) Open the query in the design view.

(b) Add the appropriate query design view.

(c) In the field marked B, along the criteria row, type the following:

Average: (Round ([English]+[Kiswahili])/2,0)

(d) You can set other field criteria if need be.

(e) Save the query and Run it for output.
maurice.mutuku answered the question on April 12, 2018 at 06:19


Next: What are the stages of activating a calculation for TOTAL sum of cash collected in a FeePayment field?
Previous: What is the meaning and the use of OR operator in queries?

View More Computer Studies Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions