Question 1

A saved database is referred to as a ____.

Accepted Answer

A)  file
B)  databook
C)  DBMS
D)  templateE) A) and B)
F) None of the above

Question 2

One way to undo changes to a field is to click the Undo button on the Table Tools tab.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A)  Unlimited
B)  Variable
C)  Memo
D)  CharacterE) A) and D)
F) C) and D)

Question 4

In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

Accepted Answer

A)  subtype
B)  tiered
C)  contextual
D)  sublevelE) B) and C)
F) A) and C)

Question 5

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: Appears automatically based on tasks you perform such as changing the appearance of text in a database object.

Accepted Answer

The Answer of key Tip Badge and shortcut menu and is...

Question 7

To quit Access, click the ____ button on the right side of the Access title bar.

Accepted Answer

A)  Quit
B)  End
C)  Quit Access
D)  CloseE) B) and D)
F) C) and D)

Question 8

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False  True

Question 10

Grouping means creating separate collections of records sharing some common characteristic.

Accepted Answer

A) True 
 B)False  True

Question 11

When you maximize a window, the Maximize button changes to a(n) ____ button.

Accepted Answer

A)  Minimize
B)  Return
C)  Original
D)  Restore DownE) A) and B)
F) All of the above

Question 12

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)  BitmapE) B) and D)
F) A) and D) C

Question 13

Figure 1-3 In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

Accepted Answer

The answer of  Figure 1-3 In the accompanying figure,...

Question 14

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

Accepted Answer

A)  Table Design
B)  Design View
C)  Structure View
D)  Layout ViewE) B) and D)
F) All of the above

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

Accepted Answer

A)  Rename Field
B)  Rename Column
C)  Change Field
D)  Change ColumnE) A) and B)
F) None of the above

Question 17

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

Accepted Answer

A)  Alpha
B)  Text
C)  Normal
D)  LookupE) None of the above
F) All of the above

Question 18

A folder is a specific location on a storage medium.

Accepted Answer

A) True 
 B)False

Question 19

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Accepted Answer

A) True 
 B)False

Question 20

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

Accepted Answer

A)  Byte
B)  Smallint
C)  Least
D)  IntegerE) None of the above
F) C) and D)

Exam 3: Access: Creating and Using a Database

A saved database is referred to as a ____.

Correct Answer
verified

One way to undo changes to a field is to click the Undo button on the Table Tools tab.

Correct Answer
verified

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

Correct Answer
verified

In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

Correct Answer
verified

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

Correct Answer
verified

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

To quit Access, click the ____ button on the right side of the Access title bar.

Correct Answer
verified

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

Correct Answer
verified

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

Correct Answer
verified
True

Grouping means creating separate collections of records sharing some common characteristic.

Correct Answer
verified
True

When you maximize a window, the Maximize button changes to a(n) ____ button.

Correct Answer
verified

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

Correct Answer
verified
C

Figure 1-3 In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

Correct Answer
verified

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

Correct Answer
verified

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

Correct Answer
verified

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

Correct Answer
verified

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

Correct Answer
verified

A folder is a specific location on a storage medium.

Correct Answer
verified

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Correct Answer
verified

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

Correct Answer
verified

Exam 3: Access: Creating and Using a Database

A saved database is referred to as a ____.

Correct AnswerverifiedShow Answer

One way to undo changes to a field is to click the Undo button on the Table Tools tab.

Correct AnswerverifiedShow Answer

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

Correct AnswerverifiedShow Answer

In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

Correct AnswerverifiedShow Answer

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

Correct AnswerverifiedShow Answer

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

To quit Access, click the ____ button on the right side of the Access title bar.

Correct AnswerverifiedShow Answer

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

Grouping means creating separate collections of records sharing some common characteristic.

Correct AnswerverifiedTrue

When you maximize a window, the Maximize button changes to a(n) ____ button.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

Figure 1-3 In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

Correct AnswerverifiedShow Answer

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A folder is a specific location on a storage medium.

Correct AnswerverifiedShow Answer

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Correct AnswerverifiedShow Answer

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified