Question 1

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False

Question 2

SQL is the acronym for " simple query language ".

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____________________ object allows a user to select a subset of fields or records from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Question 4

The ____ size is the physical size of the text.

Accepted Answer

A)  style 
B)  format 
C)  serif 
D)  font 
A)  style 
B)  format 
C)  serif 
D)  font

Question 5

The purpose of a report is to provide an easy-to-use data entry interface.

Accepted Answer

A) True 
 B)False

Question 6

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width .

Accepted Answer

A) True 
 B)False

Question 7

Which control is most commonly placed in the Report Header section?

Accepted Answer

A)  Text box 
B)  Subtotal 
C)  Check box 
D)  Label 
A)  Text box 
B)  Subtotal 
C)  Check box 
D)  Label

Question 8

The ____ of a cell determines how the labels and values look.

Accepted Answer

A)  value 
B)  formula 
C)  label 
D)  format 
A)  value 
B)  formula 
C)  label 
D)  format

Question 9

Marshall plans to generate reports from an Access table using the Report Wizard. The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice. How could Marshall design a report to quickly organize his equipment by most expensive to least expensive?

Accepted Answer

He should make sure

Question 10

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 11

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

Accepted Answer

A)  the user sees a "clipboard full" message 
B)  the clipboard automatically deletes all items and starts over with the new item 
C)  the clipboard prompts the user to delete items 
D)  the clipboard automatically deletes the oldest item on the clipboard 
A)  the user sees a "clipboard full" message 
B)  the clipboard automatically deletes all items and starts over with the new item 
C)  the clipboard prompts the user to delete items 
D)  the clipboard automatically deletes the oldest item on the clipboard

Question 12

What is meant by the format of a cell?

Accepted Answer

The format of a cell determines how the

Question 13

Which of the following comparison operators means "not equal to"?

Accepted Answer

A)  +=+ 
B)  =/= 
C)  > 
D) $ \neq $ 
A)  +=+ 
B)  =/= 
C)  > 
D) $ \neq $

Question 14

[Ctrl][Y] is the quick keystroke for the ____________________ command.

Accepted Answer

The answer of [Ctrl][Y] is the quick keystroke for the...

Question 15

The horizontal axis is also called the value axis.

Accepted Answer

A) True 
 B)False

Question 16

You can add fields to a form in either Layout View or Design View.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is a complex formula?

Accepted Answer

A)  =SUM(B4:B8) 
B)  =(B4/B8)*10 
C)  both a. and
B. 
D)  neither a. nor
B. 
A)  =SUM(B4:B8) 
B)  =(B4/B8)*10 
C)  both a. and
B. 
D)  neither a. nor
B.

Question 18

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ____ in the template.

Accepted Answer

A)  formulas 
B)  formatting 
C)  labels 
D)  data 
A)  formulas 
B)  formatting 
C)  labels 
D)  data

Question 19

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

Accepted Answer

A) True 
 B)False

An Access database is limited to a size of 1 gigabyte.

SQL is the acronym for " simple query language ".

A(n) ____________________ object allows a user to select a subset of fields or records from one or more tables.

The ____ size is the physical size of the text.

The purpose of a report is to provide an easy-to-use data entry interface.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width .

Which control is most commonly placed in the Report Header section?

The ____ of a cell determines how the labels and values look.

In Access, data entry screens are called forms .

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

What is meant by the format of a cell?

Which of the following comparison operators means "not equal to"?

[Ctrl][Y] is the quick keystroke for the ____________________ command.

The horizontal axis is also called the value axis.

You can add fields to a form in either Layout View or Design View.

Which of the following is a complex formula?

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ____ in the template.

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

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

An Access database is limited to a size of 1 gigabyte.

SQL is the acronym for " simple query language ".

A(n) ____________________ object allows a user to select a subset of fields or records from one or more tables.

The ____ size is the physical size of the text.

The purpose of a report is to provide an easy-to-use data entry interface.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width .

Which control is most commonly placed in the Report Header section?

The ____ of a cell determines how the labels and values look.

In Access, data entry screens are called forms .

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

What is meant by the format of a cell?

Which of the following comparison operators means "not equal to"?

[Ctrl][Y] is the quick keystroke for the ____________________ command.

The horizontal axis is also called the value axis.

You can add fields to a form in either Layout View or Design View.

Which of the following is a complex formula?

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ____ in the template.

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

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