Question 1

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  WHERE 
B)  FROM 
C)  SELECT 
D)  TABLE 
A)  WHERE 
B)  FROM 
C)  SELECT 
D)  TABLE

Question 3

When Access opens a form or report, the ____ event occurs.

Accepted Answer

A)  Open 
B)  Load 
C)  View 
D)  Link 
A)  Open 
B)  Load 
C)  View 
D)  Link

Question 4

Match between columns
                        Premises: The action that moves the focus to a specified field or control on the active datasheet or form.

Accepted Answer

The Answer of message box and SelectObject and SQL and is...

Question 5

List five techniques for positioning controls on forms and reports to create an easily readable, but functional, form with many fields and controls.

Accepted Answer

1. Align controls on a from as precisely

Question 6

Most database developers prefer to prevent inexperienced database users from using which type of query?

Accepted Answer

A)  action 
B)  cross-tab 
C)  select 
D)  parameter 
A)  action 
B)  cross-tab 
C)  select 
D)  parameter

Question 7

Case-Based Critical Thinking Questions Case 10-2
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 ____.

Accepted Answer

A)  the user's ability to use the database 
B)  the information available from the database 
C)  data being corrupted inadvertently 
D)  the administration of the database 
A)  the user's ability to use the database 
B)  the information available from the database 
C)  data being corrupted inadvertently 
D)  the administration of the database

Question 8

Single step mode is accessed from the Tools group on the ____________________ tab when in creating or modifying a macro.

Accepted Answer

The answer of Single step mode is accessed from the...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In the accompanying figure, the action is being initiated by what event?

Accepted Answer

A)  OnLoad 
B)  OnClick 
C)  OnClose 
D)  Command3 
A)  OnLoad 
B)  OnClick 
C)  OnClose 
D)  Command3

Question 11

In the accompanying figure, Access has been programmed to show the results of the action as a(n) ____.

Accepted Answer

A)  Query Name 
B)  OpenQuery 
C)  Datasheet 
D)  frmQueries 
A)  Query Name 
B)  OpenQuery 
C)  Datasheet 
D)  frmQueries

Question 12

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

Accepted Answer

A)  Expand All 
B)  search 
C)  clear filter 
D)  Undo 
A)  Expand All 
B)  search 
C)  clear filter 
D)  Undo

Question 13

Match between columns
                        Premises: A SQL keyword after which the tables used in a query are listed in a SQL SELECT statement.

Accepted Answer

The Answer of SelectObject and OpenForm and RunMenuCommand and message is...

Question 14

Match between columns
                        Premises: The action that opens a specified form in a specified view.

Accepted Answer

The Answer of View Argument and SQL and GoToControl and is...

Question 15

To embed a chart in a form or report to show data visually rather than in datasheets, use the ____________________.

Accepted Answer

The answer of To embed a chart in a form...

Question 16

Case-Based Critical Thinking Questions Case 10-2
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 has determined he needs a list box of all of the queries in the database to include in the interface he is developing.  Access maintains special tables that store information about the structure of the objects in the database. The ____ system table, stores information about the names, types, and other characteristics of every object in a database.  Kirk will write an SQL statement that includes information from this table.

Accepted Answer

A)  USysRibbon 
B)  MSysObjects 
C)  MSysQueries 
D)  MSysSelect 
A)  USysRibbon 
B)  MSysObjects 
C)  MSysQueries 
D)  MSysSelect

Question 17

A(n) ____________________ form does not use a table or query as its source.

Accepted Answer

The answer of A(n) ____________________ form does not use a...

Question 18

Because SQL SELECT statements require the use of several punctuation marks and the correct spelling of SQL keywords and functions, a(n) ____________________ -error message might appear indicating the SELECT statement needs to be edited so that it can run properly.

Accepted Answer

The answer of Because SQL SELECT statements require the use...

Question 19

In the accompanying figure illustrating a SQL SELECT statement, selected field names are separated from the table name which contains the field by a(n) ____.

Accepted Answer

A)  comma 
B)  period 
C)  semi-colon 
D)  equal symbol 
A)  comma 
B)  period 
C)  semi-colon 
D)  equal symbol

Question 20

Use the Background Color tool to copy the formatting from one control to another.____________________

Accepted Answer

A) True 
 B)False

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

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

When Access opens a form or report, the ____ event occurs.

List five techniques for positioning controls on forms and reports to create an easily readable, but functional, form with many fields and controls.

Most database developers prefer to prevent inexperienced database users from using which type of query?

Single step mode is accessed from the Tools group on the ____________________ tab when in creating or modifying a macro.

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

In the accompanying figure, the action is being initiated by what event?

In the accompanying figure, Access has been programmed to show the results of the action as a(n) ____.

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

To embed a chart in a form or report to show data visually rather than in datasheets, use the ____________________.

A(n) ____________________ form does not use a table or query as its source.

Because SQL SELECT statements require the use of several punctuation marks and the correct spelling of SQL keywords and functions, a(n) ____________________ -error message might appear indicating the SELECT statement needs to be edited so that it can run properly.

In the accompanying figure illustrating a SQL SELECT statement, selected field names are separated from the table name which contains the field by a(n) ____.

Use the Background Color tool to copy the formatting from one control to another.____________________

Managing Your Files

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 Forms

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 Sharing a Database

Filters

Exam 11: Automating Tasks With Macros

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

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

When Access opens a form or report, the ____ event occurs.

List five techniques for positioning controls on forms and reports to create an easily readable, but functional, form with many fields and controls.

Most database developers prefer to prevent inexperienced database users from using which type of query?

Single step mode is accessed from the Tools group on the ____________________ tab when in creating or modifying a macro.

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

In the accompanying figure, the action is being initiated by what event?

In the accompanying figure, Access has been programmed to show the results of the action as a(n) ____.

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

To embed a chart in a form or report to show data visually rather than in datasheets, use the ____________________.

A(n) ____________________ form does not use a table or query as its source.

Because SQL SELECT statements require the use of several punctuation marks and the correct spelling of SQL keywords and functions, a(n) ____________________ -error message might appear indicating the SELECT statement needs to be edited so that it can run properly.

In the accompanying figure illustrating a SQL SELECT statement, selected field names are separated from the table name which contains the field by a(n) ____.

Use the Background Color tool to copy the formatting from one control to another.____________________

Managing Your Files

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 Forms

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 Sharing a Database

Filters