Exam Questions Chapter.5 Basic Forms And Reports 1st Edition

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 5 Basic Forms and Reports

1) Which of the following is not true of a form?

A) It is the most common method of entering data.

B) It can be sorted independently of its data source.

C) It can contain background images.

D) It can only display one record at a time.

Diff: 2

Objective: Multiple Objectives

2) Which of the following is not a form tool that is available in Access 2019?

A) Form

B) Multiple Form

C) Form Design

D) Split Form

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

3) Which of the following can you not do if you use a query as the record source for a form?

A) Lock your form so that it cannot be edited

B) Filter the records

C) Combine records from multiple tables

D) Limit the number of fields in the table which are displayed

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

4) Which of the following is not a form view?

A) Form view

B) Design view

C) Layout view

D) SQL view

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

5) What is not true about the Form Design view?

A) Gives access to advanced design settings

B) Gives more control over form design

C) It allows you to see live data while you edit the form.

D) Allows you to remove layout controls from a form

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

6) What can you not easily do using a form?

A) Enter data

B) Edit data

C) Move data

D) Delete data

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

7) Which of the following is not considered one of the most common methods to create a form?

A) Default Form

B) Form Wizard

C) Blank Form

D) Form Design

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

8) What is not a valid reason to edit a form's layout?

A) New fields need to be added.

B) Unused fields need to deleted.

C) Extra fields need to be added (just in case they will be needed later).

D) The user's needs have changed.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

9) Which form layout displays the data horizontally across the page.

A) Tabular

B) Stacked

C) Horizontal

D) Subform

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

10) What is not true about a split form?

A) You can pick one record for the top and a different record for the bottom

B) Combines two views of the same record

C) Top section uses a stacked layout

D) Bottom section uses a tabular layout

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

11) Which form (which will include the existing fields from the data source) can be created with just one click?

A) Tabular layout

B) Stacked layout

C) Blank Form

D) Find Duplicates

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

12) Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

A) Design view

B) Layout view

C) Form view

D) SQL view

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

13) What type of form control is normally used to display data?

A) Text box

B) Label

C) Data

D) Button

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

14) Which of the following cannot be included on a form?

A) Check box

B) Sub report

C) Drop-down list

D) Button

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

15) Which of the following is not a good reason for using a form for data entry?

A) Data you enter in a form must then be transferred to the table.

B) You probably will not edit the wrong record.

C) You can show data from more than one table at a time.

D) Your form can resemble paper forms.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

16) Which form view is normally used for data entry?

A) Design view

B) Layout view

C) Form view

D) SQL view

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

17) What cannot be used as a record source?

A) A report

B) Table

C) Query

D) Multitable query

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

18) What is not true about print preview?

A) It shows what the report will look like if printed.

B) It allows you to change the layout of the report.

C) It will display all the pages by default.

D) The report can be exported from this view.

Diff: 3

Objective: A4.06 Use Report Views

19) What is not true about Navigation forms?

A) Can give the look and feel of web-based forms

B) Allows the quick navigation between objects in the database

C) Simplifies navigation for data-entry people

D) It is not designed to be changed after it is set up

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

20) What is not true about a multiple items form?

A) Displays multiple records in a stacked layout

B) Displays multiple records in a tabular layout

C) Allows more customization than a datasheet

D) Data appears similar to a datasheet

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

21) What can you not do with an Access report?

A) Print it

B) Viewed onscreen

C) Edit data

D) Saved as a Word document

Diff: 1

Objective: A4.05 Create Reports Using Report Tools

22) What is not true about the label wizard?

A) Allows you to print name tags

B) Allows you to select from many label companies

C) It sets up a label mail merge file which actually prints through Microsoft Word

D) It is considered a specialized report

Diff: 2

Objective: A4.05 Create Reports Using Report Tools

23) What is not an option in the Layout Options for Grouped Data in the Report Wizard?

A) Multi-level

B) Stepped

C) Block

D) Outline

Diff: 3

Objective: A4.05 Create Reports Using Report Tools

24) What is not true about a report?

A) It is designed to display only one record at a time.

B) It can be sorted independently of its data source.

C) Its record sources include one of more tables or a query.

D) It can be previewed before it is printed.

Diff: 2

