Exam 6: Creating Advanced Queries and Reports and Using SQL

Which of the following returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join?

Which of the following executes after an existing record is changed?

Which of the following statements is true?

Create a stand-alone macro when you want to call a macro from several different objects or controls.

Which of the following statements is true about junction tables?

Which of the following changes the values in the existing record?

Which of the following Lookup field properties sets the number of choices that display in the list?

When building a macro,which of the following must you do?

Why are junction tables important?

What is the difference between a stand-alone macro and an embedded macro?

After completing the Lookup Wizard,Access automatically creates a relationship between the two tables.

Which of the following in a named data macro allows you to pass data into the macro?

Which of the following events executes after the object/ control is clicked?

When working with tables in a many-to-many relationship,what guidelines will help ensure that your database will function correctly?

Which of the following occur when an action happens to an object or control?

Which of the following categories of user interface macros relates to filtering,querying,and searching records?

Which of the following categories of user interface macros relates to changing controls and objects in the database?

Which of the following determines how to match the data in two related tables?

A macro is a database object that allows you to write and attach code to different objects and controls in your database.