In MS Access, the 'AutoExec' macro: MCQ with Answer and Explanation

In MS Access, the 'AutoExec' macro:
A. Is a reserved name for export
B. Runs automatically when the database is opened
C. Executes a series of queries
D. Creates an executable file
Answer: Option B
Solution (By JKSSB Mock Tests)
A macro named AutoExec runs on database open.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to start a slideshow from the beginning in MS PowerPoint?
A. Ctrl + F5
B. Alt + F5
C. Shift + F5
D. F5

Correct Answer: Option D


Explanation:
F5 starts the slideshow from the first slide. Shift + F5 starts from the current slide. Ctrl+F5 is not standard.

This question belongs to: Computer Microsoft Office
Question #2
What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?
A. It functions as a placeholder pattern to guide manual typists.
B. It sets the default value displayed inside the datasheet cell field.
C. It specifies the custom error message displayed to users when data violates a Validation Rule.
D. It defines the calculation rule used to verify alphanumeric formats.

Correct Answer: Option C


Explanation:
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.

This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is a valid expression for a validation rule?
A. Like A
B. >0 And <100
C. All of the above
D. Between 1 And 10

Correct Answer: Option C


Explanation:
All are valid validation rule expressions.

This question belongs to: Computer Microsoft Office