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.


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


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


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


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


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


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


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


A theme

should be applied before doing other formatting to a form.

Advanced Filter allows the OR condition.


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.


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


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.


Compared to Filter by Form, Filter by Selection

does not allow as much flexibility.

Text boxes and their label controls must be formatted together.


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


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.


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.


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.


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


Forms can be used to control access to data.


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


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.


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


The OR condition

displays records that meet either of two criteria.

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


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


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.


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.


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


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.


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


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


Reload the page to try again!


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