Question 1

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 selector 
A)  primary key 
B)  secondary key 
C)  index 
D)  record selector

Question 2

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)  datasheet 
A)  Record Selector 
B)  form 
C)  Append Row 
D)  datasheet

Question 3

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)  Currency 
A)  Short Text 
B)  Long Text 
C)  Number 
D)  Currency

Question 4

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Each field in a table must have a unique name.

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

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 9

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)  rename 
A)  save 
B)  back up 
C)  close 
D)  rename

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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)  Properties 
A)  Navigation pane 
B)  Navigation bar 
C)  Datasheet Formatting dialog box 
D)  Properties

Question 12

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

Accepted Answer

A)  NOT 
B)  OR 
C)  AND 
D)  BUT 
A)  NOT 
B)  OR 
C)  AND 
D)  BUT

Question 13

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

Accepted Answer

A)  report 
B)  form 
C)  query 
D)  table 
A)  report 
B)  form 
C)  query 
D)  table

Question 14

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 Diagram 
A)  hierarchy of data 
B)  database 
C)  database management system 
D)  Entity-Relationship Diagram

Question 15

To best organize a database,what must you understand?

Accepted Answer

A)  hierarchy of data 
B)  database 
C)  database management system 
D)  Entity-Relationship Diagram 
A)  hierarchy of data 
B)  database 
C)  database management system 
D)  Entity-Relationship Diagram

Question 16

Which of the following is used to store data records?

Accepted Answer

A)  report 
B)  form 
C)  query 
D)  table 
A)  report 
B)  form 
C)  query 
D)  table

Question 17

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)  Hyperlink 
A)  Currency 
B)  AutoNumber 
C)  OLE Object 
D)  Hyperlink

Question 18

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

Accepted Answer

A)  Table01 
B)  Table1 
C)  Datasheet01 
D)  Datasheet1 
A)  Table01 
B)  Table1 
C)  Datasheet01 
D)  Datasheet1

Question 19

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

Accepted Answer

When the number of records in a database

Question 20

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 Wizard 
A)  Hyperlink 
B)  Attachment 
C)  Calculated 
D)  Lookup Wizard

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

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

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

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

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

Each field in a table must have a unique name.

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

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

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

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

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

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

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

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

To best organize a database,what must you understand?

Which of the following is used to store data records?

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

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

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

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

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

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

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

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

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

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

Each field in a table must have a unique name.

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

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

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

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

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

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

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

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

To best organize a database,what must you understand?

Which of the following is used to store data records?

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

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

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

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

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