Question 1

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

Accepted Answer

A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000 
A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000 B

Question 2

Match between columns
                        Premises: A mathematical operator for division.

Accepted Answer

The Answer of FIRST and / and OR criterion and is...

Question 3

To save a query, tap or click the Save button on the ____.

Accepted Answer

A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon 
A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon B

Question 4

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

Accepted Answer

A)  S? 
B)  S* 
C)  S# 
D)  S& 
A)  S? 
B)  S* 
C)  S# 
D)  S&

Question 5

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

Accepted Answer

The answer of To combine criteria with ____________________, each criterion...

Question 6

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Accepted Answer

A)  Sort 
B)  Show 
C)  or 
D)  Criteria 
A)  Sort 
B)  Show 
C)  or 
D)  Criteria

Question 7

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

Accepted Answer

A) True 
 B)False

Question 8

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

Accepted Answer

A) True 
 B)False

Question 9

The question mark (?) wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

Question 10

To create a crosstab, click the ____ button on the CREATE tab.

Accepted Answer

A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart 
A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart

Question 11

Match between columns
                        Premises: An aggregate function.

Accepted Answer

The Answer of FIRST and OR criterion and NOT and is...

Question 12

The type of join that finds records from both tables that have identical values in matching fields is called a(n) ____________________ join.

Accepted Answer

The answer of The type of join that finds records...

Question 13

To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View 
A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View

Question 14

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

Accepted Answer

A) True 
 B)False

Question 15

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

Accepted Answer

A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format 
A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format

Question 16

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

Accepted Answer

A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes '' 
A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes ''

Question 17

When you create a query, you should follow some general guidelines for query design.What are these six guidelines?

Accepted Answer

1. Identify the fields. 
2. Identify res

Question 18

In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.

Accepted Answer

A)  infinity 
B)  join 
C)  connector 
D)  inner 
A)  infinity 
B)  join 
C)  connector 
D)  inner

Question 19

In ____________________ files, the width of any field is the same on every record.

Accepted Answer

The answer of In ____________________ files, the width of any...

Question 20

Explain the difference between an inner join and an outer join.

Accepted Answer

An inner join is a join that finds recor

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

To save a query, tap or click the Save button on the ____.

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

The question mark (?) wildcard represents any collection of characters.

To create a crosstab, click the ____ button on the CREATE tab.

The type of join that finds records from both tables that have identical values in matching fields is called a(n) ____________________ join.

To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

When you create a query, you should follow some general guidelines for query design.What are these six guidelines?

In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.

In ____________________ files, the width of any field is the same on every record.

Explain the difference between an inner join and an outer join.

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 8: Access: Querying a Database

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

To save a query, tap or click the Save button on the ____.

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.

The question mark (?) wildcard represents any collection of characters.

To create a crosstab, click the ____ button on the CREATE tab.

The type of join that finds records from both tables that have identical values in matching fields is called a(n) ____________________ join.

To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

When you create a query, you should follow some general guidelines for query design.What are these six guidelines?

In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.

In ____________________ files, the width of any field is the same on every record.

Explain the difference between an inner join and an outer join.

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters