Question 1

Form objects are used to find data in a database.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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+N 
A)  Design view 
B)  Datasheet view 
C)  External data 
D)  Ctrl+N B

Question 4

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+S 
A)  Ctrl+B 
B)  Ctrl+N 
C)  Ctrl+O 
D)  Ctrl+S

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  AUTO 
B)  COUNTER 
C)  ID 
D)  FIELD 
A)  AUTO 
B)  COUNTER 
C)  ID 
D)  FIELD

Question 7

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)  renamed 
A)  opened 
B)  saved 
C)  backed up 
D)  renamed

Question 8

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)  table 
A)  report 
B)  form 
C)  query 
D)  table

Question 9

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 Data 
A)  File 
B)  Create 
C)  Database Tools 
D)  External Data

Question 10

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 rows 
A)  the current row 
B)  the selected rows 
C)  the visible rows 
D)  all of the rows

Question 11

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 never 
A)  can 
B)  can rarely 
C)  can usually 
D)  can never

Question 12

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)  query 
A)  field 
B)  record 
C)  object 
D)  query

Question 13

Access is a relational database management system.

Accepted Answer

A) True 
 B)False

Question 14

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 (#####) 
A)  dollar signs ($$$$$) 
B)  asterisks (*****) 
C)  ampersands (@@@@@) 
D)  pound signs (#####)

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)  Selection 
A)  Filter 
B)  Limit 
C)  Sort 
D)  Selection

Question 16

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 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 Text 
A)  Font face 
B)  Font size 
C)  Font style 
D)  Rich Text

Question 18

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)  query 
A)  field 
B)  record 
C)  object 
D)  query

Question 19

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

Accepted Answer

A)  Tab 
B)  Shift 
C)  Esc 
D)  Insert 
A)  Tab 
B)  Shift 
C)  Esc 
D)  Insert

Question 20

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

Accepted Answer

A) True 
 B)False

Form objects are used to find data in a database.

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

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

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

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

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

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

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

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

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

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

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

Access is a relational database management system.

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

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

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

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

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

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

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

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Filters

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

Form objects are used to find data in a database.

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

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

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

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

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

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

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

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

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

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

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

Access is a relational database management system.

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

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

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

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

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

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

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

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Filters