Question 1

A(n)________ is a special type of query that can be created when you want to describe one number in terms of two other numbers.

Accepted Answer

crosstab query

Question 2

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

Accepted Answer

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

Question 3

If you wanted to perform an aggregated calculation on a LastName field,you would use the ________ function.

Accepted Answer

A) Sum 
B) Count 
C) Total 
D) You cannot perform aggregated calculations on text fields. 
A) Sum 
B) Count 
C) Total 
D) You cannot perform aggregated calculations on text fields. B

Question 4

A(n)________ simply is a select query that is nested inside of another select query.

Accepted Answer

The answer of A(n)________ simply is a select query that...

Question 5

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.

Accepted Answer

A) Round 
B) Int 
C) Number 
D) Precision 
A) Round 
B) Int 
C) Number 
D) Precision

Question 6

Net income is one of the most important pieces of information that a company uses to learn more about its financial progress.

Accepted Answer

A) True 
 B)False

Question 7

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

Accepted Answer

The answer of The SQL ________ clause includes the Name...

Question 8

The SQL AS clause includes the Name of the table(s)from which the information is retrieved.

Accepted Answer

A) True 
 B)False

Question 9

Match the following terms to their definition:
I.INNER JOIN
II.OUTER JOIN
III.FULL JOIN
IV.Union query
V.SQL subquery
A.Returns only the rows that actually match
B.Returns all rows from both tables
C.Usually added in the WHERE clause
D.Returns all rows from at least one of the tables
E.Combines two SQL SELECT statements

Accepted Answer

The answer of Match the following terms to their definition:
I.INNER...

Question 10

If you wanted to perform an aggregated calculation on a ProductPrice field,you would use the ________ function.

Accepted Answer

A) Sum 
B) Count 
C) Total 
D) You cannot perform aggregated calculations on text or numeric fields. 
A) Sum 
B) Count 
C) Total 
D) You cannot perform aggregated calculations on text or numeric fields.

Question 11

The SQL ________ clause specifies which table rows are used.

Accepted Answer

A) SELECT 
B) WHERE 
C) AS 
D) HAVING 
A) SELECT 
B) WHERE 
C) AS 
D) HAVING

Question 12

Another way that the Group By clause can be used is to take a count,such as a count of products or a count of customers.

Accepted Answer

A) True 
 B)False

Question 13

When you create a query in Design view,Access automatically generates the ________ in the background.

Accepted Answer

A) Form 
B) Report 
C) SQL statement 
D) Subquery 
A) Form 
B) Report 
C) SQL statement 
D) Subquery

Question 14

When you edit a crosstab query in Design view,you use the ________ rows in the design grid to specify which field value becomes the column heading,which field values become row headings,and which field's value to calculate.

Accepted Answer

A) Column and Row 
B) Criteria and Or 
C) Total and Crosstab 
D) Total and Or 
A) Column and Row 
B) Criteria and Or 
C) Total and Crosstab 
D) Total and Or

Question 15

Each query that you create has an underlying SQL statement,which means that even when you create a query in Design view,Access automatically generates the SQL statement in the background.

Accepted Answer

A) True 
 B)False

Question 16

A subquery is usually added in the ________ clause of the SQL SELECT statement.

Accepted Answer

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

Question 17

Because more sophisticated queries require more advanced manipulation of data,you may need to create a(n)________.

Accepted Answer

A) SQL query 
B) crosstab query 
C) union query 
D) subquery 
A) SQL query 
B) crosstab query 
C) union query 
D) subquery

Question 18

Which of the following is NOT true in regard to writing a SQL subquery?

Accepted Answer

A) Most of the time,a subquery is used when you know how to search for a value using a SELECT statement but do not know the exact value. 
B) A subquery is usually added in the WHERE clause of the SQL SELECT statement. 
C) A SQL subquery is a separate SELECT statement that is nested outside the main SELECT statement. 
D) This type of query is an alternate way of returning data from multiple tables and will be performed once for each row of the resulting dataset. 
A) Most of the time,a subquery is used when you know how to search for a value using a SELECT statement but do not know the exact value. 
B) A subquery is usually added in the WHERE clause of the SQL SELECT statement. 
C) A SQL subquery is a separate SELECT statement that is nested outside the main SELECT statement. 
D) This type of query is an alternate way of returning data from multiple tables and will be performed once for each row of the resulting dataset.

Question 19

The ________ clause is used to return only the rows that actually match based on the join predicate.

Accepted Answer

The answer of The ________ clause is used to return...

Question 20

The ________ is the easiest way to create a crosstab query.

Accepted Answer

Crosstab Q

A(n)________ is a special type of query that can be created when you want to describe one number in terms of two other numbers.

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

If you wanted to perform an aggregated calculation on a LastName field,you would use the ________ function.

A(n)________ simply is a select query that is nested inside of another select query.

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.

Net income is one of the most important pieces of information that a company uses to learn more about its financial progress.

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

The SQL AS clause includes the Name of the table(s)from which the information is retrieved.

If you wanted to perform an aggregated calculation on a ProductPrice field,you would use the ________ function.

The SQL ________ clause specifies which table rows are used.

Another way that the Group By clause can be used is to take a count,such as a count of products or a count of customers.

When you create a query in Design view,Access automatically generates the ________ in the background.

When you edit a crosstab query in Design view,you use the ________ rows in the design grid to specify which field value becomes the column heading,which field values become row headings,and which field's value to calculate.

Each query that you create has an underlying SQL statement,which means that even when you create a query in Design view,Access automatically generates the SQL statement in the background.

A subquery is usually added in the ________ clause of the SQL SELECT statement.

Because more sophisticated queries require more advanced manipulation of data,you may need to create a(n)________.

Which of the following is NOT true in regard to writing a SQL subquery?

The ________ clause is used to return only the rows that actually match based on the join predicate.

The ________ is the easiest way to create a crosstab query.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 7: Workshop 7: Aggregated Calculations, Subquerying, and Sql

A(n)________ is a special type of query that can be created when you want to describe one number in terms of two other numbers.

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

If you wanted to perform an aggregated calculation on a LastName field,you would use the ________ function.

A(n)________ simply is a select query that is nested inside of another select query.

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.

Net income is one of the most important pieces of information that a company uses to learn more about its financial progress.

The SQL ________ clause includes the Name of the table(s)from which the information is retrieved.

The SQL AS clause includes the Name of the table(s)from which the information is retrieved.

If you wanted to perform an aggregated calculation on a ProductPrice field,you would use the ________ function.

The SQL ________ clause specifies which table rows are used.

Another way that the Group By clause can be used is to take a count,such as a count of products or a count of customers.

When you create a query in Design view,Access automatically generates the ________ in the background.

When you edit a crosstab query in Design view,you use the ________ rows in the design grid to specify which field value becomes the column heading,which field values become row headings,and which field's value to calculate.

Each query that you create has an underlying SQL statement,which means that even when you create a query in Design view,Access automatically generates the SQL statement in the background.

A subquery is usually added in the ________ clause of the SQL SELECT statement.

Because more sophisticated queries require more advanced manipulation of data,you may need to create a(n)________.

Which of the following is NOT true in regard to writing a SQL subquery?

The ________ clause is used to return only the rows that actually match based on the join predicate.

The ________ is the easiest way to create a crosstab query.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters