Question 1

Access provides many different ways to navigate among the data records stored in your tables.

Accepted Answer

A) True 
 B)False

Question 2

Once a filter has been applied to datasheet records,it is not possible to return them to their original unfiltered state.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following describes a pre-designed database?

Accepted Answer

A)  object 
B)  Blank desktop database 
C)  Leszynski 
D)  template 
A)  object 
B)  Blank desktop database 
C)  Leszynski 
D)  template

Question 4

If you have several users of your database,you must be certain that all users have ___________ the database before you perform a backup procedure.

Accepted Answer

A)  saved 
B)  copied 
C)  closed 
D)  renamed 
A)  saved 
B)  copied 
C)  closed 
D)  renamed

Question 5

Each object in your database application is shown in the ___________________.

Accepted Answer

A)  Navigation pane 
B)  File tab 
C)  datasheet 
D)  Navigation menu 
A)  Navigation pane 
B)  File tab 
C)  datasheet 
D)  Navigation menu

Question 6

Which of the following tabs provides functionality for linking to other applications and data files?

Accepted Answer

A)  File 
B)  Create 
C)  Database Tools 
D)  External Data 
A)  File 
B)  Create 
C)  Database Tools 
D)  External Data

Question 7

In Access,the primary object of a database is called a table.

Accepted Answer

A) True 
 B)False

Question 8

The Sort functions are helpful in limiting the number of records that display in your datasheet.

Accepted Answer

A) True 
 B)False

Question 9

Descending order is the lowest to highest for a number field or A to Z for a text field.

Accepted Answer

A) True 
 B)False

Question 10

What is a collection of related records called?

Accepted Answer

A)  field 
B)  record 
C)  table 
D)  database 
A)  field 
B)  record 
C)  table 
D)  database

Question 11

What is meant by the phrase "hierarchy of data" and why is it important to know about this when creating a database?

Accepted Answer

The first step in creating a database is

Question 12

Which of the following determines the default alignment of each field?

Accepted Answer

A)  field type 
B)  launcher 
C)  gridlines 
D)  alternate row colors 
A)  field type 
B)  launcher 
C)  gridlines 
D)  alternate row colors

Question 13

Which of the following allows you to build or modify the basic structure or functionality of an object?

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

Question 14

Which of the following data types is used to store the results of a calculation?

Accepted Answer

A)  Hyperlink 
B)  Attachment 
C)  Calculated 
D)  Lookup Wizard 
A)  Hyperlink 
B)  Attachment 
C)  Calculated 
D)  Lookup Wizard

Question 15

The Back Up Database option creates a copy of your database.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following helps you easily scan the records and fields in your database?

Accepted Answer

A)  field type 
B)  launcher 
C)  gridlines 
D)  alternate row colors 
A)  field type 
B)  launcher 
C)  gridlines 
D)  alternate row colors

Question 17

The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.

Accepted Answer

A) True 
 B)False

Question 18

When working with a new table,you can save it by clicking the File tab and clicking the Save button.

Accepted Answer

A) True 
 B)False

Question 19

A template provides you with a complete,ready-to-use database application.

Accepted Answer

A) True 
 B)False

Question 20

Which tab are Access's features for formatting text found?

Accepted Answer

A)  File 
B)  Home 
C)  Create 
D)  Format 
A)  File 
B)  Home 
C)  Create 
D)  Format

Access provides many different ways to navigate among the data records stored in your tables.

Once a filter has been applied to datasheet records,it is not possible to return them to their original unfiltered state.

Which of the following describes a pre-designed database?

If you have several users of your database,you must be certain that all users have ___________ the database before you perform a backup procedure.

Each object in your database application is shown in the ___________________.

Which of the following tabs provides functionality for linking to other applications and data files?

In Access,the primary object of a database is called a table.

The Sort functions are helpful in limiting the number of records that display in your datasheet.

Descending order is the lowest to highest for a number field or A to Z for a text field.

What is a collection of related records called?

What is meant by the phrase "hierarchy of data" and why is it important to know about this when creating a database?

Which of the following determines the default alignment of each field?

Which of the following allows you to build or modify the basic structure or functionality of an object?

Which of the following data types is used to store the results of a calculation?

The Back Up Database option creates a copy of your database.

Which of the following helps you easily scan the records and fields in your database?

The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.

When working with a new table,you can save it by clicking the File tab and clicking the Save button.

A template provides you with a complete,ready-to-use database application.

Which tab are Access's features for formatting text found?

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

Access provides many different ways to navigate among the data records stored in your tables.

Once a filter has been applied to datasheet records,it is not possible to return them to their original unfiltered state.

Which of the following describes a pre-designed database?

If you have several users of your database,you must be certain that all users have ___________ the database before you perform a backup procedure.

Each object in your database application is shown in the ___________________.

Which of the following tabs provides functionality for linking to other applications and data files?

In Access,the primary object of a database is called a table.

The Sort functions are helpful in limiting the number of records that display in your datasheet.

Descending order is the lowest to highest for a number field or A to Z for a text field.

What is a collection of related records called?

What is meant by the phrase "hierarchy of data" and why is it important to know about this when creating a database?

Which of the following determines the default alignment of each field?

Which of the following allows you to build or modify the basic structure or functionality of an object?

Which of the following data types is used to store the results of a calculation?

The Back Up Database option creates a copy of your database.

Which of the following helps you easily scan the records and fields in your database?

The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.

When working with a new table,you can save it by clicking the File tab and clicking the Save button.

A template provides you with a complete,ready-to-use database application.

Which tab are Access's features for formatting text found?

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