Question 1

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

Accepted Answer

A) True 
 B)False  True

Question 2

A query datasheet is sometimes called a ____ of the data.

Accepted Answer

A)  logical view 
B)  duplicate copy 
C)  table simulator 
D)  warehouse 
A)  logical view 
B)  duplicate copy 
C)  table simulator 
D)  warehouse A

Question 3

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Accepted Answer

A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced 
A)  Comparative 
B)  Selection 
C)  Comparison 
D)  Advanced B

Question 4

Match between columns
                        Premises: Used to search for a pattern
Creates a temporary subset of records
Criterion that finds all records where no entry has been made in the field
Creates a datasheet of selected fields and records from one or more tables
Limiting conditions used to narrow the number of records on a datasheet
The lower pane in Query Design View
Putting records in ascending or descending order based on a field's values
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

Accepted Answer

The Answer of sorting and criteria and datasheet and query is...

Question 5

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li

Question 6

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

Accepted Answer

A)  query 
B)  objectivity 
C)  connection 
D)  link 
A)  query 
B)  objectivity 
C)  connection 
D)  link

Question 7

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

Accepted Answer

A) True 
 B)False

Question 8

By default, the printout of a datasheet contains the object name and current date in the footer .

Accepted Answer

A) True 
 B)False

Question 9

Query Design View presents the fields you can use for a query in small windows called field ____.

Accepted Answer

A)  glossaries 
B)  lists 
C)  links 
D)  catalogs 
A)  glossaries 
B)  lists 
C)  links 
D)  catalogs

Question 10

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Accepted Answer

The answer of One way to create a new query...

Question 11

A(n) ____________________ answers a question about the information in the database.

Accepted Answer

The answer of A(n) ____________________ answers a question about the...

Question 12

In the accompanying figure, StateName and Price are ____ names.

Accepted Answer

A)  table 
B)  report 
C)  field 
D)  query 
A)  table 
B)  report 
C)  field 
D)  query

Question 13

Which of the following comparison operators means "less than or equal to"?

Accepted Answer

A) > B) >= C) < D) <= A) > B) >= C) < D) <=

Question 14

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Accepted Answer

The answer of Filter By ____________________ is a fast and...

Question 15

To find numbers greater than or equal to 500, use which comparison operator?

Accepted Answer

A) > 
D)  >= 
A) > 
D)  >=

Question 16

____________________ are limiting conditions you set in the query design grid.

Accepted Answer

The answer of ____________________ are limiting conditions you set in...

Question 17

When you double-click a field in a field list in Query Design View, it is ____.

Accepted Answer

A)  deleted from the query 
B)  added to the next available position in the query design grid 
C)  used as the first sort order 
D)  set as the primary key field 
A)  deleted from the query 
B)  added to the next available position in the query design grid 
C)  used as the first sort order 
D)  set as the primary key field

Question 18

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order

Question 19

SQL stands for ____.

Accepted Answer

A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language 
A)  Structured Query Lingo 
B)  Standard Query Lingo 
C)  Standard Query Language 
D)  Structured Query Language

Question 20

Use the ____ command to save the current object with a new name.

Accepted Answer

A)  Datasheet 
B)  View 
C)  Save As 
D)  Save 
A)  Datasheet 
B)  View 
C)  Save As 
D)  Save

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

A query datasheet is sometimes called a ____ of the data.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Discuss adding or deleting a table in a query.

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

By default, the printout of a datasheet contains the object name and current date in the footer .

Query Design View presents the fields you can use for a query in small windows called field ____.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

A(n) ____________________ answers a question about the information in the database.

In the accompanying figure, StateName and Price are ____ names.

Which of the following comparison operators means "less than or equal to"?

Filter By ____________________ is a fast and easy way to filter records for an exact match.

To find numbers greater than or equal to 500, use which comparison operator?

____________________ are limiting conditions you set in the query design grid.

When you double-click a field in a field list in Query Design View, it is ____.

Explain the difference between AND and OR criteria.

SQL stands for ____.

Use the ____ command to save the current object with a new name.

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 2: Building and Using Queries

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

A query datasheet is sometimes called a ____ of the data.

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Discuss adding or deleting a table in a query.

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

By default, the printout of a datasheet contains the object name and current date in the footer .

Query Design View presents the fields you can use for a query in small windows called field ____.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

A(n) ____________________ answers a question about the information in the database.

In the accompanying figure, StateName and Price are ____ names.

Which of the following comparison operators means "less than or equal to"?

Filter By ____________________ is a fast and easy way to filter records for an exact match.

To find numbers greater than or equal to 500, use which comparison operator?

____________________ are limiting conditions you set in the query design grid.

When you double-click a field in a field list in Query Design View, it is ____.

Explain the difference between AND and OR criteria.

SQL stands for ____.

Use the ____ command to save the current object with a new name.

Getting Started With Access 2013

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters