FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Access_Module_1

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Essay

Review LaterAdd Note

Review Later

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

A) Field Size
B) Format
C) Caption
D) Description

E) None of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The Navigation Pane contains a list of all the objects in the database.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

One way to undo changes to a field is to click the Undo button on the status bar.

The Currency data type is used for fields that contain only monetary data.

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________

File names cannot contain a(n) ____.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

____________________ refers to the process of determining the tables and fields that make up the database.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. -What data type should Joe use for the Completion Date field?

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.