Question 1

The ________ aggregate function limits the results without grouping the data by the field.

Accepted Answer

A) Last 
B) Where 
C) First 
D) Expression 
A) Last 
B) Where 
C) First 
D) Expression

Question 2

The following SELECT statement: SELECT *
FROM tblCustomers
WHERE LastName Like "smith";
Would list ________.

Accepted Answer

A) all customers first and last names from tblCustomers with a last name that begins with "smith" 
B) all fields from tblCustomers with a last name that begins with "smith" 
C) all fields from tblCustomers where the customers' last name is "smith" 
D) all fields from tblCustomers where the customers' last name contains "smith" 
A) all customers first and last names from tblCustomers with a last name that begins with "smith" 
B) all fields from tblCustomers with a last name that begins with "smith" 
C) all fields from tblCustomers where the customers' last name is "smith" 
D) all fields from tblCustomers where the customers' last name contains "smith"

Question 3

Everything you have learned how to do in Design view can also be done in SQL view.

Accepted Answer

A) True 
 B)False

Question 4

The WHERE clause,which is required in a SELECT statement,narrows the query results by specifying which rows in the table will be returned in the dataset.

Accepted Answer

A) True 
 B)False

Question 5

When you edit a crosstab query in Design view,you use the Total and Crosstab 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) True 
 B)False

Question 6

The ________ can compare the portion of the gross revenue to the total gross revenue.

Accepted Answer

A) revenue 
B) percentage of sales revenue 
C) net income 
D) percentage of physical volume 
A) revenue 
B) percentage of sales revenue 
C) net income 
D) percentage of physical volume

Question 7

Revenue is income that a company receives from its normal business activities such as the sale of goods and services to customers.

Accepted Answer

A) True 
 B)False

Question 8

The ________ clause sorts the result of a query according to the values in one or more specific columns.

Accepted Answer

The answer of The ________ clause sorts the result of...

Question 9

By using the ________ clause,you can combine records with identical values in a specified field list into a single record.

Accepted Answer

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

Question 10

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 ________ in the background.

Accepted Answer

The answer of Each query that you create has an...

Question 11

When writing SQL,you cannot use a renamed field in the ________ clause.You must use the original field name.

Accepted Answer

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

Question 12

Sales volume is the number of items sold or services rendered during normal business hours.All these figures would be taken over a specific period-week,month,year,and so on-and can be expressed in either dollars or percentages.

Accepted Answer

A) True 
 B)False

Question 13

The SQL ________ clause specifies which table rows are used.

Accepted Answer

The answer of The SQL ________ clause specifies which table...

Question 14

A(n)________ is used to query unrelated tables or queries and combine the results into a single dataset.This type of query is different from querying related tables as it combines two SQL SELECT statements.

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Another way a(n)________ clause can be used is to summarize duplicate data.

Accepted Answer

The answer of Another way a(n)________ clause can be used...

Question 17

Match between columns
                        Premises: INNER JOIN
OUTER JOIN
FULL JOIN
Union query
SQL subquery

Accepted Answer

The Answer of Returns only the rows that actually match is...

Question 18

A crosstab query is different than the aggregate functions that you have been completing thus far because it groups the aggregates by the ________ and ________ headings.

Accepted Answer

The answer of A crosstab query is different than the...

Question 19

________ is the number of items sold or services rendered during normal business hours.

Accepted Answer

A) Sales revenue 
B) Net revenue 
C) Physical volume 
D) Sales volume 
A) Sales revenue 
B) Net revenue 
C) Physical volume 
D) Sales volume

Question 20

Match between columns
                        Premises: SELECT
FROM
WHERE
AS
HAVING

Accepted Answer

The Answer of Includes field names and Specifies the rows is...

The ________ aggregate function limits the results without grouping the data by the field.

The following SELECT statement: SELECT * FROM tblCustomers WHERE LastName Like "smith"; Would list ________.

Everything you have learned how to do in Design view can also be done in SQL view.

The WHERE clause,which is required in a SELECT statement,narrows the query results by specifying which rows in the table will be returned in the dataset.

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

The ________ can compare the portion of the gross revenue to the total gross revenue.

Revenue is income that a company receives from its normal business activities such as the sale of goods and services to customers.

The ________ clause sorts the result of a query according to the values in one or more specific columns.

By using the ________ clause,you can combine records with identical values in a specified field list into a single record.

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 ________ in the background.

When writing SQL,you cannot use a renamed field in the ________ clause.You must use the original field name.

Sales volume is the number of items sold or services rendered during normal business hours.All these figures would be taken over a specific period-week,month,year,and so on-and can be expressed in either dollars or percentages.

The SQL ________ clause specifies which table rows are used.

A(n)________ is used to query unrelated tables or queries and combine the results into a single dataset.This type of query is different from querying related tables as it combines two SQL SELECT statements.

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

Another way a(n)________ clause can be used is to summarize duplicate data.

A crosstab query is different than the aggregate functions that you have been completing thus far because it groups the aggregates by the and headings.

________ is the number of items sold or services rendered during normal business hours.

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

The ________ aggregate function limits the results without grouping the data by the field.

The following SELECT statement: SELECT * FROM tblCustomers WHERE LastName Like "smith"; Would list ________.

Everything you have learned how to do in Design view can also be done in SQL view.

The WHERE clause,which is required in a SELECT statement,narrows the query results by specifying which rows in the table will be returned in the dataset.

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

The ________ can compare the portion of the gross revenue to the total gross revenue.

Revenue is income that a company receives from its normal business activities such as the sale of goods and services to customers.

The ________ clause sorts the result of a query according to the values in one or more specific columns.

By using the ________ clause,you can combine records with identical values in a specified field list into a single record.

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 ________ in the background.

When writing SQL,you cannot use a renamed field in the ________ clause.You must use the original field name.

Sales volume is the number of items sold or services rendered during normal business hours.All these figures would be taken over a specific period-week,month,year,and so on-and can be expressed in either dollars or percentages.

The SQL ________ clause specifies which table rows are used.

A(n)________ is used to query unrelated tables or queries and combine the results into a single dataset.This type of query is different from querying related tables as it combines two SQL SELECT statements.

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

Another way a(n)________ clause can be used is to summarize duplicate data.

A crosstab query is different than the aggregate functions that you have been completing thus far because it groups the aggregates by the ________ and ________ headings.

________ is the number of items sold or services rendered during normal business hours.

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

A crosstab query is different than the aggregate functions that you have been completing thus far because it groups the aggregates by the and headings.