How can we help?

You can also find more resources in our Help Center.

50 terms

access 3

STUDY
PLAY
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