In MS Access, a query that groups data and calculates sums, averages, or counts is known as: MCQ with Answer and Explanation

In MS Access, a query that groups data and calculates sums, averages, or counts is known as:

A. Select query

B. Totals query

C. Crosstab query

D. Parameter query

Answer: Option B

A Totals query (using Group By, Sum, Avg, etc.) aggregates data. Crosstab query also aggregates but in a cross-tab format.

This question belongs to: Computer Microsoft Office

No comments yet. Be the first to start the discussion!

Question #1 Report Error

In MS Access, which action query adds records from a query result to an existing table?

A. Delete query

B. Make-Table query

C. Append query

D. Update query

Correct Answer: Option C

Explanation:
Append query inserts rows.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

To move the cursor to the end of a document in MS Word, press:

A. Ctrl + End

B. Ctrl + Page Down

C. Shift + End

D. End

Correct Answer: Option A

Explanation:
Ctrl+End jumps to end of document. End goes to end of line.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Access, which of the following is used to create a relationship between tables?

A. External Data > Relationships

B. Database Tools > Relationships

C. Home > Relationships

D. Create > Relationships

Correct Answer: Option B

Explanation:
Relationships are managed from the Database Tools tab.

This question belongs to: Computer Microsoft Office