Access chapter 3

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Layout view

Allows you to make changes to a form or report with the data displayed in the fields

From view

Allows you to view, modify, delete records or add to the records in a table

Since the data in a text box comes from a field in a table or query, a textbox control is referred to as a(n) ______ control.

Bound

When a report is displayed in layout view and you want to apple a theme to it, ______.

Click themes in the themes group, under report layout tools on the design tab.

Calculated

Control that contains an expression that most often summarizes a field that contains numerical data

Label

Control that contains descriptive information

Unbound

Control that does not have a source of data

Bound

Control that retrieves it's data from a field in an underlying table or query.

Design view

Displays the detailed structure of a query, form, or report.

True or false. The AND condition displays records that match at least one of the specified values.

False

True or false. The form tool gives more flexibility in the design, layout, and number of fields in a form than from the wizard.

False

True or false. The report wizard is the fastest way to create a report.

False

True or false. The techniques and tools for modifying the design of a report created using the Report Wizard are different from those used to modify the report created with the Report tool.

False

True or false. When using a form, you can remove a record from a table by right-clicking the record, and then clicking Delete.

False

True or false. When viewing a report in layout view, clicking Group & Sort in the Grouping & Totals group on the DESIGN tab opens the Group, Sort, Total dialog box

False

A ____ is a database object used to enter new records into a table or to edit, delete, or display existing records in a table.

Form

What is NOT a source of information for a report?

Information from a report

Text box

Most commonly used control

True or false. Data entry refers to the process of inputting the actual records into a database.

True

True or false. Filtering records in a form displays only a portion of the total records based on matching specific values.

True

True or false. In the relationships window, double-clicking a join line displays the Edit Relationship dialog box.

True

True or false. Queries or tables that provide the underlying data for a report are referred to as the report's record source

True

True or false. The report wizard is used when more flexibility is needed in the design of a report.

True

True or false. While in layout view, you can remove a control from a report by right-clicking Delete

True

Form tool

Used to create a form with a single mouse click, which includes all of the fields from the underlying data source

Form wizard

Walks you step by step through the creation of a form

You can create a form using the form _____, which walks you step by step through the creation of the form.

Wizard


Set pelajaran terkait

MS2- Musculoskeletal- NCLEX-RN Book

View Set

Florida 2-40 health exam chapter 4

View Set

Chapter 19: Speed, Agility, and Quickness Training Concepts

View Set

Texas Principles of Real Estate 2 - Chp. 3 Real Estate Financing Principles

View Set

Common Birth Defects Practice questions

View Set

Ch 08: Security Strategies and Documentation

View Set

Religious pluralism and theology

View Set