Filters
Question type
Study Flashcards

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


A) SELECT,FROM,WHERE,ORDER BY
B) RECORD,TO,WHERE,ORDER BY
C) CREATE,SELECT,FROM,WHERE
D) CREATE,FROM,SELECT,ORDER BY

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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


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

E) All of the above
F) A) and C)

Correct Answer

verifed

verified

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


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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


A) message
B) command
C) action
D) macro

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

A state,condition,or occurrence detectable by Access.


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) A) and T)
V) E) and L)

Correct Answer

verifed

verified

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?


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

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

​Toggles to open and close the Action Catalog pane


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) P) and R)
V) D) and T)

Correct Answer

verifed

verified

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


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) G) and H)
V) N) and S)

Correct Answer

verifed

verified

Which of the following describe the five SQL statement types?


A) modify,update,delete,insert,create
B) select,modify,remove,insert,create
C) select,update,delete,insert,create
D) remove,update,delete,add,rename

E) All of the above
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

​Displays a scrollable list of values


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) Q) and T)
V) F) and T)

Correct Answer

verifed

verified

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


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) D) and M)
V) K) and R)

Correct Answer

verifed

verified

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


A) OnClose
B) Input Mask
C) Validation Rule
D) Border Style

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

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


A) OpenForm
B) RunMenuCommand
C) message box
D) SelectObject
E) event
F) View Argument
G) WHERE
H) GoToControl
I) FROM
J) SQL
K) Single step
L) Action Catalog button
M) Macro
N) Action
O) OpenForm Action
P) Navigation form
Q) List box control
R) Comment
S) Search box
T) Argument

U) F) and K)
V) H) and T)

Correct Answer

verifed

verified

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 ____.


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

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

Showing 41 - 60 of 75

Related Exams

Exam 1

Creating a Database

75 Questions

Exam 2

Building a Database and Defining Table Relationships

75 Questions

Exam 3

Maintaining and Querying a Database

75 Questions

Exam 4

Creating Forms and Reports

75 Questions

Exam 5

Creating Advanced Queries and Enhancing Table Design

75 Questions

Exam 6

Using Form Tools and Creating Custom Formsmodule

75 Questions

Exam 7

Creating Custom Reports

75 Questions

Exam 8

Sharing,integrating,and Analyzing Data

75 Questions

Exam 9

Using Action Queries and Advanced Table Relationships

75 Questions

Exam 11

Using and Writing Visual Basic for Applications Code

75 Questions

Exam 12

Managing and Securing a Database

75 Questions

Exam 13

Relational Databases and Database Design

75 Questions

Show Answer