Question 1

Access is a ____.

Accepted Answer

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

Question 2

Form view displays a single record at a time.

Accepted Answer

A) True 
 B)False

Question 3

____________________ refers to the arrangement of data into tables and fields.

Accepted Answer

The answer of ____________________ refers to the arrangement of data...

Question 4

To move a field, click the row selector for the field to be moved to select the field, and then drag the field to the desired position.

Accepted Answer

A) True 
 B)False

Question 5

____________________ is the storing of a piece of data in more than one place.

Accepted Answer

The answer of ____________________ is the storing of a piece...

Question 6

In the accompanying figure, the small box or bar to left of each field is called the ____.

Accepted Answer

A)  row selector 
B)  field selector 
C)  field bar 
D)  current field bar

Question 7

In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

Accepted Answer

The answer of  
 In the accompanying figure, the...

Question 8

To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

Accepted Answer

A)  Erase 
B)  Trash 
C)  Remove 
D)  Delete

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

Modified Multiple Choice Table names cannot contain _____.

Accepted Answer

A)  square brackets [ ] 
B)  periods (.) 
C)  hyphens (-) 
D)  accent graves (')

Question 13

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .

Accepted Answer

A)  container 
B)  repository 
C)  placeholder 
D)  database

Question 14

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

Accepted Answer

A)  New 
B)  Create 
C)  Add 
D)  Insert Table

Question 15

Match between columns Premises: Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 25
5.

Accepted Answer

The Answer of Report view and Memo and AutoNumber and is...

Question 16

In the accompanying figure, analyst names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

Accepted Answer

The answer of  
 In the accompanying figure, analyst...

Question 17

As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

Accepted Answer

A) True 
 B)False

Question 18

Modified Multiple Choice File names cannot contain a(n) ____.

Accepted Answer

A)  question mark (?) 
B)  colon (:) 
C)  space 
D)  underscore (_)

Question 19

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

Accepted Answer

A)  Picture 
B)  Image 
C)  OLE Object 
D)  Bitmap

Question 20

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

Accepted Answer

A)  Insert Field 
B)  Insert Column 
C)  Add Field 
D)  Add Column

Exam 2: Databases and Database Objects: an Introduction

Access is a ____.

Form view displays a single record at a time.

____________________ refers to the arrangement of data into tables and fields.

To move a field, click the row selector for the field to be moved to select the field, and then drag the field to the desired position.

____________________ is the storing of a piece of data in more than one place.

In the accompanying figure, the small box or bar to left of each field is called the ____.

In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

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

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

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

Modified Multiple Choice Table names cannot contain _____.

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

Identify the letter of the choice that best matches the phrase or definition.

In the accompanying figure, analyst names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

Modified Multiple Choice File names cannot contain a(n) ____.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

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