Exam 11: Enhanced Database Techniques

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Macros can be created to run other macros inside of them.

Free
(True/False)
4.9/5
(35)
Correct Answer:
Verified

True

A(n)________ macro is a database object that you create and use independently of other controls or objects.

Free
(Short Answer)
4.8/5
(32)
Correct Answer:
Verified

stand-alone,stand alone

The On Close event is triggered only if there is a macro attached to it.

Free
(True/False)
4.8/5
(28)
Correct Answer:
Verified

False

________ are the individual steps that make up a macro.

(Short Answer)
4.9/5
(33)

Which of the four is not considered one of the four basic words in SQL statements?

(Multiple Choice)
5.0/5
(36)

You can use the ________ Button Wizard to create an embedded macro automatically.

(Short Answer)
4.8/5
(40)
Match the following terms with their descriptions:
Data macro
Statement used to retrieve data from tables
SQL SELECT statement
Industry-standard language for working with data in databases
Argument
Can be used independently of other objects
Correct Answer:
Verified
Premises:
Responses:
Data macro
Statement used to retrieve data from tables
SQL SELECT statement
Industry-standard language for working with data in databases
Argument
Can be used independently of other objects
Stand-alone macro
A variable,constant,or expression that is used to produce the output for an action
SQL
Triggered by table events
(Matching)
4.9/5
(34)

The Macro ________ makes it easier to create or modify macros.

(Short Answer)
4.8/5
(28)

Macros can be converted to VBA.

(True/False)
5.0/5
(35)

An SQL ________ defines the purpose and the structure of an SQL statement.

(Short Answer)
4.8/5
(28)

Access creates macros automatically when you add certain controls to forms or reports.

(True/False)
4.8/5
(30)

A standalone macro can be used independent of other controls or objects.

(True/False)
4.9/5
(37)

________ macros can help to validate and ensure the accuracy of data in a table.

(Short Answer)
4.8/5
(41)

There are two types of macros: stand-alone macros and ________ macros.

(Short Answer)
4.9/5
(37)

A(n)________ can be used to automate repetitive tasks or perform specific actions.

(Short Answer)
5.0/5
(28)
Match the following SQL keywords with their purposes:
SELECT
Specifies which fields will be displayed
FROM
Specifies the sort order of the records
WHERE
This is not a SQL keyword.
Correct Answer:
Verified
Premises:
Responses:
SELECT
Specifies which fields will be displayed
FROM
Specifies the sort order of the records
WHERE
This is not a SQL keyword.
ORDER BY
Specifies any criteria which will be applied to the records
GROUP BY
Specifies which table or tables contain the necessary fields
(Matching)
4.8/5
(35)

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

(True/False)
4.9/5
(35)

Which of the following is not an action which can be used in a data macro?

(Multiple Choice)
4.7/5
(36)
Match the following terms with their descriptions:
Argument
Automated series of actions
Stand-alone macro
Is displayed on the Navigation Pane
Macro
The MessageBox action has four of these
Correct Answer:
Verified
Premises:
Responses:
Argument
Automated series of actions
Stand-alone macro
Is displayed on the Navigation Pane
Macro
The MessageBox action has four of these
Event
Developed by IBM in the early 70s
SQL
Occurs when a user enters,edits,or deletes data
(Matching)
4.9/5
(32)

Microsoft uses IBMs version of SQL in Access.

(True/False)
4.7/5
(35)
Showing 1 - 20 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)