Exam 2: Getting Started With Access 2.0

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

You can use the ____ key(s) on the keyboard to navigate a worksheet.

(Multiple Choice)
4.7/5
(28)

The Page Header section prints ____.

(Multiple Choice)
4.8/5
(36)

On a chart created in Excel, the vertical axis is called the ____.

(Multiple Choice)
4.8/5
(29)

Cells and ranges in a worksheet can be formatted ____.

(Multiple Choice)
4.8/5
(41)

The Paste option from the Excel Home tab allows the user to specify components of a cell's contents to be pasted.

(True/False)
4.9/5
(41)

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

(Multiple Choice)
4.8/5
(29)

This control is used to create a three-dimensional aspect to a form.

(Multiple Choice)
4.8/5
(34)

Which of the following is NOT a way to open Access?

(Multiple Choice)
4.9/5
(43)

Deleting a field from a query also deletes it from the underlying table.

(True/False)
4.8/5
(34)

When creating a database using an Access template, you must remember that the database cannot be altered later.

(True/False)
4.7/5
(39)

A(n) ____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

(Short Answer)
4.8/5
(35)

Which type of control would you most likely use to display name information?

(Multiple Choice)
4.7/5
(27)

This section generally constitutes the largest physical space on the report.

(Multiple Choice)
4.8/5
(38)

The Excel operator for exponent is ____.

(Multiple Choice)
4.8/5
(46)

The report section before a group of records is called the Group ____________________ section.

(Short Answer)
4.8/5
(36)

A query datasheet is sometimes called a ____ of the data.

(Multiple Choice)
4.9/5
(34)

Which of the following keys will help you delete unwanted data in Edit mode?

(Multiple Choice)
4.8/5
(34)

A join line is also called a ____ line.

(Multiple Choice)
4.8/5
(33)
Match each term with the statement that best describes it.
Rules that determine how criteria is entered
Query grid
Criterion that finds all records where no entry has been made in the field
Wildcard
Putting records in ascending or descending order based on a field's values
Sorting
Correct Answer:
Verified
Premises:
Responses:
Rules that determine how criteria is entered
Query grid
Criterion that finds all records where no entry has been made in the field
Wildcard
Putting records in ascending or descending order based on a field's values
Sorting
Creates a temporary subset of records
Syntax
Limiting conditions used to narrow the number of records on a datasheet
Filter
Used to search for a pattern
Is Null
Creates a datasheet of selected fields and records from one or more tables
Query
The lower pane in Query Design View
Criteria
(Matching)
4.8/5
(27)

An Excel workbook has the file extension .xml.

(True/False)
4.8/5
(41)
Showing 21 - 40 of 439
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)