Deck 18: Access: Powerpoint Rich Media Tools

Question 1

You are working on an Access form and want to apply programming logic to a field in the form. This can be done in ________.

A) Print Preview
B) Design View
C) Stacked View
D) Layout View

Answer 1

B

Question 2

In the first Form Wizard dialog box, you would specify the ____.

A) tables or queries to be used and the fields to include
B) layout of the form
C) name of the form
D) design of the form

Answer 2

A

Question 3

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

A) Layout view
B) Print Preview
C) Design view
D) Report view

Answer 3

B

Question 4

All of the following are sections of an Access Form EXCEPT:

A) Detail Section
B) Header Section
C) Page Header Section
D) Footer Section

Question 5

Which of the following statements accurately describes a split form?

A) Split forms combine two different views of two different record sources
B) A Split form is a type of subform
C) You cannot edit records in a Split form
D) Split forms combine two different views of the same record source

Question 6

The form header section displays

A) in the form's record source.
B) at the bottom of the form.
C) at the top of each form.
D) at the top of each page.

Question 7

Steve is working in a database that holds patient data for a medical center. A patient's identification number serves as a primary key in the Patient table. A patient's identification number serves as a foreign key in the Doctor table. Steve wants to create a Form that displays Doctor table records with foreign key values that match the primary key value in the Patient table. How should Steve proceed?

A) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a subform to his form.
B) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a Split form to his form.
C) Use the Form tool to create the form and Access will analyze the table relationships Steve created in the database, and automatically add a Multi-items form to his form.
D) Steve can only create a form that displays one record source at a time.

Question 8

To sort the order of records in a form, you need to open the form in

A) Tabular View
B) Form View
C) Design View
D) Print Preview

Question 9

The ________ displays form fields in vertical column, and displays one record at a time.

A) Stacked Layout
B) Layout View
C) Tabular Layout
D) Print Preview

Question 10

All of the following are Form views EXCEPT:

A) Tabular View
B) Layout View
C) Form View
D) Design View

Question 11

What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance?

A) Bounded
B) Layout
C) Unbounded
D) Calculated

Question 12

Which of the following statements is TRUE when comparing forms and reports?

A) The same wizard can be used for creating forms and reports.
B) Forms and reports contain the same controls.
C) Themes can be used with Reports, but not with Forms.
D) Creating forms and reports begins by sketching an outline of the form or report.

Question 13

The table or query that supplies underlying data to a form or report is called the:

A) Information source
B) Data source
C) Record source
D) Object source

Question 14

The form Layout view can be used for all of the following EXCEPT

A) adding or removing a field.
B) changing the order of fields.
C) adding a calculated field.
D) changing the width of a field.

Question 15

Which of the following statements is NOT true regarding a Form's design view?

A) Design view is used to make advanced changes to a form
B) You can perform many of the same tasks in Design view as you can in Layout view
C) Changes to the form sections can only be made in Design view
D) Record source data is shown in Design view

Question 16

A(n) ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

A) Multiple Items form
B) Subform
C) Split form
D) Datasheet form

Question 17

Jill must create a report for an Access database, but is unfamiliar with creating reports in Access. Which Report tool should Jill use?

A) Report Blank
B) Report Wizard
C) Report
D) Report Design

Question 18

A ________ control, like a text box, is linked to data sources while a ________ control, like a label, is used to describe data and create aesthetically pleasing forms.

A) bound, unbound
B) unbound, bound
C) calculated, bound
D) bound, calculated

Question 19

What type of form displays records in a tabular layout similar to a table's Datasheet view but has more editing options, such as adding graphics and buttons, than a datasheet?

A) Split Form
B) Multiple Items Form
C) Subform
D) Datasheet form

Question 20

All of the following are form creation tools EXCEPT:

A) Form Design
B) Form Wizard
C) Form Layout
D) Blank Form

Question 21

If you need to sort the records contained in a report, you can do so from either the design view or the ________ of the report.

A) Design View
B) Layout View
C) Print preview
D) Report view

Question 22

Which of the following statement is true in reference to the report Detail section?

A) The Detail section prints the value of each unique instance for a grouped field.
B) The Detail section appears at the top of a report.
C) The Detail section repeats for every record in the record source.
D) The Detail section holds the report title, the organization's name, and the company logo.

Question 23

-Referencing the image above, what number represents the section that a page number would appear in the report?

A) 1
B) 2
C) 3
D) 4

Question 24

You can add Visual Basic for Applications (VBA) code to a form in ________ view.

A) Report View
B) Design View
C) Layout View
D) Print Preview

Question 25

-Referencing the image above, what number represents the section where a comprehensive total value would appear in the report?

A) 1
B) 2
C) 3
D) 4

Question 26

When you use the Split Form tool, the ________ views are synchronized with each other at all times.

A) Form and Layout
B) Layout and Design
C) Form and Datasheet
D) Design and Datasheet

Question 27

You use a(n) ________ control to display text or decorative elements on a form.

A) bound
B) unbound
C) graphical
D) freeform

Question 28

-Referencing the image above, what number represents the section where data from a record source would appear in the report?

A) 2
B) 3
C) 4
D) 5

Question 29

-Referencing the image above, this Access report is shown in ________ view.

A) Design
B) Layout
C) Print Preview
D) Form

