Access Lesson 3 and 4

Menu that opens when you click the arrow on the right side a field selector.

AutoFilter

When a field displays a value that is calculated using other fields in a query, it is called a(n) _____.

Calculated field

A calculation of more than one field is called a(n) ____.

Expression

A matching field is also called a mirror field because it is common in both tables involved in the relationship.

False

An unbound control is connected to field in the record source and is used to display, enter and update data.

False

The Form Footer section displays information at the top of each form.

False

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

False

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

False

To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.

False

When you need to create a form to match a paper form that you are already using - or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard - can create a blank form in Query view.

False

When you run a query, the data in the table on which the query is based no longer exists in the table.

False

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

False

You must add fields in a certain order to the design grid.

False

The common field in the related table is called a(n) ____ when it is used in a relationship.

Foreign key

The ____ tool creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source.

Form

An easy way to create a query is to use the ___, which asks you what data you want to see by letting you select options in dialog boxes.

Simple Query Wizard

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

Sort & Filter

When you need to sort data first based on the values in one field, and then by the values in a second field, you can set the sort orders for the two fields using the ____ in the design grid.

Sort boxes

After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.

Toggle Filter

When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.

Total row

A filter temporarily displays records in a datasheet based on the condition that you specify.

True

A query is a database object that lets you ask the database about the data it contains.

True

In the Query Design window, you build and change the query using the query design grid.

True

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

True

Table, form and report objects in the database can have the same name.

True

To add a condition to a field, click in the field's Criteria box, and then type the condition.

True

When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.

True

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

True

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

True

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

True

The ____ operator selects records that match all of two or more conditions in a query.

and

When fields appear in a form, they appear in _______.

controls

In the bottom pane of the Split Form tool, you will see a _____ that contains the form data.

datasheet

To print all records in the form, click the ___ tab, click Print on the navigation bar, and then click Print to open the Print dialog box.

file

You can change the default font size, color, and style of the title text using the buttons in the Font group on the ___ tab.

format

To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ___ group.

forms

When you click the Find button in the Find group on the ___ tab, the Find and Replace dialog box opens.

home

In the Form Wizard, the _____ layout displays fields across the screen in the order in which they occur.

justified

The ___ symbol next to a field name in a field list indicates the table's primary key.

key

Queries that are based on more than one table are sometimes called _____ queries.

multitable

To add a new record, click the ___ button in the Records group on the Home tab to open a blank form.

new

A query can contain ___ of the fields in the table.

one, some and all

The _____ operator selects records that match at least one of two or more conditions in a query.

or

To remove one or more selected control from a control layout, ___ the control to open the shortcut menu point to Layout, and then click Remove Layout.

right-click

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

rulers

When you open a query object, you ____ the query.

run

You can also resize a control precisely by watching the lower-left corner of the ____ to use the width of the control in characters as you can drag it.

status bar

In the Form Wizard, the ___ layout displays fields with the labels at the top of a column that contains the field values.

tabular

If you do not see the Field List pane, click the Add Existing Fields button in the __ group on the Design tab.

tools

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.

unbound