FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Access

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 321

Multiple Choice

Review LaterAdd Note

Review Later

When does Access save changes you make to a record?

A) when you click the Save button
B) when you close the table
C) when you move to a different record
D) when you select the record

Correct Answer

verified

Show Answer

Question 322

Multiple Choice

Review LaterAdd Note

Review Later

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A) Input Mask
B) Format
C) Visual Guide
D) Caption

Correct Answer

verified

Show Answer

Question 323

Multiple Choice

Review LaterAdd Note

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

Which of the following are action queries? Select all the options that apply.

How can you identify a linked table in a database?

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

Where do you set the Allow Multiple Values property of a field in Table Design view?

Each item on a form is called a _____.

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

Which of the following are Access data types? Select all the options that apply.

You set the opening Display Form for a database using the Access Preferences dialog box.

When you export a query to use in Word, Access creates a Rich Text Format (RTF) file.

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?

In Table Design view, "State must be AZ or CO" is an example of integrity text.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

In which object can you rename a field?

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

A command button in a report typically appears in the _____ section.

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

Use the Move up and Move down buttons to move macro actions in Macro Design View.