Question 30

If your report has a ________ section, it precedes the first Page Header section.

A) Access Header
B) Group Header
C) Detail Header
D) Report Header

Question 31

A(n) ________ is an unbound control that displays text.

A) label
B) roster
C) index
D) listing

Question 32

The Report ________ section of a report is used for report totals and other summary information.

A) Detail
B) Footer
C) Header
D) Page Header

Question 33

Each object you place on a form is called a(n) ________.

A) index
B) label
C) icon
D) control

Question 34

-Referencing the image above, what number represents the section where the title would appear in the report?

A) 2
B) 3
C) 4
D) 5

Question 35

All of the following are sections in an Access report EXCEPT:

A) Report Detail section
B) Report Header section
C) Report Calculated section
D) Report Footer section

Question 36

You can use the ________ to create specialized reports that come preformatted to for name-brand labels such as Avery.

A) Report Wizard
B) Form Wizard
C) Mailing Wizard
D) Label Wizard

Question 37

Which of the following statements is true in reference to comparing the sections in Access forms and the sections in Access reports?

A) Forms have more sections than reports, and working with report sections is much different from working with form sections.
B) Reports have more sections than forms, but working with report sections is similar to working with form sections.
C) Forms have the same number of sections as reports, and working with report sections is similar to working with form sections.
D) Forms have the same number of sections as reports, but working with report sections is much different from working with form sections.

Question 38

-Referencing the image above, what number represents the section where the page number, date and time would appear on each page in the report?

A) 1
B) 2
C) 3
D) 4

Question 39

You can use Form view to ________ the data in a report, for example, to organize fields in order from A to Z.

A) Sort
B) Format
C) Edit
D) Query

Question 40

You need to create a report from an Access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?

A) Page numbers would included on the page footer section and the grand total would be included on the report footer section.
B) Page numbers would be included on the group header section and the grand total would be included on the group footer section.
C) Page numbers would included on the report footer section and the grand total would be included on the page footer section.
D) Page numbers would included on the report header section and the grand total would be included on the report footer section.

Question 41

A Label control displays the data found in a form's record source.

Question 42

It is helpful to sketch a form or report before creating these objects in Access.

Question 43

Providing a descriptive title for a report allows you to determine the information contained in the report based on the title.

Question 44

Print preview enables you to view how a printed report will appear before printing the report.

Question 45

Access provides themes that can be added to reports for an overall professional appearance.

Question 46

A report provides a professional, printed format of information contained in a database.

Question 47

Form view cannot be used to change the layout or design of a form.

Question 48

The layout control gives forms a uniform appearance by aligning form controls

Question 49

Multiple items forms display multiple tables in a tabular layout.

Question 50

Forms cannot show data from more than one table.

Question 51

The record source is the table or query that supplies the records to a form or report.

Question 52

A report's sort tools enable you to override the sorting contained in the report's record source.

Question 53

Mailing labels are preformatted reports that can be used with commercial label products.

Question 54

The data displayed in a bound control is different each time you switch to a new record.

Question 55

Split forms combine two views of two or more record sources.

Question 56

Design view displays the report's design while allowing you to view the report data.

Question 57

A Datasheet form is similar to a table or query's Datasheet view.

Question 58

You are more likely to edit the wrong record by mistake when using a form in access.

Question 59

After a form is generated by a Form tool, the form cannot be modified.

Question 60

Access can be used to create forms that match paper forms.

Question 61

Both forms and reports can contain bound, unbound, and calculated controls.

Question 62

You can remove the Detail section of a report by right-clicking any section bar and then clicking on the Detail section to remove it.

Question 63

________ view is used to modify the design of a form, but does not contain the more advanced features of design view.

Question 64

The properties of a form can be changed so a record cannot be deleted.

Question 65

In the Forms group, the Form tool creates a new blank form in Design view.

Question 66

A(n) ________ form combines two views of the same record source, displaying one section in a stacked layout and the other in a tabular layout.

Question 67

When you use the form tool to create a form, Access analyzes relationships between tables, and automatically adds a(n) ________, which displays records with foreign key values that match the primary key value in the main form.

Question 68

Unbound controls are text boxes that are connected to a table or a query.

Question 69

Layout view can be used to add or delete fields in the report.

Question 70

Gina is working in a database that stores employee data. Gina's boss wants her to design a form that will make a data entry easier. Her boss wants her to include the company name and logo on the form. Gina can add this information to the Form ________ section.

Question 71

Labels and Text Boxes are known as controls.

Question 72

A form that displays fields in a vertical column, and displays one record at a time is in a ________ layout.

Question 73

A (n) ________ form is replica of a table or query's Datasheet view but still retains form properties.

Question 74

The table or query that supplies the underlying data for a form or report is called the ________.

Question 75

Working with form sections is similar to working with report sections although reports have more sections than forms.

Question 76

A (n) ________ is a database object that is used to add data into a table.

Question 77

A(n) ________ form displays all fields from a record source in a tabular layout similar to a table's Datasheet view.

Question 78

The form tools are found in the Forms group located on the Create tab.

Question 79

A form that displays records horizontally, with label controls across the top and the data values in rows under the labels is in a ________ layout.

Question 80

The first steps for both designing a form and a report are sketching the form or report.