Question 1

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Accepted Answer

A) True 
 B)False

Question 2

You can include ____ in calculations to indicate which calculation should be done first.

Accepted Answer

A)  curly braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  slashes // 
A)  curly braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  slashes //

Question 3

Critical Thinking Questions Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013.The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

Accepted Answer

Click the Start Date field in the design

Question 4

To find all customers whose names begin with S, enter S? in the Criteria row of the design grid.

Accepted Answer

A) True 
 B)False

Question 5

Grouping means creating groups of records that share some common characteristic.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: Either individual criterion must be true in order for the compound criterion to be true.

Accepted Answer

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

Question 7

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

Accepted Answer

A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 8

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

Accepted Answer

A) True 
 B)False

Question 9

To show the Navigation Pane if it is hidden, click the ____ Button.

Accepted Answer

A)  Show 
B)  Shutter Bar Open/Close 
C)  Restore 
D)  Show/Hide 
A)  Show 
B)  Shutter Bar Open/Close 
C)  Restore 
D)  Show/Hide

Question 10

To order the records in the answer to a query in a particular way, you ____ the records.

Accepted Answer

A)  index 
B)  sort 
C)  arrange 
D)  list 
A)  index 
B)  sort 
C)  arrange 
D)  list

Question 11

A property sheet is a window containing the various properties of the object.

Accepted Answer

A) True 
 B)False

Question 12

The ____________________ is an Access tool that helps you create complex expressions.

Accepted Answer

The answer of The ____________________ is an Access tool that...

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

You can include ____ in calculations to indicate which calculation should be done first.

Critical Thinking Questions Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013.The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

To find all customers whose names begin with S, enter S? in the Criteria row of the design grid.

Grouping means creating groups of records that share some common characteristic.

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

To show the Navigation Pane if it is hidden, click the ____ Button.

To order the records in the answer to a query in a particular way, you ____ the records.

A property sheet is a window containing the various properties of the object.

The ____________________ is an Access tool that helps you create complex expressions.

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

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

You can include ____ in calculations to indicate which calculation should be done first.

Critical Thinking Questions Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013.The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

To find all customers whose names begin with S, enter S? in the Criteria row of the design grid.

Grouping means creating groups of records that share some common characteristic.

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

To show the Navigation Pane if it is hidden, click the ____ Button.

To order the records in the answer to a query in a particular way, you ____ the records.

A property sheet is a window containing the various properties of the object.

The ____________________ is an Access tool that helps you create complex expressions.

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