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

Access is a ____.

A) word processing software tool
B) file management system
C) workbook management system
D) database management system

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

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.

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

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

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

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

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

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

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

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

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?

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.

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.

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

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

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

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

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

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