Question 1

What does the Format Painter button do?

Accepted Answer

You can "paint" or copy a cell

Question 2

Is ____________________ criteria will find all records where no entry has been made in the field.

Accepted Answer

The answer of Is ____________________ criteria will find all records...

Question 3

Clicking the ____________________ button sums the adjacent range above or to the left.

Accepted Answer

The answer of Clicking the ____________________ button sums the adjacent...

Question 4

When you add a new field to a form, two controls are usually created: a caption and a text box.

Accepted Answer

A) True 
 B)False

Question 5

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Accepted Answer

A)  Object 
B)  Record 
C)  Field 
D)  Table 
A)  Object 
B)  Record 
C)  Field 
D)  Table

Question 6

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Accepted Answer

A) True 
 B)False

Question 7

Compare the capabilities of queries and filters.

Accepted Answer

1.Queries are saved as objects in the da

Question 8

Match between columns
                        Premises: Last field of the current record
Current field of the next record
Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.
Current field of the previous record
First field of the current record
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc.Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access.Which one of the following is NOT a benefit of using Access?
Last field of the last record
Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?
Previous field of the current record
Lauren wants to create an Access database of the musical instruments she owns. She has written a paragraph describing the use for each inventory item.Which data type should she use to define the field that will store this information?
First field of the first record
A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.
Next field of the current record

Accepted Answer

The Answer of It's easier to set up a relational is...

Question 9

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 10

The COUNTA function is used to count the number of cells in a range that contain which type of data?

Accepted Answer

A)  numbers 
B)  text 
C)  formulas 
D)  All of the above 
A)  numbers 
B)  text 
C)  formulas 
D)  All of the above

Question 11

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.

Accepted Answer

A)  nested 
B)  combination 
C)  complex 
D)  exploded 
A)  nested 
B)  combination 
C)  complex 
D)  exploded

Question 12

This control displays a list of possible data entries from which the user can choose.

Accepted Answer

A)  Label 
B)  Text box 
C)  List box 
D)  Tab control 
A)  Label 
B)  Text box 
C)  List box 
D)  Tab control

Question 13

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Accepted Answer

The answer of In a(n) ____________________ form, the upper pane...

Question 14

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 15

On a form, ____________________ View can be used to move and modify controls while viewing live data.

Accepted Answer

The answer of On a form, ____________________ View can be...

Question 16

____________________ View is a view in which you create and manipulate the structure of an object.

Accepted Answer

The answer of ____________________ View is a view in which...

Question 17

Discuss the advantages of using Excel worksheets.

Accepted Answer

With Excel, you can enter information fa

Question 18

In the expression =Sum([Price]), the ____________________ function is used.

Accepted Answer

The answer of In the expression =Sum([Price]), the ____________________ function...

Question 19

Which is NOT true about Access?

Accepted Answer

A)  It can be used to arrange data in a variety of ways. 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to arrange data in a variety of ways. 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 20

Which two charts compare trends over time intervals?

Accepted Answer

A)  Bar and pie 
B)  Pie and area 
C)  Area and line 
D)  Line and scatter 
A)  Bar and pie 
B)  Pie and area 
C)  Area and line 
D)  Line and scatter

What does the Format Painter button do?

Is ____________________ criteria will find all records where no entry has been made in the field.

Clicking the ____________________ button sums the adjacent range above or to the left.

When you add a new field to a form, two controls are usually created: a caption and a text box.

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Compare the capabilities of queries and filters.

Values in an AutoNumber field are automatically created by Access.

The COUNTA function is used to count the number of cells in a range that contain which type of data?

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.

This control displays a list of possible data entries from which the user can choose.

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

On a form, ____________________ View can be used to move and modify controls while viewing live data.

____________________ View is a view in which you create and manipulate the structure of an object.

Discuss the advantages of using Excel worksheets.

In the expression =Sum([Price]), the ____________________ function is used.

Which is NOT true about Access?

Which two charts compare trends over time intervals?

Understanding Essential Computer

Integrating Word and Excel

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters

Exam 2: Getting Started With Access 2.0

What does the Format Painter button do?

Is ____________________ criteria will find all records where no entry has been made in the field.

Clicking the ____________________ button sums the adjacent range above or to the left.

When you add a new field to a form, two controls are usually created: a caption and a text box.

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Compare the capabilities of queries and filters.

Values in an AutoNumber field are automatically created by Access.

The COUNTA function is used to count the number of cells in a range that contain which type of data?

You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.

This control displays a list of possible data entries from which the user can choose.

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

On a form, ____________________ View can be used to move and modify controls while viewing live data.

____________________ View is a view in which you create and manipulate the structure of an object.

Discuss the advantages of using Excel worksheets.

In the expression =Sum([Price]), the ____________________ function is used.

Which is NOT true about Access?

Which two charts compare trends over time intervals?

Understanding Essential Computer

Integrating Word and Excel

Getting Started With Microsoft

Finishing a Presentation

Appendix Working With Windows Live and Office Web Apps Question

Getting Started With Windows 7

Creating Documents With Word 2010

Filters