Question 1

A field in the Group By field list can refer to any field in a table except the ________ data types.

Accepted Answer

A) OLE Object and Memo 
B) Attachment and Hyperlink 
C) OLE Object and Attachment 
D) Memo and Hyperlink 
A) OLE Object and Memo 
B) Attachment and Hyperlink 
C) OLE Object and Attachment 
D) Memo and Hyperlink

Question 2

Match between columns
                        Premises: Physical volume
Percentage of sales revenue
Percentage of sales volume
Revenue
Net revenue

Accepted Answer

The Answer of Compares how two or more numbers are is...

Question 3

The Group By clause has to be used with Sum,Count,and so on in order to display aggregated data.

Accepted Answer

A) True 
 B)False

Question 4

The ________ is automatically cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

Accepted Answer

The answer of The ________ is automatically cleared once you...

Question 5

Which of the following is NOT true in regard to crosstab queries?

Accepted Answer

A) Crosstab queries can be a useful way to present data in a compact and summarized format. 
B) Crosstab queries are the same type of query as those which perform aggregate functions. 
C) Crosstab queries are useful for summarizing data,calculating statistics,identifying bad data,and looking for trends. 
D) A crosstab query is a special type of query that can be created when you want to describe one number in terms of two other numbers. 
A) Crosstab queries can be a useful way to present data in a compact and summarized format. 
B) Crosstab queries are the same type of query as those which perform aggregate functions. 
C) Crosstab queries are useful for summarizing data,calculating statistics,identifying bad data,and looking for trends. 
D) A crosstab query is a special type of query that can be created when you want to describe one number in terms of two other numbers.

Question 6

The Show check box has to be manually cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

Accepted Answer

A) True 
 B)False

Question 7

A union query 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

A) True 
 B)False

Question 8

The ________ clause allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically.

Accepted Answer

A) As 
B) Having 
C) Where 
D) Group By 
A) As 
B) Having 
C) Where 
D) Group By

Question 9

Which of the following will NOT calculate the same answer for (Sum([Fee])*0.38)?

Accepted Answer

A) Sum([Fee]*(1-.38)) 
B) Sum([Fee]*.62) 
C) Sum([Fee]*1.00-0.38) 
D) Sum([Fee]*1.62) 
A) Sum([Fee]*(1-.38)) 
B) Sum([Fee]*.62) 
C) Sum([Fee]*1.00-0.38) 
D) Sum([Fee]*1.62)

Question 10

Which of the following is NOT true regarding the Group By clause?

Accepted Answer

A) The Group By clause needs to be used with Sum,Count,and so on to display aggregated data. 
B) The Group By clause can be used to summarize duplicate data. 
C) By using the Group By clause,you can combine records with identical values in a specified field list into a single record. 
D) The Group By clause allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically. 
A) The Group By clause needs to be used with Sum,Count,and so on to display aggregated data. 
B) The Group By clause can be used to summarize duplicate data. 
C) By using the Group By clause,you can combine records with identical values in a specified field list into a single record. 
D) The Group By clause allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically.

Question 11

The following SELECT statement: SELECT EmpFirstName,EmpLastName
FROM tblEmployee
WHERE EmpLastName Like "[D-G]*";
Would list the EmpFirstName and EmpLastName that ________.

Accepted Answer

A) begins with the letters D,E,F,and G sorted in ascending order 
B) begins with the letters D,E,F,and G sorted in descending order 
C) begins with the letters D,E,F,and G not sorted in any particular order 
D) begins with the letters E and F 
A) begins with the letters D,E,F,and G sorted in ascending order 
B) begins with the letters D,E,F,and G sorted in descending order 
C) begins with the letters D,E,F,and G not sorted in any particular order 
D) begins with the letters E and F

Question 12

An aggregate function differs from a calculated field in that when you create a calculated field,you are calculating or summarizing data across a single row at a time.

Accepted Answer

A) True 
 B)False

Question 13

A union query is used to query unrelated tables or queries and combine the results into a single dataset.

Accepted Answer

A) True 
 B)False

Question 14

Even though you can select all the fields from a table,you cannot use a(n)________ in a query in which you are using the GROUP BY clause.

