FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Introduction to Access

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

A) It depends on how many of the fields are blank.
B) 53
C) 106
D) It depends on how many of the fields contain exactly the same information.

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Reports can draw data from tables or queries.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Using the Back Up Database utility only saves the structure of the database, not the content.

Using Filter by Form enables you to filter on multiple criteria.

The ________ command helps you locate specific records.

Before you can password protect a database you must open it in ________ mode.

Backstage view gives you access to which command?

What are the two ways you can view a table?

A customer's cell phone would be an example of a ________.

What two tabs are unique to Access?

Creating a database from a template can help you get started more quickly.

DBMS stands for ________.

When you close a table after using a selection filter and then reopen it, what happens to the filter?

Tables, queries, forms, and reports are all considered to be ________.

You can only sort records by one field.

When you click the Enable Content warning, the database is now ________.

In datasheet view, what do the rows indicate?

Match the following with their description: I. <>, =., >, < II. AND, OR, NOT III. Contains "Bill" IV. Tabs Documents interface V. Oracle A. Could be used in a selection filter B. Objects open in their own area under the Ribbon. C. Comparison operators D. A more advanced DBMS E. Boolean operators

Which of the following is not a valid comparison operator?

When you enter items into a database, you are entering ________.