Question 1

After sorting fields in a table, you can remove a sort order setting by clicking the Remove Sort button in the Sort & Filter group.

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, item 3 points to the ____.

Accepted Answer

A)  Available Fields list 
B)  Properties list 
C)  fields used in the query 
D)  Tables/Queries list arrow 
A)  Available Fields list 
B)  Properties list 
C)  fields used in the query 
D)  Tables/Queries list arrow

Question 3

For greater flexibility and control, a filter is sometimes more helpful than a query.

Accepted Answer

A) True 
 B)False

Question 4

To perform a sort, you must first indicate the field on which you want Access to sort.

Accepted Answer

A) True 
 B)False

Question 5

You work at a retail store that uses a small database to track customers. Your supervisor asks you to perform a series of tasks with the database. The database contains one table with fields for Customer Name, City, and State. 
 Your supervisor wants a list of only those customers who live in the city of Bellview. How can you create this list?

Accepted Answer

Locate a record in the Custome

After sorting fields in a table, you can remove a sort order setting by clicking the Remove Sort button in the Sort & Filter group.

In the accompanying figure, item 3 points to the ____.

For greater flexibility and control, a filter is sometimes more helpful than a query.

To perform a sort, you must first indicate the field on which you want Access to sort.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Using Complex Formulas, Functions, and Tables

Working With Charts

Creating a Database

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters

Exam 11: Working With Data

After sorting fields in a table, you can remove a sort order setting by clicking the Remove Sort button in the Sort & Filter group.

In the accompanying figure, item 3 points to the ____.

For greater flexibility and control, a filter is sometimes more helpful than a query.

To perform a sort, you must first indicate the field on which you want Access to sort.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Using Complex Formulas, Functions, and Tables

Working With Charts

Creating a Database

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters