Question 1

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

Question 2

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) A) and D)

Question 3

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) None of the above
F) B) and C)

Question 4

Access is a relational database management system.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

Form objects are used to find data in a database.

Accepted Answer

A) True 
 B)False  False

Question 11

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

Accepted Answer

A) True 
 B)False  False

Question 12

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) All of the above
F) A) and B)

Question 13

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 14

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

Question 15

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) B) and D)
F) None of the above

Question 16

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

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) None of the above

Question 20

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) A) and B)
F) All of the above

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Access is a relational database management system.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Form objects are used to find data in a database.

Correct AnswerverifiedFalse

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

Correct AnswerverifiedFalse

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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
False

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
There are several different formal techn...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified