Question 1

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.

Accepted Answer

A) True 
 B)False

Question 2

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.

Accepted Answer

A)   New Name
B)   Redefine
C)   Rename
D)   Save NameE) A) and B)
F) None of the above

Question 3

____________________ view has more functionality for creating a table than Datasheet view.

Accepted Answer

The answer of ____________________ view has more functionality for creating...

Question 4

Changing the column width in a datasheet changes the structure of a table.

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-View that shows a report as it will appear when printed.

Accepted Answer

A)  AutoNumber
B)  Layout view
C)  DBDL
D)  Report view
E)  Long TextF) CurrencyG) MetadataH) Print PreviewI) Short TextJ) status barK) F) and I)
L) B) and G)

Question 6

The rows in the tables are called ____________________.

Accepted Answer

The answer of The rows in the tables are called...

Question 7

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)   Illustration
B)   Image
C)   Bitmap
D)   OLE objectE) None of the above
F) A) and B)

Question 8

The ____________________ data type in Access is referred to as Money in SQL Server.

Accepted Answer

The answer of The ____________________ data type in Access is...

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Can include such information as the file's author,title,or subject.

Accepted Answer

A)  AutoNumber
B)  Layout view
C)  DBDL
D)  Report view
E)  Long TextF) CurrencyG) MetadataH) Print PreviewI) Short TextJ) status barK) B) and D)
L) G) and H)

Question 10

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

Accepted Answer

A)   Alpha
B)   Character
C)   Normal
D)   Short TextE) All of the above
F) A) and B)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Identify the letter of the choice that best matches the phrase or definition.
-Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Accepted Answer

A)  AutoNumber
B)  Layout view
C)  DBDL
D)  Report view
E)  Long TextF) CurrencyG) MetadataH) Print PreviewI) Short TextJ) status barK) A) and F)
L) A) and B)

Question 14

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

Accepted Answer

A)   CTRL+DELETE
B)   CTRL+Y
C)   DELETE
D)   CTRL+KE) B) and D)
F) C) and D)

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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?

Accepted Answer

Joe should use the D...

Question 17

To import data to a table,tap or click the ____ tab on the ribbon.

Accepted Answer

A)   DATABASE TOOLS
B)   FILE
C)   EXTERNAL DATA
D)   IMPORTE) B) and C)
F) All of the above

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

In Access,field names cannot contain digits.

Accepted Answer

A) True 
 B)False

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

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

Correct AnswerverifiedShow Answer

Changing the column width in a datasheet changes the structure of a table.

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 AnswerverifiedShow Answer

To import data to a table,tap or click the ____ tab on the ribbon.

Correct AnswerverifiedShow Answer

In Access,field names cannot contain digits.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report as it will appear when printed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ data type in Access is referred to as Money in SQL Server.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedJoe should use the D...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

____________________ view has more functionality for creating a table than Datasheet view.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -Can include such information as the file's author,title,or subject.

Correct AnswerverifiedShow Answer

The rows in the tables are called ____________________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Joe should use the D...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified