Deck 6: Creating Advanced Queries and Reports and Using SQL

Question 1

Comments affect the logic or functionality of macros.

Answer 1

False

Question 2

An embedded macro is attached to one specific object or control on an object.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

SQL is the underlying language in a relational database system.

Question 5

The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

Question 6

Macros in Access are the same as the macros you may have created in Excel or Word.

Question 7

You can create a stand-alone macro that executes automatically when the database is first opened.

Question 8

Changing a relationship's join type only affects the way queries,and any object built from a query,work.

Question 9

Relational databases,like Access,do not directly support many-to-many relationships.

Question 10

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

Question 11

When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.

Question 12

A stand-alone macro is a separate Access object that appears in the Navigation pane.

Question 13

The join type property determines how to match the data in the two related tables.

Question 14

Events are occurring all of the time when you use a database.

Question 15

Design view is an available option for objects in web databases.

Question 16

When a relationship is created,Access assigns it an inner join type.

Question 17

Most templates open with the Navigation pane closed.

Question 18

A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.

Question 19

For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.

Question 20

User interface macros are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface.

Question 21

Which of the following Access templates is used to track information about people,such as team members,customers,etc?

A) Desktop asset tracking
B) Desktop contacts
C) Desktop issue tracking
D) Desktop project management

Question 22

Which of the following Lookup field properties determines whether a user can enter a value into the field?

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

Question 23

Which of the following Access templates is used to track assets within an organization,such as computers or office equipment?

A) Desktop asset tracking
B) Desktop contacts
C) Desktop issue tracking
D) Desktop project management

Question 24

The property sheet of an object or control displays all the possible events on the Event tab.

Question 25

Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

Question 26

A macro that runs when a database is first opened is an AutoExec macro.

Question 27

Before creating an embedded macro,you must first open the property sheet of the object or control.

Question 28

Which of the following Lookup field properties determines whether a user can edit the list of items?

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

Question 29

An embedded macro is automatically created when you use the Command Button Wizard to attach functionality to a button.

Question 30

Which of the following Access templates is used to track information about reported issues that need to be resolved?

A) Desktop asset tracking
B) Desktop contacts
C) Desktop issue tracking
D) Desktop project management

Question 31

Which of the following statements is not true of online web databases?

A) Design view is an available option for objects in web databases.
B) For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.
C) In web databases,relationships are created and modified through a Lookup field and not through the Relationships window.
D) Access databases that are built to work online are different.

Question 32

Edit an embedded macro by right-clicking the macro name from the Navigation pane and selecting design view.

Question 33

Which of the following Access templates is used to track information about different projects and their related tasks?

A) Desktop asset tracking
B) Desktop contacts
C) Desktop issue tracking
D) Desktop project management

Question 34

Which of the following happens after completing the Lookup Wizard?

A) Access automatically creates a relationship between the two tables.
B) Access does not create a relationship between the two tables.
C) Access sometimes creates a relationship between the two tables,depending on your selections.
D) Access gives you the option of creating a relationship between the two tables.

Question 35

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

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

Question 36

The Macro Builder contains the Single Step tool,which can execute the macro one action,or step,at a time.

Question 37

Which of the following Lookup field properties determines the width of the drop-down list?

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

Question 38

A submacro is a named,executable set of actions that perform a specific task.

Question 39

Using a parameter in a named data macro allows you to pass data out of a macro.

Question 40

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

Question 41

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?

A) Build the tables on the "one" side of the relationship first.
B) Define the primary key for each of the "one" side tables.
C) Build the junction table and define the primary key for the junction table.
D) all of the above.

Question 42

Which of the following statements is true about junction tables?

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 43

Which of the following is the most common type of program flow statement?

A) program flow statement
B) Action
C) Comment
D) Macro Builder

Question 44

Which of the following keys will help you select multiple foreign keys?

A) Ctrl
B) Shift
C) Shift+Tab
D) Tab

Question 45

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

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

Question 46

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

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 47

Which of the following are attached to tables?

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

Question 48

Which of the following returns only records that have matching values in both tables?

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

Question 49

Which of the following is the underlying language in a relational database system?

A) Application Log
B) Macro Builder
C) Lookup Wizard
D) Structured Query Language

Question 50

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

A) junction table
B) concatenated primary key
C) macro
D) Application Log

Question 51

Which of the following lets you write and edit he content of all macros?

A) program flow statement
B) Action
C) Comment
D) Macro Builder

Question 52

Which of the following statements is true about deleting a relationship created with a Lookup field?

A) Occasionally you may need to remove a relationship that was not created correctly.
B) If the relationship was the result of using the Lookup Wizard,you most likely will need to delete both the relationship and the lookup attached to the field.
C) After deleting a relationship,you may need to change the Display Control property of the field so it is no longer a combo box.
D) all of the above

Question 53

Which of the following provides organizational structure to a macro?

A) program flow statement
B) Action
C) Comment
D) Macro Builder

Question 54

Which of the following statements is true?

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 55

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?

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

Question 56

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

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

Question 57

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?

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

Question 58

When a relationship is created,what kind of join does Access assign?

A) inner join
B) left outer join
C) right outer join
D) none of the above

Question 59

Which of the following is an individual command inside of a macro?

A) program flow statement
B) Action
C) Comment
D) Macro Builder

Question 60

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

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

Question 61

Which of the following is a piece of information needed to complete an action?

A) group
B) argument
C) submacro
D) If block

Question 62

Which of the following events executes immediately before a control,on a form or report,loses the focus to another control on the same form or report?

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

Question 63

Which of the following executes when the user releases a key that he or she was pressing?

A) On Mouse Up
B) On Key Up
C) On Open
D) On Activate

Question 64

Which of the following lets you integrate conditional logic into the execution of a macro?

A) group
B) argument
C) submacro
D) If block

Question 65

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

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

Question 66

Which of the following events executes when an object/ control receives focus?

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

Question 67

Which of the following categories of user interface macros relates to importing,exporting,sending,and collecting data?

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

Question 68

Which of the following lets you paste an action?

A) Ctrl+C
B) Ctrl+X
C) Ctrl+V
D) Ctrl+P

Question 69

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

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

Question 70

Which of the following events is only used with text box controls?

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

Question 71

Which of the following executes when a mouse button is released after having been pressed?

A) On Mouse Up
B) On Key Up
C) On Open
D) On Activate

Question 72

Which of the following is a named block of actions?

A) group
B) argument
C) submacro
D) If block

Question 73

Which of the following executes when a form or report is opened?

A) On Mouse Up
B) On Key Up
C) On Open
D) On Activate

Question 74

Which of the following categories of user interface macros relates to changing the data?

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

Question 75

Which of the following categories of user interface macros relates to controlling what is shown on the screen?

A) Database Objects
B) Data Entry Operations
C) System Commands
D) User Interface Commands

Question 76

Which of the following lets you copy an action?

A) Ctrl+C
B) Ctrl+X
C) Ctrl+V
D) Ctrl+P

Question 77

Which of the following is a named,executable set of actions that perform a specific task?

A) group
B) argument
C) submacro
D) If block

Question 78

Which of the following categories of user interface macros relates to changing the database system?

A) Database Objects
B) Data Entry Operations
C) System Commands
D) User Interface Commands

Question 79

Which of the following executes after a form or report is already opened and the object gains the focus?

A) On Mouse Up
B) On Key Up
C) On Open
D) On Activate

Question 80

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

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