access

organized collection of related data.

A database can best be described as a(n)

short text

A field called ZipCode should be assigned the _____ field type.

entering

A form is a database object used primarily for _____ records in a table.

tables

A query extracts data from one or more

form

Access allows you to enter data in a table or a

populating

Adding records to a database is sometimes referred to as _____ the database.

tables or queries

An Access report is based on related

queries

An Access report presents data from a combination of one or more tables and

it automatically updates whenever changes are made to the data in those objects.

Because an Access report is linked to the objects used to create it,

has a different background color.

By default, every other row in a datasheet

run

Click the _____ button in the Results group on the Query Tools Design tab to display the query results in a datasheet.

table

Microsoft Access uses an object called a _____ to enter and organize data.

create

On which tab will you find the Report button?

over and over again

Once you create a query in Access, you can run it

Creating a query is quick and useful when you only need to see a subset of data once.

Which of the following is not one of the advantages identified in Chapter 3 of creating a query instead of just filtering data?

Save the data as an Excel workbook.

Which of the following is not one of the steps outlined in Chapter 2 for copying data from Microsoft Word into an Access table?

documents

Which of the following objects would not be listed in the Navigation pane when you open an Access database?

report

Which of the following rows is not part of the query design grid?

AutoNumber

Which type of data field is often used to store record IDs?

to pull data from one or more tables

Why would you use a query?

left-and-right-pointing arrow

You can adjust the size of all the fields in a form by hovering the mouse pointer over the right border of a field until it becomes a _____ and then dragging the border to the desired size.

Alternate Row Color arrow in the Text Formatting group

You can change the background color of every second row by clicking the _____ on the Home tab and then selecting a different color.

gridlines

You can change the gridlines that display in a datasheet by clicking the _____ button in the Text Formatting group on the Home tab.

Report Layout Tools Page Setup

You can change the page layout using the options on the _____ tab.

form view

You can enter records into a form from

enter records into a form

You can use options on the Form Layout Tools Design tab to do all of the following except

see how many records are available for viewing.

You can use the Record Navigation bar to

ctrl+c

You can use the keyboard shortcut _____ to copy the contents of all the fields in a record.

query design grid

You have more options and more control if you create a query using the

Filter button in the Sort & Filter group

If you have a table of customers and you want to display the records of only those people who live in a certain city, you should click the _____ on the Home tab.

Sort cell, click the Sort arrow, and then click Ascending

If you want the names in a query to be listed from A to Z, click the _____ for the Last Name field in the query design grid.

R* in the Criteria row of the Name field.

If you want to list people whose names begin with R in your query, type

save it as a PDF

If you want your report to look the same even on computers with different versions of Microsoft Access, you should

filters

In Access, you can print all the following except

column of data

In a relational database, each table is usually related to at least one other table in the database by sharing a

left-and-right pointing arrow with a vertical line in the middle

To widen a column so it displays all the data, hover the mouse pointer over the right border until the pointer changes to a _____ and then double-click.

saved with the database.

Unlike a filter, a query is an object and therefore

format

Use options on the Form Layout Tools _____ tab to change the font size and font style.

><

Which of the following is not a valid relational operator?

formula

Which of the following is not an Access database field type?

fields

A collection of related _____ makes up a record. Correct!

all access objects

If a form does not display in the Navigation pane, click the down-pointing arrow in the Navigation pane header and then click _____ in the drop-down list.

all the records in the State column

Suppose that you have a customer table containing a field called State. If you click the first record in the State column and then click the Align Left button in the Text Formatting group on the Home tab, what record(s) will the formatting be applied to?

record navigation

The _____ bar displays at the bottom of the form.

query wizard

The _____ pulls data from fields that you choose.

report layout tools design

The _____ tab contains formatting options you can use to add a theme to your report.

entry

The data value for a field is called a(n)

find records that meet a certain condition.

The purpose of creating a query is to

click the single right arrow button (>).

To add a field to a query, click the field name in the Available Fields list box and then

ascending

To alphabetize records by last name from A to Z, click the _____ button.

create

To create a form, click the Form button in the Forms group on the _____ tab.

table design

To create a new table in Design view, click the _____ button in the Tables group on the Create tab.

criteria

To create a query that displays records for only those people who live in a specific zip code, enter that zip code in the _____ cell for the Zip field on the query design grid.

delete record

To delete a record from a table, locate the record, click the gray record selector bar, click the Delete arrow on the Home tab, and then click the _____ option in the drop-down list.

database with several tables

To display a list of relationships in a _____, click the Relationships button in the Relationships group on the Database Tools tab and then click the All Relationships button.

primary key

To prevent having duplicate entries in a field, assign a(n) _____ to the field.

toggle filter

To redisplay all records after viewing only filtered records, click the _____ button on the Home tab.

remove sort

To return sorted data to its original order, click the _____ button.

View arrow in the Views group on the Home tab.

To see what your report will look like when printed, begin by clicking the

query

To select data that meets a set of criteria, you should use a

tab at the top of the object.

To switch to another open Access object, click the

a new blank form displays

What happens if you press the Tab key after you enter data in the last field of a form?

sort it

What is the best way to arrange database information in alphabetical order?

255

What is the maximum number of characters a Short Text field can store?

to provide options for inserting and changing the order of fields

What is the purpose of the Form Layout Tools Arrange tab?

clicking the single left arrow (<) button.

When building a query with the Query Wizard, if you accidentally add a field you did not mean to add, you can deselect it by clicking the field name in the Selected Fields list box and then

description

When creating a new field in a table, including an entry in the _____ column is optional.

copy the entire existing record and then make the necessary changes.

When creating a new record that is almost identical to an existing record, it is best to

show table dialog box

When creating a query using the Query Design button, you choose the table at the

tab

When entering data in a table or form, use the _____ key to move to the next field.

because Access automatically saves records

When entering data into a table, why do you not have to save the table before closing it?

the tab key

When entering data into an Access table, press _____ to move to the next field.

field of data

When the tables in an Access database are referred to as related, it means they have a common

a join line

When you add two tables to a query, what appears between their common fields?

query design grid

When you are creating a query in Design View, a _____ displays at the bottom of the screen.

edit

When you create a form, the ribbon displays three Form Layout Tools tabs. Which of the following is not one of those tabs?

layout

When you create a new form, it displays in _____ view.

saves it as an object in the database.

When you create a query, Access

Report Layout Tools Design

When you create a report with the Report button, the _____ tab becomes active.

Access saves the data automatically.

When you enter data in a form,

Open the query to view information

When you have completed the setup of your query and want to see the results, select the option _____ and then click the Finish button.

form

When you open a form from the Navigation pane, it displays in _____ view.

the navigation pane

When you open an Access database, what do you see?

records in the related form are not sorted.

When you sort records in a table,

design

When you use the Form Design button to create a new form, it displays in _____ view.

layout

When you use the Report button to create a report, the report is displayed in _____ view

in the queries group on the create tab

Where is the Query Wizard button located?.

AutoNumber

Which field type automatically stores a number that is one greater than the last number used?

form

Which of the following Access objects provides a user-friendly data entry method?

short text

Which of the following field types allows you to set a maximum field size to prevent data entry errors?