Question 1

Which function should you use to calculate the monthly payment on a loan?

Accepted Answer

A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE 
A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE A

Question 2

-In the accompanying figure,fields from how many tables will display on the datasheet?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4 C

Question 3

A(n)____ query is used to calculate statistics about a group of records.

Accepted Answer

summary

Question 4

-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 5

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,enter

Question 6

-An SQL statement determines how the resulting records are sorted after the ____ keyword.

Accepted Answer

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

Question 7

The > operator means less than in a query._________________________

Accepted Answer

A) True 
 B)False

Question 8

A query can display fields from one or more tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  field list 
B)  one-to-many link line 
C)  query design grid 
D)  Show Table window 
A)  field list 
B)  one-to-many link line 
C)  query design grid 
D)  Show Table window

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 12

The data displayed in a query is sometimes called a(n)____ view of the data.

Accepted Answer

The answer of The data displayed in a query is...

Question 13

Which arithmetic operator signifies division?

Accepted Answer

A)  ^ 
B)  * 
C)  / 
D)  \ 
A)  ^ 
B)  * 
C)  / 
D)  \

Question 14

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 15

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

Accepted Answer

A)  Common 
B)  Select 
C)  Linking 
D)  Web 
A)  Common 
B)  Select 
C)  Linking 
D)  Web

Question 16

-How many calculated fields are shown in the accompanying figure?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 17

In Query Design View,you can drag the edge of a(n)field list to resize it._________________________

Accepted Answer

A) True 
 B)False

Question 18

-In the accompanying figure,the criteria in the TourStartDate column would be considered OR criteria.

Accepted Answer

A) True 
 B)False

Question 19

-An SQL statement determines what fields are selected after the ____ keyword.

Accepted Answer

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

Question 20

-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

Which function should you use to calculate the monthly payment on a loan?

-In the accompanying figure,fields from how many tables will display on the datasheet?

A(n)____ query is used to calculate statistics about a group of records.

-In the accompanying figure,1 refers to a ____.

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.

-An SQL statement determines how the resulting records are sorted after the ____ keyword.

The > operator means less than in a query._________________________

A query can display fields from one or more tables in a relational database.

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

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

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

The data displayed in a query is sometimes called a(n)____ view of the data.

Which arithmetic operator signifies division?

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.

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

-How many calculated fields are shown in the accompanying figure?

In Query Design View,you can drag the edge of a(n)field list to resize it._________________________

-In the accompanying figure,the criteria in the TourStartDate column would be considered OR criteria.

-An SQL statement determines what fields are selected after the ____ keyword.

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

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters

Exam 17: Access 2013 : Improving Queries

Which function should you use to calculate the monthly payment on a loan?

-In the accompanying figure,fields from how many tables will display on the datasheet?

A(n)____ query is used to calculate statistics about a group of records.

-In the accompanying figure,1 refers to a ____.

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.

-An SQL statement determines how the resulting records are sorted after the ____ keyword.

The > operator means less than in a query._________________________

A query can display fields from one or more tables in a relational database.

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

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

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

The data displayed in a query is sometimes called a(n)____ view of the data.

Which arithmetic operator signifies division?

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.

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

-How many calculated fields are shown in the accompanying figure?

In Query Design View,you can drag the edge of a(n)field list to resize it._________________________

-In the accompanying figure,the criteria in the TourStartDate column would be considered OR criteria.

-An SQL statement determines what fields are selected after the ____ keyword.

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

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters