In MS Access, to sort records in ascending order in a query, use: MCQ with Answer and Explanation

In MS Access, to sort records in ascending order in a query, use:
A. Both A and B
B. ORDER BY ASC in SQL
C. Ascending order in the Sort row of the query design grid
D. Group By
Answer: Option A
Solution (By JKSSB Mock Tests)
Both design grid sort and SQL ORDER BY ASC work.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Excel, what type of chart is ideal for showing the relative proportional contribution of components to a singular total whole sum?
A. Bar Chart
B. Line Chart
C. Pie Chart
D. Scatter Plot

Correct Answer: Option C


Explanation:
Pie charts represent data as proportional slices of a circle, which makes them highly effective for showing percentages or parts of a single whole.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, to view two parts of a document simultaneously, use:
A. Window -> New Window
B. View -> Split
C. Review -> Compare
D. Both A and B

Correct Answer: Option D


Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, to see the SQL code behind a query, switch to:
A. Datasheet View
B. SQL View
C. Layout View
D. Design View

Correct Answer: Option B


Explanation:
SQL View displays the SQL statement.

This question belongs to: Computer Microsoft Office