Advertisement Upgrade to remove ads

When you delete records in Access,

any records deleted by mistake must be reentered.

Forms can only be modified in Layout view.

false

Section bars designate the various sections of a form in Design view.

true

Access forms can

be based on multiple tables.

In Layout view, if the width of controls is insufficient to display all of the data, the field has been

truncated

The margins and page breaks in a report are only viewable in a report's Design view.

false

Two controls normally found in a Report Footer are the date control and the page number control.

false

A report can include a summary line that details what is being summarized and the number of records being included in the summary total.

true

Forms based on a single table cannot display information from other related tables.

false

The Report tool will automatically adjust the size of fields within headers and footers to fit onto one page.

false

A theme

should be applied before doing other formatting to a form.

Advanced Filter allows the OR condition.

true

Which of the following would NOT be considered a design modification of a report?

Change the table on which the report is based.

Access forms can be used to enter or edit data, but not to delete data.

false

Different themes can be applied to various objects within a database.

true

In Layout view, the ________ is a small symbol displayed in the upper left corner used to move the entire group of controls.

layout selector

Report modifications need to be made in Design view.

false

Compared to Filter by Form, Filter by Selection

does not allow as much flexibility.

Text boxes and their label controls must be formatted together.

false

Forms are bound to the table in which the records are stored.

true

When a filter is active, which of the following is NOT true?

A small funnel appears to the right of the database name in the title bar.

The choice of a theme should precede other formatting choices.

true

To print just one record from a form, which of the following would you choose in the Print dialog box?

the Selected Record(s) option

The Blank Report tool is most efficient when your table contains lots of fields.

false

Organizing and summarizing data in a report can be accomplished by

grouping data.

When entering new information into a field, the record selector displays a hand with a finger pointing to the current record being entered.

false

The Form tool creates a form displaying all fields from the underlying data source.

true

Forms can be used to control access to data.

true

The Report and Group Headers are printed at the top of every page of the report.

false

When a field is too narrow to display numeric information, the data displays as

pound signs.

Filter by Selection can only be used in a single field.

true

Use the Report Wizard when you want to control the report's content and design.

true

The OR condition

displays records that meet either of two criteria.

Forms are only capable of displaying a single record at a time.

false

Sorting in a report can be done on up to three fields.

false

Which of the following displays only records that contain the value in the selected field?

Filter by Selection

The Report tool generates a report by displaying all records and all fields from the selected record source.

true

Which is NOT true concerning forms?

Every table must have at least one form.

Resizing sections in a form must be done in

Design view.

Themes cannot be applied to a single database object.

false

The advantage of resizing controls in Layout view rather than in Design view is

by seeing the content of the fields in Layout view, you can visually determine that the space allotted is adequate.

Which of the following can display records based on values in one or more fields?

Filter by Form

Using a form for data entry can increase the usefulness of a database by increasing

accuracy

Which of the following is NOT true regarding a report?

It can be based on another report.

To view report data while making changes to a report, use

Layout view.

The Report Wizard

enables you to specify how the report data is grouped and sorted.

Using the"keep whole group together on one page" command ensures

labels, data, and totals will all be on one page as long as the data doesn't exceed one page.

When viewing a report in Design view, which of the following is NOT a section name?

Form Footer

To see how information is grouped, sorted, or totaled, Design view is the preferred view.

false

The "keep whole group together on one page" command keeps everything between the group header and the group footer on one page.

true

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set