Access Forms 3
Unlock all answers in this set
Unlock answersquestion
Access forms can be used to enter or edit data, but not to delete data. True or False
answer
False
question
Forms can be used to control access to data. True or False
answer
True
question
Forms are only capable of displaying a single record at a time. True Or False
answer
False
question
The Form tool creates a form displaying all fields from the underlying data source. True or False
answer
True
question
Forms based on a single table cannot display records from a related table. True or False
answer
False
question
A single record in a form can be printed to .pdf (Adobe Acrobat) format. True or False
answer
True
question
Access forms can be laid out to follow existing paper forms. True or False
answer
False
question
Forms can only be modified in Layout view. True or False
answer
False
question
Themes must be applied to all of the objects within the database. True or False
answer
False
question
Text boxes and their label controls must be formatted together. True or False
answer
False
question
Both the Find and Replace commands can be utilized within forms. True or False
answer
True
question
Filter by Selection can only be used in a single field. True or False
answer
True
question
Advanced Filter allows the OR condition. True or False
answer
True
question
The Report tool generates a report by displaying all records and all fields from the selected record source.True or False
answer
True
question
The Report tool will automatically adjust the size of fields within the headers and footers to fit onto one page.True or False
answer
False
question
Use the Report Wizard when you want to control the report's content and design. True or False
answer
True
question
Report modifications must be made in Design view. True or False
answer
False
question
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 or False
answer
True
question
The Report and Group Headers are printed at the top of every page of the report. True or False
answer
False
question
To see how information is grouped, sorted, or totaled, Design view is the preferred view. True or False
answer
False
question
The "keep whole group together on one page" command keeps everything between the group header and the group footer on one page.True or False
answer
True
question
Using a form for data entry can increase the usefulness of a database by increasing a. redundancy. b. accuracy. c. complexity. d. compatibility.
answer
b. accuracy.
question
When you delete records in Access and save, a. there is no warning message. b. you can use the Undo button to restore a record. c. any records deleted by mistake must be reentered. d. you can use the Redo button to restore a record.
answer
c. any records deleted by mistake must be reentered.
question
Which of the following displays only records that contain the value in the selected field? a. Filter by Form b. Advanced Filter/Sort c. Filter by Value d. Filter by Selection
answer
a. Filter by Form
question
When a filter is active, which of the following is NOT true? a. A small funnel appears to the right of the database name in the title bar. b. On the Home tab, in the Sort and Filter group, the Toggle Filter button is active. c. The word "Filtered" appears on the right side of the status bar. d. A Filtered button displays next to the number of records.
answer
a. A small funnel appears to the right of the database name in the title bar.
question
Compared to Filter by Form, Filter by Selection: a. can be used for more than one value in the same field. b. does not allow as much flexibility. c. allows filters that require matching multiple values. d. can be used to filter several fields at the same time.
answer
b. does not allow as much flexibility.
question
Compared to the Form tool, the Form Wizard a. allows more flexibility in the layout and design of the form. b. also includes all fields in the underlying data source. c. can be used with unrelated multiple tables. d. allows for headers, footers, and logos.
answer
a. allows more flexibility in the layout and design of the form.
question
Layout view for a form differs from Design view in that: a. Design view is the only way to change field widths. b. Design view is easier for users to master. c. Layout view offers more options for the form. d. Layout view allows modifications while viewing data.
answer
d. Layout view allows modifications while viewing data.
question
The advantage of resizing controls in Layout view rather than in Design view is a. in Layout view, unbound controls do not appear. b. in Layout view, each control must be sized separately, allowing greater control. c. by utilizing the spin boxes on the Design tab, widths can be determined exactly. d. by seeing the content of the fields in Layout view, you can visually determine that the space allotted is adequate.
answer
d. by seeing the content of the fields in Layout view, you can visually determine that the space allotted is adequate.
question
A theme a. should be applied before doing other formatting to a form. b. affects the structure (i.e., file sizes, field names) as well as appearance of the objects. c. cannot be altered once chosen. d. can only be applied to all objects within a database.
answer
a. should be applied before doing other formatting to a form.
question
Resizing sections in a form must be done in a. Form view. b. Design view. c. Layout view. d. Datasheet view.
answer
b. Design view.
question
Which of the following is NOT true regarding a report? a. It can summarize the records in an easy‐to‐read format. b. It can be based on a table. c. It can be based on a query. d. It can be based on another report.
answer
d. It can be based on another report.
question
To view report data while making changes to a report, use a. Design view. b. Form view. c. Layout view. d. Datasheet view.
answer
c. Layout view.
question
The Report Wizard a. enables you to specify how the report data is grouped and sorted. b. does not allow the use of fields from more than one table. c. asks questions, then suggests ways to design the report manually. d. is less user friendly than the Report Design tool.
answer
a. enables you to specify how the report data is grouped and sorted.
question
Organizing and summarizing data in a report can be accomplished by a. adding a calculated field. b. grouping data. c. adding a page footer. d. applying a theme.
answer
b. grouping data.
question
Which of the following would NOT be considered a design modification of a report? a. Change the format of controls. b. Change the table on which the report is based. c. Add or remove controls. d. Change the placement of controls in a report.
answer
b. Change the table on which the report is based.
