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 31

Multiple Choice

Review LaterAdd Note

Review Later

In Access, table and field names can be up to ____ characters in length.

A) 256
B) 128
C) 64
D) 32

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

A field whose data type is ____ can store text that can be used as a hyperlink address.

A) URL
B) Web
C) Placeholder
D) Hyperlink

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Landscape orientation means the printout is across the length (height) of the page.

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

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

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

Access is a ____.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) Which field in the Employee table should be the primary key and why?

A hard copy or ____________________ is information that exists on a physical medium such as paper.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s) .

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________

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

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.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

When Access first creates a database, it automatically creates a table.

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

Which field in the Project table should be the primary key and why?