Filters
Question type
Study Flashcards

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

Correct Answer

verifed

verified

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

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

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

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

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

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

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

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

Correct Answer

verifed

verified

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

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

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

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

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

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

Correct Answer

verifed

verified

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

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

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

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