Question 1

Match between columns
                        Premises: The action that selects and runs a command on the ribbon.

Accepted Answer

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

Question 2

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

Accepted Answer

The Answer of  Argument and WHERE and  Action is...

Question 3

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) OnClick.OpenCustomerTable 
B) frmInvoice.OnClose 
C) tblBilling.ListCustomer 
D) mcrLatePayment.OpenBillingTable 
A) OnClick.OpenCustomerTable 
B) frmInvoice.OnClose 
C) tblBilling.ListCustomer 
D) mcrLatePayment.OpenBillingTable

Question 5

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)"˜ ORDER BY[NAME]; what does [TYPE]=5 indicate?

Accepted Answer

A) the statement is selecting query objects in an Access system table 
B) the statement would like to display only 5 names 
C) the statement is selecting table objects in an Access system table 
D) the statement will select records in groups of 5 
A) the statement is selecting query objects in an Access system table 
B) the statement would like to display only 5 names 
C) the statement is selecting table objects in an Access system table 
D) the statement will select records in groups of 5

Question 6

Match between columns
                        Premises:  A form with tabs that allows you to display database objects in an organized way to users

Accepted Answer

The Answer of  List box control and SelectObject and is...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: A standard language used in querying, updating, and managing relational databases.

Accepted Answer

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

Question 9

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 10

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  Search box and SelectObject and View is...

Question 11

Match between columns
                        Premises: The instruction that initiates each individual command or keystroke within a macro

Accepted Answer

The Answer of OpenForm and  Single step and  is...

Question 12

In single step mode, the macro may be stopped at any time by clicking the ___ button.

Accepted Answer

A) Step 
B) Single Step 
C) Stop All Macros 
D) Continue 
A) Step 
B) Single Step 
C) Stop All Macros 
D) Continue

Question 13

A database developer may use either a macro or VBA code to display a user interface for the database.

Accepted Answer

A) True 
 B)False

Question 14

Case-Based Critical Thinking Questions
Case 10-1
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.
-In a different macro, Elaina would like to locate the first or next record that meets a specific set of criteria.  Which Access action can be added to the macro that will meet her demand?

Accepted Answer

A) SelectObject 
B) GoToControl 
C) OpenForm 
D) FindRecord 
A) SelectObject 
B) GoToControl 
C) OpenForm 
D) FindRecord

Question 15

​What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Accepted Answer

It's important to ensure that data is as

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

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

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)"˜ ORDER BY[NAME]; what does [TYPE]=5 indicate?

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

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

In single step mode, the macro may be stopped at any time by clicking the ___ button.

A database developer may use either a macro or VBA code to display a user interface for the database.

What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

Exam 10: Automating Tasks With Macros

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

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

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)"˜ ORDER BY[NAME]; what does [TYPE]=5 indicate?

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

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

In single step mode, the macro may be stopped at any time by clicking the ___ button.

A database developer may use either a macro or VBA code to display a user interface for the database.

​What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

What are some of the problems in restricting access to Database Objects and prohibiting design changes?