Exam 10: Automating Tasks With Macros

Elaina is the database administrator for a women's fitness franchise.She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients. Elaina will create macros to automate the functions. -Elaina needs to move the focus to a particular field in the Client form.Which Access action should she add to the macro?

(Multiple Choice)

4.9/5

(40)

Question 41

An object in Access responds to an event,such as clicking on a command button,based on specified event properties.

(True/False)

5.0/5

(30)

Question 42

The four sections of a basic SQL statement include clauses that begin with which group of keywords?

(Multiple Choice)

4.9/5

(41)

Question 43

A state,condition,or occurrence detectable by Access.

(Multiple Choice)

4.9/5

(35)

Question 44

Which of the following is an example of a submacro within a macro?

(Multiple Choice)

4.8/5

(42)

Question 45

In an SQL SELECT statement,tables to be used for the query are listed after the keyword ____.

(Multiple Choice)

4.7/5

(36)

Question 46

Which of the following describe the five SQL statement types?

(Multiple Choice)

4.8/5

(34)

Question 47

Misaki is a new Reservation Specialist for an event rental company.She has asked the database administrator,Kirk,to develop an interface for her to access the database objects she needs because she is not familiar with Access. -Kirk agrees to create the interface.He realizes that the greatest benefit of the interface is to minimize ____.

(Multiple Choice)

4.9/5

(32)

Question 48

A text description for the benefit of database developers and has no effect on the macro

(Multiple Choice)

4.8/5

(31)

Question 49

The action that selects and runs a command on the ribbon.

(Multiple Choice)

4.8/5

(28)

Question 50

After searching for a specific action in the Action Catalog pane,all actions may be displayed again by clicking on the ____ button.

(Multiple Choice)

4.8/5

(43)

Question 51

Macros may only be run from within a form or report.

(True/False)

4.8/5

(42)

Question 52

To define the data that is retrieved from a database and how the data is presented,SQL uses the SELECT statement.____________________

(True/False)

4.9/5

(37)

Question 53

A comment used to describe an action included in a macro must begin with /*.

(True/False)

4.8/5

(32)

Question 54

Access automatically constructs an equivalent SQL statement for queries when the query is created.

(True/False)

4.7/5

(38)

Question 55

A recorded sequence of commands or keystrokes that can be saved and then executed, or run,by a single action by the user

(Multiple Choice)

4.8/5

(24)

Question 56

A button that performs an action when the user clicks on the button is a(n)____ button.

(Multiple Choice)

4.9/5

(37)

Question 57

Which of the following is an example of an event property?

(Multiple Choice)

4.8/5

(32)

Question 58

Displays a scrollable list of values

(Multiple Choice)

4.9/5

(45)

Question 59

Toggles to open and close the Action Catalog pane

(Multiple Choice)

4.9/5

(33)

Question 60

Showing 41 - 60 of 75

An object in Access responds to an event,such as clicking on a command button,based on specified event properties.

The four sections of a basic SQL statement include clauses that begin with which group of keywords?

A state,condition,or occurrence detectable by Access.

Which of the following is an example of a submacro within a macro?

In an SQL SELECT statement,tables to be used for the query are listed after the keyword ____.

Which of the following describe the five SQL statement types?

A text description for the benefit of database developers and has no effect on the macro

The action that selects and runs a command on the ribbon.

After searching for a specific action in the Action Catalog pane,all actions may be displayed again by clicking on the ____ button.

Macros may only be run from within a form or report.

To define the data that is retrieved from a database and how the data is presented,SQL uses the SELECT statement.____________________

A comment used to describe an action included in a macro must begin with /*.

Access automatically constructs an equivalent SQL statement for queries when the query is created.

A recorded sequence of commands or keystrokes that can be saved and then executed, or run,by a single action by the user

A button that performs an action when the user clicks on the button is a(n)____ button.

Which of the following is an example of an event property?

Displays a scrollable list of values

Toggles to open and close the Action Catalog pane

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 10: Automating Tasks With Macros

An object in Access responds to an event,such as clicking on a command button,based on specified event properties.

The four sections of a basic SQL statement include clauses that begin with which group of keywords?

A state,condition,or occurrence detectable by Access.

Which of the following is an example of a submacro within a macro?

In an SQL SELECT statement,tables to be used for the query are listed after the keyword ____.

Which of the following describe the five SQL statement types?

​A text description for the benefit of database developers and has no effect on the macro

The action that selects and runs a command on the ribbon.

After searching for a specific action in the Action Catalog pane,all actions may be displayed again by clicking on the ____ button.

Macros may only be run from within a form or report.

To define the data that is retrieved from a database and how the data is presented,SQL uses the SELECT statement.____________________

A comment used to describe an action included in a macro must begin with /*.

Access automatically constructs an equivalent SQL statement for queries when the query is created.

A recorded sequence of commands or keystrokes that can be saved and then executed, or run,by a single action by the user

A button that performs an action when the user clicks on the button is a(n)____ button.

Which of the following is an example of an event property?

​Displays a scrollable list of values

​Toggles to open and close the Action Catalog pane

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

A text description for the benefit of database developers and has no effect on the macro

Displays a scrollable list of values

Toggles to open and close the Action Catalog pane