Accepted Answer

A) semicolon 
B) asterisk 
C) dollar sign 
D) ampersand 
A) semicolon 
B) asterisk 
C) dollar sign 
D) ampersand

Question 15

When you edit a crosstab query in Design view,you use the ________ and ________ 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

The answer of When you edit a crosstab query in...

Question 16

Joins are performed based on a(n)________,which specifies the condition to use in order to perform a join.

Accepted Answer

The answer of Joins are performed based on a(n)________,which specifies...

Question 17

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

Accepted Answer

The answer of A subquery is usually added in the...

Question 18

Match the following terms to their definition:
I.SELECT
II.FROM
III.WHERE
IV.AS
V.HAVING
A.Includes field names
B.Specifies the rows returned in the dataset
C.Specifies aggregated field criteria
D.Includes table names
E.Used to rename fields

Accepted Answer

The answer of Match the following terms to their definition:
I.SELECT
II.FROM
III.WHERE
IV.AS
V.HAVING
A.Includes...

Question 19

The INNER JOIN clause returns all rows from at least one of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.

Accepted Answer

A) True 
 B)False

Question 20

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

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

A field in the Group By field list can refer to any field in a table except the ________ data types.

The Group By clause has to be used with Sum,Count,and so on in order to display aggregated data.

The ________ is automatically cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

Which of the following is NOT true in regard to crosstab queries?

The Show check box has to be manually cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

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

The ________ clause allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically.

Which of the following will NOT calculate the same answer for (Sum([Fee])*0.38)?

Which of the following is NOT true regarding the Group By clause?

The following SELECT statement: SELECT EmpFirstName,EmpLastName FROM tblEmployee WHERE EmpLastName Like "[D-G]*"; Would list the EmpFirstName and EmpLastName that ________.

An aggregate function differs from a calculated field in that when you create a calculated field,you are calculating or summarizing data across a single row at a time.

A union query is used to query unrelated tables or queries and combine the results into a single dataset.

Even though you can select all the fields from a table,you cannot use a(n)________ in a query in which you are using the GROUP BY clause.

When you edit a crosstab query in Design view,you use the and 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.

Joins are performed based on a(n)________,which specifies the condition to use in order to perform a join.

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

Match the following terms to their definition: I.SELECT II.FROM III.WHERE IV.AS V.HAVING A.Includes field names B.Specifies the rows returned in the dataset C.Specifies aggregated field criteria D.Includes table names E.Used to rename fields

The INNER JOIN clause returns all rows from at least one of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.

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.

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 field in the Group By field list can refer to any field in a table except the ________ data types.

The Group By clause has to be used with Sum,Count,and so on in order to display aggregated data.

The ________ is automatically cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

Which of the following is NOT true in regard to crosstab queries?

The Show check box has to be manually cleared once you select "Where" because Access cannot display a field when it is included in an aggregate function.

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

The ________ clause allows you to limit the results of your query by specifying criteria that field values must meet without using that field to group the data mathematically.

Which of the following will NOT calculate the same answer for (Sum([Fee])*0.38)?

Which of the following is NOT true regarding the Group By clause?

The following SELECT statement: SELECT EmpFirstName,EmpLastName FROM tblEmployee WHERE EmpLastName Like "[D-G]*"; Would list the EmpFirstName and EmpLastName that ________.

An aggregate function differs from a calculated field in that when you create a calculated field,you are calculating or summarizing data across a single row at a time.

A union query is used to query unrelated tables or queries and combine the results into a single dataset.

Even though you can select all the fields from a table,you cannot use a(n)________ in a query in which you are using the GROUP BY clause.

When you edit a crosstab query in Design view,you use the ________ and ________ 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.

Joins are performed based on a(n)________,which specifies the condition to use in order to perform a join.

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

Match the following terms to their definition: I.SELECT II.FROM III.WHERE IV.AS V.HAVING A.Includes field names B.Specifies the rows returned in the dataset C.Specifies aggregated field criteria D.Includes table names E.Used to rename fields

The INNER JOIN clause returns all rows from at least one of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.

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.

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

When you edit a crosstab query in Design view,you use the and 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.