Question 1

Macros that work with ""user interface"" objects,such as forms,reports,and buttons,are known as ________ macros.

Accepted Answer

The answer of Macros that work with ""user interface"" objects,such...

Question 2

If your SQL query does not include a WHERE statement,then ________ records will be selected.

Accepted Answer

The answer of If your SQL query does not include...

Question 3

________ is the data retrieval and data manipulation language of all the industry-leading databases.

Accepted Answer

The answer of ________ is the data retrieval and data...

Question 4

In SQL,the ________ statement is used to retrieve data from a table.

Accepted Answer

The answer of In SQL,the ________ statement is used to...

Question 5

The keyword used in SQL to establish specify the table where the fields can be found is ________.

Accepted Answer

The answer of The keyword used in SQL to establish...

Question 6

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

Accepted Answer

The answer of An SQL ________ defines the purpose and...

Question 7

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

Accepted Answer

The answer of A(n)________ can be used to automate repetitive...

Question 8

________ are the individual steps that make up a macro.

Accepted Answer

The answer of ________ are the individual steps that make...

Question 9

Structured Query Language is the industry-standard language for defining,manipulating,and retrieving the ________ in a database.

Accepted Answer

The answer of Structured Query Language is the industry-standard language...

Question 10

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

Accepted Answer

The answer of ________ macros can help to validate and...

Question 11

The keyword used in SQL to establish criteria is ________.

Accepted Answer

The answer of The keyword used in SQL to establish...

Question 12

When business logic requires the comparison of two or more fields,you need to use a(n)________ macro.

Accepted Answer

The answer of When business logic requires the comparison of...

Question 13

Match between columns
                        Premises: INTO
WHERE
ORDER BY
FROM
SELECT

Accepted Answer

The Answer of Field2 DESC and Field1,Field2,Field3 and Sample and is...

Question 14

Match between columns
                        Premises: What would need to be done to sort the records in descending order?
What would need to be done to not create the new table?
What would need to be done to change the name of the new database to "Old"?
What would need to be done to sort by the default field?
What would need to be done to delete the criteria?

Accepted Answer

The Answer of ORDER BY Contribution.PayDate DESC and Delete WHERE is...

Question 15

Match between columns
                        Premises: What are the criteria being applied?
How are the records being sorted?
Where are these fields coming from?
What is the name of the new table?
How many fields will be involved?

Accepted Answer

The Answer of (((Contribution.SSN)="456667778")) and Contribution and Six and Paydate is...

Question 16

Match between columns
                        Premises: SELECT
FROM
WHERE
ORDER BY
GROUP BY

Accepted Answer

The Answer of Specifies which fields will be displayed and is...

Question 17

Match between columns
                        Premises: Argument
Stand-alone macro
Macro
Event
SQL

Accepted Answer

The Answer of Automated series of actions and Is displayed is...

Question 18

Match between columns
                        Premises: Macro Designer
Embedded macro
Data macro
Event
Macro

Accepted Answer

The Answer of Triggered by table events and Occurs when is...

Question 19

Match between columns
                        Premises: Data macro
SQL SELECT statement
Argument
Stand-alone macro
SQL

Accepted Answer

The Answer of Statement used to retrieve data from tables is...

Question 20

Match between columns
                        Premises: SQL keyword
FROM keyword
SELECT keyword
ORDER BY keyword
WHERE keyword

Accepted Answer

The Answer of Determines the sort order in an SQL is...

Quiz 11: Enhanced Database Techniques

Macros that work with ""user interface"" objects,such as forms,reports,and buttons,are known as ________ macros.

If your SQL query does not include a WHERE statement,then ________ records will be selected.

________ is the data retrieval and data manipulation language of all the industry-leading databases.

In SQL,the ________ statement is used to retrieve data from a table.

The keyword used in SQL to establish specify the table where the fields can be found is ________.

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

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

________ are the individual steps that make up a macro.

Structured Query Language is the industry-standard language for defining,manipulating,and retrieving the ________ in a database.

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

The keyword used in SQL to establish criteria is ________.

When business logic requires the comparison of two or more fields,you need to use a(n)________ macro.

Match the following SQL keywords with their purposes:

Match the following terms with their descriptions:

Match the following terms with their descriptions:

Match the following terms with their descriptions:

Match the following terms with their descriptions: