Question 1

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?

Accepted Answer

A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join

Question 2

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

Accepted Answer

A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action

Question 3

Which of the following statements is true?

Accepted Answer

A)  When a report or form opens,the On Open event occurs. 
B)  When a user hovers the mouse over a button on a form,the On Mouse Move event occurs. 
C)  When a user pushes a button on a form,the On Click event occurs. 
D)  all of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements is true about junction tables?

Accepted Answer

A)  A junction table must contain the primary key from each of the related tables. 
B)  Each field is a foreign key that links the related table. 
C)  both A and B 
D)  neither A nor B

Question 6

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

Accepted Answer

A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action

Question 7

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

Accepted Answer

A)  List Rows 
B)  List Width 
C)  Limit to List 
D)  Allow Value List Edits

Question 8

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

Accepted Answer

A)  decide what event will cause the macro to execute 
B)  plan out the logic behind the steps,or tasks,the macro will perform 
C)  determine the type of macro needed and the best way to build the macro 
D)  all of the above

Question 9

Why are junction tables important?

Accepted Answer

The answer of Why are junction tables important?...

Question 10

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

Accepted Answer

The answer of What is the difference between a stand-alone...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  parameter 
B)  Single Step tool 
C)  Application Log 
D)  Macro Builder

Question 13

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

Accepted Answer

A)  On Click 
B)  On Dbl Click 
C)  On Got Focus 
D)  On Enter

Question 14

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

Accepted Answer

The answer of When working with tables in a many-to-many...

Question 15

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

Accepted Answer

A)  user interface macros 
B)  data macros 
C)  events 
D)  macro window

Question 16

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

Accepted Answer

A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search

Question 17

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

Accepted Answer

A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search

Question 18

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

Accepted Answer

A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join

Question 19

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

Accepted Answer

A) True 
 B)False

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.