In MS Access, to see the SQL code behind a query, switch to: MCQ with Answer and Explanation

Question
In MS Access, to see the SQL code behind a query, switch to:
A. Layout View
B. SQL View
C. Datasheet View
D. Design View
Answer: Option B
Solution (By JKSSB Mock Tests)
SQL View displays the SQL statement.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?
A. Required set to 'No'
B. Validation Rule mapping
C. Indexed set to 'Yes (No Duplicates)'
D. Input Mask application
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.
This question belongs to: Computer Microsoft Office
Question #2
What is the shortcut key configuration used to expand or collapse the entire top menu Ribbon interface bar across MS Office products?
A. Ctrl + Shift + R
B. Ctrl + F1
C. Ctrl + F2
D. Alt + F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + F1 is the universal keyboard shortcut to hide or show the main Ribbon tools layout menu to maximize screen workspace real estate.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which of the following is a valid event for a form?
A. On Load
B. On Click
C. After Update
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Forms have many events including On Load, On Click, After Update.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?