Exam 2: Getting Started With Access 2.0

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

A cell reference that does not change when it is copied is called a relative cell reference.

Which is NOT a feature of Access reports?

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

In Excel, MAX and AVERAGE are examples of _____.

Field properties change depending on the data type of the field.

Each value in a cell selected for a chart is called a ____.

You can switch between views using the View buttons in the lower- left corner of the window.

Which two sections can be added to a report if you group records?

You can use predesigned, formatted files called ____ to create new worksheets quickly.

Which of the following is not an option that the Data Labels can produce?

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. What feature of Report Design View would Marshall use to change sorting and grouping orders?

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

You can use a named range instead of a cell address in a formula.

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

A pie chart ____.

This section prints once for every record.

The font size is measured in units called pixels .

The record selector button is to the right of a record in a datasheet.

To show how individual volume changes over time in relation to total volume, use a(n) ____.