Objective: A4.05 Create Reports Using Report Tools

25) Which of the following is not a primary consideration when designing a report?

A) The purpose of the report

B) Who will use the report

C) What information will be needed in the report

D) How many pages long the report will be

Diff: 1

Objective: A4.05 Create Reports Using Report Tools

26) Which of the following is not a report view?

A) SQL view

B) Report view

C) Design view

D) Layout view

Diff: 1

Objective: A4.06 Use Report Views

27) Normally when you Print Preview a report it will generate a report with how many pages?

A) Only the first page

B) Only the first two pages

C) All the pages only if they will all fit on the screen at one time

D) All the pages

Diff: 3

Objective: A4.06 Use Report Views

28) What does PDF stand for?

A) Public Document Format

B) Portable Document Format

C) Public Document File

D) Portable Document File

Diff: 2

Objective: A4.06 Use Report Views

29) Which control provides guides to keep your form neat?

A) Text box

B) Label

C) Layout

D) Button

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

30) What is the advantage of saving a report as a PDF file?

A) More people can open the file.

B) It is smaller.

C) It compresses more tightly.

D) It opens more quickly for other Microsoft Office users.

Diff: 3

Objective: A4.06 Use Report Views

31) When running a report, which sort order takes precedence?

A) Underlying table

B) Report

C) Underlying query

D) Underlying form

Diff: 3

Objective: A4.08 Sort and Group Records in a Report

32) The stacked layout displays data horizontally across the page.

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

33) A record source and a data source are synonymous.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

34) On a form, the text box and its label would be considered two different controls.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

35) Most forms allow you to enter data into more than one record at a time.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

36) The Report Wizard allows you to easily create a customized report.

Diff: 1

Objective: A4.05 Create Reports Using Report Tools

37) A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

38) If a form is designed properly it will not have to be changed once data entry has begun.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

39) One advantage to using a form is that you can display data from more than one table at the same time.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

40) Good forms need to balance efficiency with a user-friendly interface.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

41) Design view allows less options for editing your form than Layout view?

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

42) The PDF format allows files to be shared without the recipient owning the program which created the file.

Diff: 1

Objective: A4.06 Use Report Views

43) The form Layout view gives the form designer the most flexibility in creating forms.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

44) Navigation forms enable users to quickly navigate between the objects of a database.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

45) A multiple items form shows more than one record at one time instead of the one record which is normally displayed in a form.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

46) Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

47) The tabular layout displays data vertically across the page.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

48) If you want to resize just a few controls on a form they must be removed from the Layout control.

Diff: 2

Objective: A4.02 Modify Forms

49) You can edit data in Form Layout view.

Diff: 2

Objective: A4.02 Modify Forms

50) The Stacked Layout display data horizontally across the page.

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

51) The default sort order for a table is by its primary key.

Diff: 1

Objective: A4.04 Sort Records in a Form

52) Just as with forms, you can add, edit, or delete data in a report.

Diff: 1

Objective: A4.05 Create Reports Using Report Tools

53) Mailing labels are considered reports in Access 2019.

Diff: 3

Objective: A4.05 Create Reports Using Report Tools

54) Data can be changed in Report view.

Diff: 1

Objective: A4.07 Modify a Report

55) If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Diff: 3

Objective: A4.07 Modify a Report

56) The sort order in a report's source overrides any sort order applied to the report.

Diff: 2

Objective: A4.08 Sort and Group Records in a Report

57) The Form ________ tool enables you to create a form by answering a series of questions.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

58) The first step in creating a form is to determine the record ________.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

59) Buttons, text boxes, and other tools that are found on a form are called ________.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

60) When creating a form, Access might automatically add a(n) ________ if more than one table is related.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

61) The form ________ view enables you to change advanced design settings.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

62) The ________ tool enables you to create a form using a tabular layout.

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

63) The most common method of entering data into a database is through the use of a(n) ________.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

64) The control that is used to describe the values in a text box is usually the ________ control.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

65) The ________ Form tool enables you to create a form in Layout view.

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

66) The ________ tool is the tool most often used to create forms.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

67) When you make changes to data in a form, the data in the underlying ________ are affected.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

68) The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

69) The ________ tool enables you to create a user-interface which works on the Internet.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

70) The Form ________ tool enables you to create a form in design view.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

71) Using a(n) ________ as the record source for a form enables you to pick and choose what fields will be included on the form.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

72) The most common method of finding information in a database is through the use of a(n) ________.

Diff: 3

Objective: A4.01 Create Forms Using Form Tools

73) The ________ view allows you to make changes to the form while viewing your actual data.

Diff: 2

Objective: A4.01 Create Forms Using Form Tools

74) If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Diff: 2

Objective: A4.03 Use the Form Layout Control

75) If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Diff: 2

Objective: A4.04 Sort Records in a Form

76) A(n) ________ is an Access object that outputs data in a meaningful way to those who view them.

Diff: 1

Objective: A4.05 Create Reports Using Report Tools

77) If you wanted the most freedom in creating a report you would use the ________ tool.

Diff: 3

Objective: A4.05 Create Reports Using Report Tools

78) Most reports do not use the ________ layout because it makes the report longer than the alternative.

Diff: 3

Objective: A4.05 Create Reports Using Report Tools

79) ________ will allow you to see what a report will look like before it is printed.

Diff: 1

Objective: A4.06 Use Report Views

80) ________ & Sort is used to add sorting to a report.

Diff: 3

Objective: A4.08 Sort and Group Records in a Report

81) The default sort order in reports is ________.

Diff: 1

Objective: A4.08 Sort and Group Records in a Report

82) Match the following terms with their description:

I. Control

II. Theme

III. Form

IV. Report

V. Record Source

A. Helpful way of displaying data from multiple records

B. A consistent set of colors and other formatting which can be applied to a report or form

C. Used to display data in a form or report

D. Main data entry object

E. Determines what data can display in a form or report

Diff: 1

Objective: Multiple Objectives

83) Match the following terms with their description:

I. Label Wizard

II. Form Wizard

III. Report Wizard

IV. SubForm Wizard

V. SubReport Wizard

A. Simplified way to create forms

B. Simplified way to create subforms

C. Simplified way to create reports

D. Used to create name tags

E. This does not exist in Access.

Diff: 1

Objective: Multiple Objectives

84) Match the following terms with their description:

I. Subform

II. Subreport

III. Subquery

IV. Datasheet format

V. SubForm Wizard

A. Provides an easy way to add a subform to form

B. This does not exist in Access.

C. Displays data in a grid like Excel

D. Displays related record on a form

E. Displays related records on a report

Diff: 1

Objective: Multiple Objectives

85) Match the following terms with their description:

I. Report Layout Control

II. Form controls

III. Controls

IV. Control Wizard

V. Text controls

A. Used to keep a uniform look on a form

B. This does not exist in Access.

C. Used to display values

D. Items such as labels and text boxes

E. Used to keep a uniform look on a report

Diff: 1

Objective: Multiple Objectives

86) Match the following terms with their description:

I. Form view

II. Design view

III. Layout view

IV. Views group

V. Print preview

A. Used to make advanced changes to a form

B. Often keeps you from wasting paper

C. Enables changes while viewing actual data

D. Used for data entry

E. Found on the Home tab

Diff: 1

Objective: Multiple Objectives

87) Match the following form tools with their description:

I. Form

II. Form Design

III. Split Form

IV. Datasheet

V. Switchboard

A. Immediately creates a blank form with a stacked layout

B. Immediately creates a blank form in Design view

C. Creates a form that looks like a table in its normal view

D. Includes a stacked layout and a tabular layout in two different sections of the form

E. This is not an Access Form tool.

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

88) Match the following terms with their description:

I. Form

II. Application Parts

III. Record source

IV. Stacked layout

V. Tabular layout

A. Used to build database objects

B. Fields are displayed in a vertical column

C. Fields are displayed in horizontal columns

D. A user-friendly interface

E. Supplies the records for a form or report

Diff: 1

Objective: A4.01 Create Forms Using Form Tools

89) Match the following terms with their description:

I. Split form

II. Multiple items form

III. Property sheet

IV. Sub form

V. Dual Record form

A. Controls the behavior of the form

B. Displays related records

C. Two views of the same record source

D. Not available in Access

E. More than one record is displayed.

Diff: 1

Objective: A4.05 Create Reports Using Report Tools