FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Access 1 Databases and Database Objects: an Introduction

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The rows in the tables are called ____________________.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

Layout view shows a report on the screen and allows the user to make changes to the report.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

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 print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

A(n) ____ contains information about a given person, product, or event.

A unique identifier is also called a primary key.

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

A field whose data type is ____ can contain any characters.

The determination of database requirements is part of a process known as ____________________.

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

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

In Access, the columns in a table are called records.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

To open the Navigation Pane, tap or click the ____ Button.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.