Question 1

In the accompanying figure, what is the primary key field of the Tours table?

Accepted Answer

A)  TourNo 
B)  Customers 
C)  Sales 
D)  Tours 
A)  TourNo 
B)  Customers 
C)  Sales 
D)  Tours

Question 2

In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Accepted Answer

Only one table is in

Question 3

Match between columns
                        Premises: A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
A field of data that is created based on values of other fields
A statistic such as a subtotal or count is determined on a given field in a group of records
A combination of field names, operators and functions
A predefined Access formula that returns a value such as a subtotal or count

Accepted Answer

The Answer of Aggregate function and Function and Sort and is...

Question 4

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Accepted Answer

The criteria for the CompanyName field w

Question 5

Which function should you use to calculate today's current date?

Accepted Answer

A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY 
A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY

Question 6

A select query can be used to develop summary calculations, such as the sum of the values in a field.

Accepted Answer

A) True 
 B)False

Question 7

An SQL statement determines how the tables are joined after the ____ keyword

Accepted Answer

A)  SELECT 
B)  RELATE 
C)  FROM 
D)  ORDER BY 
A)  SELECT 
B)  RELATE 
C)  FROM 
D)  ORDER BY

Question 8

In the accompanying figure, 1 refers to a ____.

Accepted Answer

A)  function 
B)  operator 
C)  expression 
D)  calculated field name 
A)  function 
B)  operator 
C)  expression 
D)  calculated field name

Question 9

When you create a summary query, which row is added to the query design grid?

Accepted Answer

A)  Criteria 
B)  Table 
C)  Field 
D)  Total 
A)  Criteria 
B)  Table 
C)  Field 
D)  Total

Question 10

When a query is saved, it saves VBA statements.  _________________________

Accepted Answer

A) True 
 B)False

Question 11

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 12

You can specify more than one sort field in Query Design View.

Accepted Answer

A) True 
 B)False

Question 13

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

Accepted Answer

In the query design grid, ente

Question 14

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 15

In the accompanying figure, item 1 refers to a(n) ____.

Accepted Answer

A)  table name 
B)  field list 
C)  query design grid 
D)  one-to-many join line 
A)  table name 
B)  field list 
C)  query design grid 
D)  one-to-many join line

Question 16

Discuss the use of the * wildcard character in query criteria.

Accepted Answer

The wildcard character * is us

Question 17

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Accepted Answer

A) True 
 B)False

Question 18

In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

Accepted Answer

A) True 
 B)False

Question 19

The > operator means less than in a query. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The ____ function returns the number of characters in a field.

Accepted Answer

The answer of The ____ function returns the number of...

In the accompanying figure, what is the primary key field of the Tours table?

In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Which function should you use to calculate today's current date?

A select query can be used to develop summary calculations, such as the sum of the values in a field.

An SQL statement determines how the tables are joined after the ____ keyword

In the accompanying figure, 1 refers to a ____.

When you create a summary query, which row is added to the query design grid?

When a query is saved, it saves VBA statements. _________________________

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

You can specify more than one sort field in Query Design View.

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

Access helps you with criteria syntax in the query design grid.

In the accompanying figure, item 1 refers to a(n) ____.

Discuss the use of the * wildcard character in query criteria.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

The > operator means less than in a query. _________________________

The ____ function returns the number of characters in a field.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 6: Improving Queries

In the accompanying figure, what is the primary key field of the Tours table?

In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Which function should you use to calculate today's current date?

A select query can be used to develop summary calculations, such as the sum of the values in a field.

An SQL statement determines how the tables are joined after the ____ keyword

In the accompanying figure, 1 refers to a ____.

When you create a summary query, which row is added to the query design grid?

When a query is saved, it saves VBA statements. _________________________

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

You can specify more than one sort field in Query Design View.

You want to search for all last names beginning with the letter M in the query shown in the accompanying figure. Describe how to do this.

Access helps you with criteria syntax in the query design grid.

In the accompanying figure, item 1 refers to a(n) ____.

Discuss the use of the * wildcard character in query criteria.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

The > operator means less than in a query. _________________________

The ____ function returns the number of characters in a field.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters