Question 1

Which of the following is used to view and print the data in a database?

Accepted Answer

A)   report
B)   form
C)   query
D)   tableE) B) and D)
F) A) and B)

Question 2

Which of the following is used to store data records?

Accepted Answer

A)   report
B)   form
C)   query
D)   tableE) C) and D)
F) B) and D)

Question 3

Which of the following is an organized collection of integrated and related tables?

Accepted Answer

A)   hierarchy of data
B)   database
C)   database management system
D)   Entity-Relationship DiagramE) A) and B)
F) All of the above

Question 4

Which of the following data types is used for storing text longer than 255 characters?

Accepted Answer

A)   Short Text
B)   Long Text
C)   Number
D)   CurrencyE) None of the above
F) A) and C)

Question 5

Each field in a table must have a unique name.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is the default name that Access assigns to new blank tables?

Accepted Answer

A)   Table01
B)   Table1
C)   Datasheet01
D)   Datasheet1E) A) and C)
F) B) and C)

Question 7

It is possible to change a limited number of field properties in Datasheet view.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following data types is used to attach pictures,images,and Office files?

Accepted Answer

A)   Hyperlink
B)   Attachment
C)   Calculated
D)   Lookup WizardE) B) and D)
F) B) and C)

Question 9

If you open a table with a previously saved sort,clicking Remove Sort on the Home tab removes the sort.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is a field that contains a unique value for each record?

Accepted Answer

A)   primary key
B)   secondary key
C)   index
D)   record selectorE) All of the above
F) A) and B)

Question 11

When would you want to use Access's Search,Sort,and Filter functions?

Accepted Answer

When the number of records in a database...

Question 12

Which of the following tabs provides information about your database and additional functions to help you manage the database?

Accepted Answer

A)   File
B)   Create
C)   Database Tools
D)   External DataE) B) and C)
F) A) and B)

Question 13

Which of the following data types would you use to display a spreadsheet object in a field?

Accepted Answer

A)   Currency
B)   AutoNumber
C)   OLE Object
D)   HyperlinkE) B) and D)
F) A) and B)

Question 14

To best organize a database,what must you understand?

Accepted Answer

A)   hierarchy of data
B)   database
C)   database management system
D)   Entity-Relationship DiagramE) All of the above
F) A) and C)

Question 15

Which of the following should you use if you are going to make several changes at once to the datasheet layout?

Accepted Answer

A)   Navigation pane
B)   Navigation bar
C)   Datasheet Formatting dialog box
D)   PropertiesE) All of the above
F) A) and C)

Question 16

To add a new field to a table,on what must you click in the first cell?

Accepted Answer

A)   Record Selector
B)   form
C)   Append Row
D)   datasheetE) B) and D)
F) A) and B)

Question 17

Adding a filter to a second field is a(n) _____________ condition.

Accepted Answer

A)   NOT
B)   OR
C)   AND
D)   BUTE) All of the above
F) None of the above

Question 18

Access automatically assigns a generic file name to your database,such as Database1.accdb.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following should you do to the database file when you are finished working on it?

Accepted Answer

A)   save
B)   back up
C)   close
D)   renameE) A) and D)
F) C) and D)

Question 20

The Datasheet Formatting dialog box enables you to make several changes at once to the layout of a datasheet.

Accepted Answer

A) True 
 B)False

Exam 10: Customizing Access and Using Skydrive and Office Web Apps

Which of the following is used to view and print the data in a database?

Correct AnswerverifiedShow Answer

To add a new field to a table,on what must you click in the first cell?

Correct AnswerverifiedShow Answer

To best organize a database,what must you understand?

Correct AnswerverifiedShow Answer

Access automatically assigns a generic file name to your database,such as Database1.accdb.

Correct AnswerverifiedShow Answer

Which of the following data types is used to attach pictures,images,and Office files?

Correct AnswerverifiedShow Answer

Which of the following is an organized collection of integrated and related tables?

Correct AnswerverifiedShow Answer

Which of the following data types would you use to display a spreadsheet object in a field?

Correct AnswerverifiedShow Answer

Which of the following should you use if you are going to make several changes at once to the datasheet layout?

Correct AnswerverifiedShow Answer

Which of the following data types is used for storing text longer than 255 characters?

Correct AnswerverifiedShow Answer

The Datasheet Formatting dialog box enables you to make several changes at once to the layout of a datasheet.

Correct AnswerverifiedShow Answer

It is possible to change a limited number of field properties in Datasheet view.

Correct AnswerverifiedShow Answer

Each field in a table must have a unique name.

Correct AnswerverifiedShow Answer

Which of the following should you do to the database file when you are finished working on it?

Correct AnswerverifiedShow Answer

Adding a filter to a second field is a(n) _____________ condition.

Correct AnswerverifiedShow Answer

Which of the following tabs provides information about your database and additional functions to help you manage the database?

Correct AnswerverifiedShow Answer

Which of the following is a field that contains a unique value for each record?

Correct AnswerverifiedShow Answer

When would you want to use Access's Search,Sort,and Filter functions?

Correct AnswerverifiedWhen the number of records in a database...View AnswerShow Answer

Which of the following is the default name that Access assigns to new blank tables?

Correct AnswerverifiedShow Answer

If you open a table with a previously saved sort,clicking Remove Sort on the Home tab removes the sort.

Correct AnswerverifiedShow Answer

Which of the following is used to store data records?

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When the number of records in a database...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified