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

Multiple Choice

Review LaterAdd Note

Review Later

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) Remove Field
B) Delete Field
C) Delete Column
D) Remove Column

E) C) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

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

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 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 ____.

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

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.

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 show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

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

File names cannot contain a(n) ____.

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.

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. ____________________

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.

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

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

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

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

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.