Access 1-4

You can use a form to ____.

add new records, delete existing records, or update the record source

When you change the row height of a datasheet, the change ____.

affects all the rows in a datasheet

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

best fit

Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

click the field selector and drag the column to a new location

Jessica wants to find and replace some data in her database. Please refer to the figure above as you answer the questions below. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.

contain only the letter S

Jessica wants to find and replace some data in her database. Please refer to the figure above as you answer the questions below. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

contain the letter S anywhere in the value

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

controls

A field's ____ determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text.

data type

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into two panes. In the bottom pane, you see a ____ that contains the form data.

datasheet

Used to identify the fields

field name

Appears at the top of each column in a table and contains the field name.

field selector

Jonathan is preparing a database of his favorite foods which is shown in Figure 1-1. It is his first time using a database and he is becoming familiar with the terminology. Jonathan will be sorting the database on "Specialty," which is a ____.

field selector

Jonathan is preparing a database of his favorite foods which is shown in Figure 1-1. It is his first time using a database and he is becoming familiar with the terminology. The word "Italian" is an example of a ____.

field value

The data entered into a field.

field value

Each record is made up of one or more of these.

fields

A DBMS is ____ than using file folders to manage data.

more flexible, more accurate, & much faster

The first step in creating a database is to create the file that will store the database ____.

objects

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

one, some, or none

Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

only if she saves them

Just like when you select a record selector in a datasheet, the record selector for a selected field in the design grid changes color to ____ when the field is selected.

orange

The ____ is the field that contains a unique field value for each record in the table.

primary key

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

prompt you to save your changes

A ____ selector appears to the left of the first field for each record.

record

A complete set of data.

record

You need to save a table only when you make changes to its layout, such as ____.

resizing columns

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

run

formats with a $ and a decimal

Currency

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

Datasheet view

Kristin has put together a list of job candidates for various positions within her company. In Figure 2-1, she needs to confirm the data type for one column and also set the primary key. The Appointment column has field values of the ____ data type.

Date/Time

stores the date or time

Date/Time

Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value. He is researching which Access properties will help him with his task. To set a default value that will automatically appear for some of the fields, Sam will use the ____ property.

Default Value

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

Design

In ____, you can add, delete, and make changes to the way that fields store data.

Design view

Shows every field in each record

Detail query

Zack wants to create a custom form to match a paper form that he uses everyday in the office. Please answer the questions below. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

Double-click a field in the Field List

After you delete a record, you can use the Undo command to restore it.

False

The Description property in the design grid is a required field property that you use to describe what to enter in the field.

False

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

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 create a blank database, Access creates the first table for you and gives it the name Database1.

False

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

False

The ____ sets the number of characters you can store in a Text, Number, or AutoNumber field.

Field Size property

Temporarily displays records in a datasheet based on the condition that you specify

Filter

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

Filter By Selection

A database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form

Form

The ____ section displays information at the bottom of each form.

Form Footer

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 tool

Zack wants to create a custom form to match a paper form that he uses everyday in the office. Please answer the questions below. 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

Kristin has put together a list of job candidates for various positions within her company. In Figure 2-1, she needs to confirm the data type for one column and also set the primary key. The ____ field would make the best primary key because there would never be two people with the same data in that field.

ID

When you create a blank database, the table that Access creates for you contains one field named ____.

ID

stores graphics, sounds and objects

OLE Object

Selects records that match at least one of two or more conditions in a query

Or operator

The tables or queries that contain the data used in a form

Record source

Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value. He is researching which Access properties will help him with his task. To make sure that a specific field is filled in and has data in it, Sam will use the ____ property.

Required

You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab.

Results

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

Lets you summarize relevant data, such as adding the field values in a column that stores price data

Summary query

allows letters and numbers up to 255

Text

A database is a collection of objects.

True

A field property describes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store or the allowable values that you can enter in the field.

True

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

True

Any changes that you make in Design view are automatically updated in Datasheet view when you save the table.

True

Forms have a Navigation bar that you can use to move between records.

True

In Design view, you can add, delete, and make changes to the way that fields store data.

True

The 3 sections of a form are the Form Header, Detail, and Form Footer.

True

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

True

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

True

When you open an existing database, the Navigation Pane opens on the left side of the screen.

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

A control that is not connected to a record source and is used to display information, lines, rectangles, and pictures

Unbound control

The ____ data type stores True/False values.

Yes/No

____ is a program known as a database management system (DBMS).

Access

Selects records that match two or more conditions in a query

And operator

gives a unique number to each record

AutoNumber

A control connected to a field in the record source and is used to display, enter, and update data

Bound control

____ a database rearranges how the database is stored on a disk and optimizes the performance of the database.

Compacting

allows you to choose a value from a list

Lookup Wizard

allows letters and numbers up to 65,535

Memo