Access Video Quiz D1.2
By Richard Rost

9 hours ago

VBA Primarily Used For in Database Development?

S M L XL FS | Slo Reg Fast 2x | Bookmark | Autoplay: ON

What is VBA primarily used for in Microsoft Access? Welcome to another Microsoft Access Video Quiz. You will be asked five Developer-level questions about VBA, including command button events, message boxes, sub-procedures versus functions, and avoiding VBA keywords in object names. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Developer 1, Lesson 2

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, Access VBA quiz, VBA command button On Click event, VBA MsgBox, Sub vs Function VBA, VBA function return value, VBA keywords, Access developer quiz, VBA variables, Access form events

Comments for Access Video Quiz D1.2

Age	Subject	From
5 days	Post Your Quiz Score Here!	Richard Rost

More Information

Transcript

It's time for another video quiz from Access Learning Zone.

Today's quiz is for developer-level users. I'm going to ask you five questions, and they're going to come fast. Only going to give you a few seconds to answer each one. So feel free to hit the pause button whenever you need more time. Keep track of your score. We'll see how you do at the end.

Ready? Here we go.

Question one. In Microsoft Access, what is VBA primarily used for? Automating tasks and adding custom behavior, storing records and tables, formatting printed pages, or creating relationships between tables.

That's going to be automating tasks and adding custom behavior.

Question two. Which Access event would normally be used to run VBA when the user presses a command button? On Click, On Current, On Open, or On Delete.

That's going to be the On Click event.

Question three. What does the VBA message box command do? Display a message dialog box, save the current record, open the table in Datasheet View, or send a message to another Access user.

That's going to be display a message box because it's a message box.

Question four. In VBA, what is the main difference between a sub-procedure and a function procedure? A function can return a value, a sub does not; a sub can use variables, a function cannot; a function only works in queries; a sub only works in forms; or a sub must be public, and a function must be private.

That is, a function can return a value; a sub does not. A sub can return a value with a ByRef parameter, but that's a whole different video.

And question five. Why should you avoid using a VBA keyword as the name of a variable, field, or control whenever possible? Access may interpret it as a programming command, it prevents the object from being saved, it automatically changes the data type to text, or it makes the object visible only in Design View.

Access may interpret it as a programming command. For example, don't use a variable called MessageBox.

Alright, how'd you do? Did you get all five right? Are you a king of the castle or the court jester on break?

If you missed any, these topics and a lot more are covered in my Microsoft Access Developer Level 1 class, lesson two. I'll put a link down below.

Alright, thanks for playing. Be sure to post your score down in the comments, and until next time, Live Long and Prosper.

Intro

Quiz

Q1. In Microsoft Access, what is VBA primarily used for?
A. Storing records and tables
B. Automating tasks and adding custom behavior
C. Formatting printed pages
D. Creating relationships between tables

Q2. Which Access event would normally be used to run VBA when a user presses a command button?
A. On Current
B. On Open
C. On Click
D. On Delete

Q3. What does the VBA MsgBox command do?
A. Displays a message dialog box
B. Saves the current record
C. Opens a table in Datasheet View
D. Sends a message to another Access user

Q4. What is the main difference between a Sub procedure and a Function procedure in VBA?
A. A Sub can use variables, but a Function cannot
B. A Function only works in queries
C. A Sub only works in forms
D. A Function can return a value, while a Sub does not

Q5. Why should you avoid using a VBA keyword as the name of a variable, field, or control whenever possible?
A. It prevents the object from being saved
B. Access may interpret it as a programming command
C. It automatically changes the data type to text
D. It makes the object visible only in Design View

Answers: 1-B; 2-C; 3-A; 4-D; 5-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone is a quick developer-level quiz covering basic Microsoft Access VBA concepts. I will ask five questions, and you can pause after each one if you need extra time to think through your answer. Keep track of your score as you go.

The first question is: What is VBA primarily used for in Microsoft Access?

The correct answer is automating tasks and adding custom behavior. VBA lets you write procedures that respond to user actions, manipulate records, validate data, open forms and reports, and perform many other tasks that go beyond standard Access features. VBA is not primarily used for storing records, formatting printed pages, or creating table relationships.

The second question is: Which Access event would you normally use to run VBA when a user presses a command button?

The answer is the On Click event. When a user selects a command button, its Click event occurs, and Access can run the VBA procedure assigned to that event. Events such as On Current, On Open, and On Delete are used for different situations.

The third question is: What does the VBA MsgBox command do?

It displays a message dialog box. You can use MsgBox to provide information, warnings, instructions, error messages, or questions that require a response from the user. It does not save the current record, open a table in Datasheet View, or send a message to another Access user.

The fourth question is: What is the primary difference between a Sub procedure and a Function procedure in VBA?

A Function can return a value, while a Sub procedure does not directly return a value. Both Subs and Functions can use variables and can be used in many different parts of an Access database. Although a Sub can indirectly provide information back through a ByRef parameter, that is a more advanced topic. The key distinction is that Functions are designed to return a value.

The fifth question is: Why should you avoid using a VBA keyword as the name of a variable, field, or control whenever possible?

Access may interpret that name as a programming command or reserved keyword. This can lead to confusing errors, unexpected behavior, or code that is difficult to read and maintain. For example, naming a variable MessageBox could create confusion because that name is closely associated with displaying messages in VBA. Choose clear names that do not conflict with VBA commands, functions, properties, or reserved words.

If you missed any of these questions, these topics and many more are covered in my Microsoft Access Developer Level 1 class, particularly Lesson 2.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

VBA uses in Microsoft Access
Running VBA with command button On Click events
Displaying messages with the VBA MsgBox command
Differences between Sub and Function procedures
Avoiding VBA keywords in object and variable names

Article

This is a video quiz. No article needed.

Primary Topics

VBA purpose in Access, command button On Click event, MsgBox command, Sub versus Function procedures, avoiding VBA keywords in object names

Secondary Topics

form events, variable naming, field and control naming, ByRef parameters