Question 1

An alternative to add fields to the design grid is to ________ the field to the column.

Accepted Answer

A)  double-click 
B)  drag 
C)  click 
D)  double-tap 
A)  double-click 
B)  drag 
C)  click 
D)  double-tap

Question 2

It is NOT best practice to run a query to test it before adding criteria.

Accepted Answer

A) True 
 B)False

Question 3

If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.

Accepted Answer

A) True 
 B)False

Question 4

Tables can be added to the query design workspace using the Show Table dialog box.

Accepted Answer

A) True 
 B)False

Question 5

The ________ logical operator tests whether a field is empty.

Accepted Answer

A)  Is Null 
B)  Like 
C)  Is Not Null 
D)  True 
A)  Is Null 
B)  Like 
C)  Is Not Null 
D)  True

Question 6

A query's ________ is used to determine how the query should be grouped and summarized.

Accepted Answer

A)  Total row 
B)  Show Table dialog box 
C)  Design view 
D)  Criteria row 
A)  Total row 
B)  Show Table dialog box 
C)  Design view 
D)  Criteria row

Question 7

________ display in the query datasheet header row.

Accepted Answer

A)  Captions 
B)  Aliases 
C)  Titles 
D)  Legends 
A)  Captions 
B)  Aliases 
C)  Titles 
D)  Legends

Question 8

A column in a table or query that derives its value from other fields is called a(n) ________ field.

Accepted Answer

The answer of A column in a table or query...

Question 9

Which of the following is the correct order of the steps for creating a query in Design view?

Accepted Answer

A)  Add the tables, add the fields, add the criteria, and run the query. 
B)  Add the tables, add the criteria, add the fields, and run the query. 
C)  Add the criteria, add the fields, add the tables, and run the query. 
D)  Add the fields, add the tables, add the criteria, and run the query. 
A)  Add the tables, add the fields, add the criteria, and run the query. 
B)  Add the tables, add the criteria, add the fields, and run the query. 
C)  Add the criteria, add the fields, add the tables, and run the query. 
D)  Add the fields, add the tables, add the criteria, and run the query.

Question 10

Between…And finds all numbers or dates between and including two values.

Accepted Answer

A) True 
 B)False

Question 11

Criteria that contain text must be surrounded by ________.

Accepted Answer

A)  * * asterisks 
B)  " " quotation marks 
C)  # # number signs 
D)  [ ] brackets 
A)  * * asterisks 
B)  " " quotation marks 
C)  # # number signs 
D)  [ ] brackets

Question 12

The ________ operator designates which query column contains the group of values to summarize as a single record.

Accepted Answer

A)  Group By 
B)  Greater than 
C)  And 
D)  Null 
A)  Group By 
B)  Greater than 
C)  And 
D)  Null

Question 13

The ________ Wizard quickly adds fields to a new query.

Accepted Answer

A)  Normal Query 
B)  Search Query 
C)  Filter Query 
D)  Simple Query 
A)  Normal Query 
B)  Search Query 
C)  Filter Query 
D)  Simple Query

Question 14

Match each definition with the appropriate term.
A) Between #1/1/16# And #1/6/16#
B) Is Not Null
C) 100
G) "learn"
H) >#1/1/16#
I) Is Null
J) =100
96) Cell is not empty
97) Equals the word learn
98) Does not equal 100
99) Is after January 1, 2016
100) Is between January 1 and 6, 2016

Accepted Answer

Answers:

Question 15

When creating a query, placing two criteria in the same row indicates that the ________ logical operator applies.

Accepted Answer

A)  Or 
B)  Null 
C)  And 
D)  Not Null 
A)  Or 
B)  Null 
C)  And 
D)  Not Null

Question 16

When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.

Accepted Answer

A) True 
 B)False

Question 17

When two criteria are placed in different rows in the design grid, the ________ logical operator applies.

Accepted Answer

A)  And 
B)  Null 
C)  Or 
D)  Not Null 
A)  And 
B)  Null 
C)  Or 
D)  Not Null

Question 18

The ________ operator calculates the number of records in each group.

Accepted Answer

The answer of The ________ operator calculates the number of...

Question 19

When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.

Accepted Answer

A) True 
 B)False

Question 20

If you widen a query column in the design grid, the column will return to its original width when the query is closed.

Accepted Answer

A) True 
 B)False

An alternative to add fields to the design grid is to ________ the field to the column.

It is NOT best practice to run a query to test it before adding criteria.

If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.

Tables can be added to the query design workspace using the Show Table dialog box.

The ________ logical operator tests whether a field is empty.

A query's ________ is used to determine how the query should be grouped and summarized.

________ display in the query datasheet header row.

A column in a table or query that derives its value from other fields is called a(n) ________ field.

Which of the following is the correct order of the steps for creating a query in Design view?

Between…And finds all numbers or dates between and including two values.

Criteria that contain text must be surrounded by ________.

The ________ operator designates which query column contains the group of values to summarize as a single record.

The ________ Wizard quickly adds fields to a new query.

When creating a query, placing two criteria in the same row indicates that the ________ logical operator applies.

When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.

When two criteria are placed in different rows in the design grid, the ________ logical operator applies.

The ________ operator calculates the number of records in each group.

When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.

If you widen a query column in the design grid, the column will return to its original width when the query is closed.

Create Database Tables

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters

Exam 2: Create Select Queries

An alternative to add fields to the design grid is to ________ the field to the column.

It is NOT best practice to run a query to test it before adding criteria.

If you do not want a column to display in the datasheet, uncheck the Show box in the Query design grid.

Tables can be added to the query design workspace using the Show Table dialog box.

The ________ logical operator tests whether a field is empty.

A query's ________ is used to determine how the query should be grouped and summarized.

________ display in the query datasheet header row.

A column in a table or query that derives its value from other fields is called a(n) ________ field.

Which of the following is the correct order of the steps for creating a query in Design view?

Between…And finds all numbers or dates between and including two values.

Criteria that contain text must be surrounded by ________.

The ________ operator designates which query column contains the group of values to summarize as a single record.

The ________ Wizard quickly adds fields to a new query.

When creating a query, placing two criteria in the same row indicates that the ________ logical operator applies.

When using the Simple Query Wizard, you CANNOT include fields from related tables-only fields from the active table.

When two criteria are placed in different rows in the design grid, the ________ logical operator applies.

The ________ operator calculates the number of records in each group.

When you include the quotation marks around criteria, the AutoComplete and QuickInfo messages display.

If you widen a query column in the design grid, the column will return to its original width when the query is closed.

Create Database Tables

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Insert Summary Functions and Create Charts

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters