Quiz 5: Basic Forms and Reports

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.

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

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

Which of the following is not a form view? A) Form view B) Design view C) Layout view D) SQL view

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

What can you not easily do using a form? A) Enter data B) Edit data C) Move data D) Delete data

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

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.

Which form layout displays the data horizontally across the page. A) Tabular B) Stacked C) Horizontal D) Subform

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

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

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

What type of form control is normally used to display data? A) Text box B) Label C) Data D) Button

Which of the following cannot be included on a form? A) Check box B) Sub report C) Drop-down list D) Button

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.

Which form view is normally used for data entry? A) Design view B) Layout view C) Form view D) SQL view

What cannot be used as a record source? A) A report B) Table C) Query D) Multitable query

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.

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

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

What can you not do with an Access report? A) Print it B) Viewed onscreen C) Edit data D) Saved as a Word document

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

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

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.

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

Which of the following is not a report view? A) SQL view B) Report view C) Design view D) Layout view

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

What does PDF stand for? A) Public Document Format B) Portable Document Format C) Public Document File D) Portable Document File

Which control provides guides to keep your form neat? A) Text box B) Label C) Layout D) Button

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.

When running a report, which sort order takes precedence? A) Underlying table B) Report C) Underlying query D) Underlying form

The stacked layout displays data horizontally across the page.

A record source and a data source are synonymous.

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

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

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

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

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

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

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

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

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

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

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

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

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

The tabular layout displays data vertically across the page.

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

You can edit data in Form Layout view.

The Stacked Layout display data horizontally across the page.

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

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

Mailing labels are considered reports in Access 2019.

Data can be changed in Report view.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The default sort order in reports is ________.

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

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.

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

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

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

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.

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

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.