Lesson 1-3
_______ ____ sorts data from beginning to end, such as from A to Z, 1 to 10, and January to December.
Ascending Order
The ____ command applies a predefined color and font scheme to a form or report. A ____ modified es a form by controlling the color and fonts of its text. In this exercise, you apply a ____ to a form.
Theme
- A ______ is an object that displays data, performs actions, and lets you improve the look and usability of a form or report. Access uses three different types of controls: bound, unbound, and calculated.
Control
______________ creates a customization form that displays multiple records.
The Multiple Items tool
A ______ is a set of rules for determining which records will be displayed.
Filter
You can set______ that control the appearance or behavior characteristics for an entire table in the table’s____ sheet
Properties
Controls are arranged vertically in a , with a label on the left and the control on the right.
Stacked layout
A ________ gives you two views of your data at the same time—in both Form view and Datasheet view.
split form
were introduced in Access 2010 and consist of predefined templates that you can add to an existing database to help extend its functionality. Another way to create a table is to copy the structure of an existing table and then paste it into the database
Application Parts
Another method of building a form is to use the _____ _____ tool. The _____ _____ allows you to select the fields that will appear on the form, choose the form layout (which determines the positioning of controls, objects, and data on a form), and also choose a predefined style, if desired
Form Wizard
). A _____ is the most basic type of Access query. It creates subsets of data that you can use to answer specific questions or to supply data to other The Bottom Line © sean mcdermid/iStockphoto Create and Modify Queries 181 database objects such as forms and reports. The data is displayed in Datasheet view without being changed. A query is a powerful and versatile database tool. Queries differ from sort or filter commands because they can be saved for future use and can utilize data from multiple tables or other queries. .
select query
A ________ is a form that is inserted into another form.
subform
In Access 2013, the process of creating a new database is easier than ever. You can create a database using one of the many available templates (ready-to-use databases that contain all of the tables, queries, forms, and reports needed for performing specific tasks) or by creating a new blank database
template
In Office Access 2013, it is possible to create a ______________ _________field that lets you select more than one choice from a list, without having to create a more advanced database design
Multi-valued Lookup field
is a row inserted at the bottom of a table that provides a menu of functions for each column in the row. .
The Total row
The__________ is called the main form , and the form within the form is called the subform.
primary form
________ _______ is an option that you can select in the Edit Relationships dialog box to prevent orphan records.
referential integrity
____________ specifies the text in the error message that appears when a user violates a ___________ rule. For example, the error message could say “Please enter a date that is later than June 4, 1977.” The maximum length for the__________ ________ property is 255 characters.
Validation text
Not all ______ must include criteria, but if you are not interested in seeing all the records that are stored in the underlying record source, you can add criteria to a query when designing it. A query criterion is a rule that identifies the records you want to include in the query result.
queries
the Application Parts gallery consists of two categories, ________ and Quick Start. The Blank Forms category contains a collection of 10 form parts that allow you to add predefi ned forms to a database. In this exercise, you create an Application Parts Blank Form and populate the form with bound controls using the Field List.
Blank Form