Access Video Quiz D1.4
By Richard Rost

10 hours ago

Why Should You Turn Warnings Back On After VBA?

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

What does a make table query do? Welcome to another Microsoft Access Video Quiz. You will be asked five Developer-level questions covering action queries, make table and append queries, Access warnings, and the VBA MsgBox function. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Developer 1, Lesson 4

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, Access action queries, make table query, append query, Access warnings VBA, DoCmd.SetWarnings, VBA MsgBox, update query, delete query, action query types, append records to table, create table from query results

Comments for Access Video Quiz D1.4

Age	Subject	From
19 hours	Post Your Quiz Score Here!	Richard Rost

More Information

Transcript

Guess what time it is? It's time for another video quiz from Access Learning Zone.

Today's quiz is for developer-level users. Five questions coming real fast. I'll only give you a few seconds to answer, so if you need to hit that pause button, hit it. Keep track of your score. We'll talk about it at the end. Are you ready? Here we go!

Question 1. What is the main characteristic of an action query in Microsoft Access?

It changes data or database objects. It only displays matching records. It creates a form for data entry, or it prints records in a report.

Action queries change data or database objects. You got update, delete, append, and make table, and more.

Question 2. What does a make table query do?

Adds records to an existing table, creates a new table from query results, deletes a table and its records, or changes field properties in a table.

Make table query, right in the name, creates a new table from query results.

Question 3. Which query type is used to copy selected records into an existing table?

Delete, update, append, or cross tab.

That's an append query. Adds records to a table.

Question 4. Why should VBA code turn Access warnings back on after temporarily disabling them?

Warnings automatically delete temporary tables. Warnings help prevent unnoticed destructive actions. Warnings are required before opening forms, or warnings make queries run faster.

That's going to be B. Warnings help prevent unnoticed destructive actions. If you set warnings false, make sure you set warnings true after you're done.

Question 5. What is the usual purpose of the VBA MsgBox function in an Access application?

To display a message and optionally get a response, to save the current record automatically, to create a new table from selected records, or to open a query in design view.

That's a message box. See why I said MsgBox? I didn't want to give it away. Did I get anybody with that? It displays a message and optionally gets a response. You can do OK. You can do Retry, Cancel, Abort, Yes, No, all those.

All right, how'd you do? Did you get all five right? Did you rule the Program Manager like a desktop emperor? Or did you click Help and get three more windows?

If you missed any, I covered this stuff in Access Developer Level 1, Lesson 4.

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

Intro

Quiz

Q1. What is the main characteristic of an action query in Microsoft Access?
A. It changes data or database objects
B. It only displays matching records
C. It creates a form for data entry
D. It prints records in a report

Q2. What does a make table query do?
A. Adds records to an existing table
B. Creates a new table from query results
C. Deletes a table and its records
D. Changes field properties in a table

Q3. Which query type is used to copy selected records into an existing table?
A. Delete query
B. Update query
C. Append query
D. Crosstab query

Q4. Why should VBA code turn Access warnings back on after temporarily disabling them?
A. Warnings automatically delete temporary tables
B. Warnings help prevent unnoticed destructive actions
C. Warnings are required before opening forms
D. Warnings make queries run faster

Q5. What is the usual purpose of the VBA MsgBox function in an Access application?
A. To display a message and optionally get a response
B. To save the current record automatically
C. To create a new table from selected records
D. To open a query in design view

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

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

In today's Video Quiz, I have five developer-level Microsoft Access questions for you. Keep track of your answers and see how well you do.

Question 1: What is the main characteristic of an action query in Microsoft Access?

An action query changes data or database objects. Common examples include update queries, delete queries, append queries, and make-table queries. Unlike a select query, which only displays matching records, an action query performs a change in the database.

Question 2: What does a make-table query do?

A make-table query creates a new table using the results of a query. It does not add records to an existing table, delete a table, or modify table field properties. Its purpose is to take the records returned by a query and place them into a newly created table.

Question 3: Which query type is used to copy selected records into an existing table?

The answer is an append query. An append query adds records from one table or query into an existing table. This is useful when you need to copy selected data into another table without replacing the records already there.

Question 4: Why should VBA code turn Access warnings back on after temporarily disabling them?

The correct answer is that warnings help prevent unnoticed destructive actions. If VBA temporarily disables Access warnings so that action queries or other automated tasks can run without interruption, it is important to turn those warnings back on afterward. Otherwise, users may be able to run delete queries, update queries, and other potentially destructive actions without receiving a confirmation prompt.

Question 5: What is the usual purpose of the VBA MsgBox function in an Access application?

MsgBox displays a message to the user and can optionally collect a response. For example, it can show an OK button, or provide choices such as Yes and No, Retry and Cancel, or Abort, Retry, and Ignore. It is commonly used to notify users of information, display warnings, or ask for confirmation before proceeding with an action.

If you missed any of these questions, I cover these topics in Access Developer Level 1, Lesson 4.

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

Action queries in Access
Make table queries
Append queries
Access warnings in VBA
VBA MsgBox function

Article

This is a video quiz. No article needed.

Primary Topics

action queries, make-table queries, append queries, Access warning settings, VBA MsgBox

Secondary Topics

update queries, delete queries, destructive actions, user responses in message boxes