Question 1

What must you create for each of the different pieces of information you want to keep in your table?

Accepted Answer

A)   field
B)   record
C)   object
D)   queryE) None of the above
F) A) and B)

Question 2

How do you know how many tables you need or which fields belong in which tables? What techniques can you use?

Accepted Answer

There are several different formal techn...

Question 3

Design view allows you to enter,modify,delete,or view the data records.

Accepted Answer

A) True 
 B)False

Question 4

What symbol displays when Date and Currency values are too wide to fit in the column?

Accepted Answer

A)   dollar signs (  $) 
B)   asterisks (*****) 
C)   ampersands (@@@@@) 
D)   pound signs (#####)  E) A) and C)
F) A) and B)

Question 5

To initiate the automatic saving of data,what must be done to your table at least once?

Accepted Answer

A)   opened
B)   saved
C)   backed up
D)   renamedE) B) and D)
F) A) and B)

Question 6

It is important to save a database file before closing it.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is used to create an interface to view,add,update,and delete data?

Accepted Answer

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

Question 8

When a new table is created in Datasheet view,what field does Access automatically include?

Accepted Answer

A)   AUTO
B)   COUNTER
C)   ID
D)   FIELDE) All of the above
F) None of the above

Question 9

In Datasheet view,which of the following keys moves the pointer to the next field?

Accepted Answer

A)   Tab
B)   Shift
C)   Esc
D)   InsertE) None of the above
F) All of the above

Question 10

The Undo button _______________ be used to undo changes made to the datasheet layout.

Accepted Answer

A)   can
B)   can rarely
C)   can usually
D)   can neverE) B) and C)
F) A) and B)

Question 11

Adding a filter to a second field is an OR condition.

Accepted Answer

A) True 
 B)False  False

Question 12

Which of the following shortcuts opens the Backstage view so you can select a new database to create?

Accepted Answer

A)   Ctrl+B
B)   Ctrl+N
C)   Ctrl+O
D)   Ctrl+SE) C) and D)
F) A) and C)

Question 13

It is strongly recommended that you identify a(n) ___________ in each table as the primary key.

Accepted Answer

A)   field
B)   record
C)   object
D)   queryE) None of the above
F) A) and C)

Question 14

When you make a change to the row height in Access,which of the following changes to the new height?

Accepted Answer

A)   the current row
B)   the selected rows
C)   the visible rows
D)   all of the rowsE) All of the above
F) A) and D)

Question 15

Which of the following allows you to enter,modify,delete,or view data records?

Accepted Answer

A)   Design view
B)   Datasheet view
C)   External data
D)   Ctrl+NE) A) and C)
F) A) and B) B

Question 16

Form objects are used to find data in a database.

Accepted Answer

A) True 
 B)False  False

Question 17

Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?

Accepted Answer

A)   Font face
B)   Font size
C)   Font style
D)   Rich TextE) None of the above
F) A) and C)

Question 18

Which of the following functions are helpful in limiting the number of records that display in your datasheet?

Accepted Answer

A)   Filter
B)   Limit
C)   Sort
D)   SelectionE) A) and B)
F) None of the above

Question 19

Access is a relational database management system.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following tabs must you use to create all the objects you use in a database?

Accepted Answer

A)   File
B)   Create
C)   Database Tools
D)   External DataE) B) and C)
F) All of the above

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

What must you create for each of the different pieces of information you want to keep in your table?

Correct AnswerverifiedShow Answer

How do you know how many tables you need or which fields belong in which tables? What techniques can you use?

Correct AnswerverifiedThere are several different formal techn...View AnswerShow Answer

Design view allows you to enter,modify,delete,or view the data records.

Correct AnswerverifiedShow Answer

What symbol displays when Date and Currency values are too wide to fit in the column?

Correct AnswerverifiedShow Answer

To initiate the automatic saving of data,what must be done to your table at least once?

Correct AnswerverifiedShow Answer

It is important to save a database file before closing it.

Correct AnswerverifiedShow Answer

Which of the following is used to create an interface to view,add,update,and delete data?

Correct AnswerverifiedShow Answer

When a new table is created in Datasheet view,what field does Access automatically include?

Correct AnswerverifiedShow Answer

In Datasheet view,which of the following keys moves the pointer to the next field?

Correct AnswerverifiedShow Answer

The Undo button _______________ be used to undo changes made to the datasheet layout.

Correct AnswerverifiedShow Answer

Adding a filter to a second field is an OR condition.

Correct AnswerverifiedFalse

Which of the following shortcuts opens the Backstage view so you can select a new database to create?

Correct AnswerverifiedShow Answer

It is strongly recommended that you identify a(n) ___________ in each table as the primary key.

Correct AnswerverifiedShow Answer

When you make a change to the row height in Access,which of the following changes to the new height?

Correct AnswerverifiedShow Answer

Which of the following allows you to enter,modify,delete,or view data records?

Correct AnswerverifiedB

Form objects are used to find data in a database.

Correct AnswerverifiedFalse

Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?

Correct AnswerverifiedShow Answer

Which of the following functions are helpful in limiting the number of records that display in your datasheet?

Correct AnswerverifiedShow Answer

Access is a relational database management system.

Correct AnswerverifiedShow Answer

Which of the following tabs must you use to create all the objects you use in a database?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
There are several different formal techn...
View 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
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified