Advertisement Upgrade to remove ads

Blah Blah Blahhh

Exact Match

The condition that requires a value in a specified field to be identical to the specified condition is called a(n)

Show

You can tell if a field will appear in the query datasheet if there is a check mark in the field's ________check box in the design grid.

Drag

To include a field in a query, you can click and _______the field from the field list to the design grid.

Navigation

In a form with a main form and a subform, there will be two sets of _________________ buttons for use in selecting records from each of the tables.

Report Wizard

The Access feature that can guide you through the creation of a report by asking questions is called the _____________.

Related

When creating a form based on two tables, you create a subform for data from the _____ table.

Common Field

When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _______________that exists in both tables.

Home

To open the Find and Replace dialog box, click the Find button on the ________tab.

External Data and Import

You can import a table from another Access database into your current database using the ____________ tab of the ________ group on the Ribbon.

Navigation Pane

A defined query for an open database can be selected by double-clicking in the _______________ of the Database window.

Primary

When creating a form based on two tables, you create a form for data from the ________ table.

Main

Forms for tables that have a one-to-many relationship will have a(n) _________form and a subform

Relationship

To create a form based on two tables, you must first define a(n) ___________ between the two tables.

Query1

The default query name is __________.

Icon

Each object in the Navigation Pane has a unique_____to indicate the type of object.

Number

If you have a Customer ID field with values like 1234, you should use the _________data type.

Primary Key

In a given table, a field is defined as a(n) ____________ when its values uniquely identify each record in the table.

External Data

You use the ____________________ tab if you want to import data from an Excel worksheet.

Count

The aggregate function, _______, returns the number of the non null field values in a selection of records.

Wildcard

A pattern match uses _________ characters.

Related Table

If a form shows two forms of two different tables, the bottom form is for the _________.

#

If you only know the first or last part of a numeric value, use the ___ character when searching.

?

The _____ character will match any single alphabetic character

Object

A form is a(n) _______ that you can use to maintain, view, and print records in a database.

Johns*

To find the names of Johnson, Johnston, and Johnstone in form records, use _____.

Datasheet

To delete a record, select the record in ________ view

Join

You can use a common field to create relationships between tables by performing a(n) ____.

Design Grid

The fields and selection criteria for a query are included in the __________.

Between..And

A range of values may be specified as selection criteria by using the __________ operator.

Comparison

Operators used in selection criteria in a query, such as equal, not equal, or greater than, are known as ___________ operators.

Descending

When you sort a field with a Yes/No data type in _________ sort order, the no values display first, followed by the yes values.

Integrity

Reference _______ is a feature built in to Access to prevent data inconsistency in related tables.

One-to-many

The ____________ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table.

And

The ____ operator will cause a record to be selected only if two or more conditions are satisfied.

Logo

To add a picture to a form, click the ____ button.

Layout

To just modify a form's style, you would first change to _____ view

None of the above

An example of a relational Database is
________________.

Run

To see the results of a query, you must ____ it.

Temporary

When a query is run, the datasheet contents are ________.

Wizard

Access can guide you through the steps to create a query by using the Query ____.

255

The maximum size of a Text data type is ___ characters.

Must contain a unique value for each record within a table

A primary key ____.

None of the above

A relational database management system is a collection of ____________

Aggregate Function

Statistical information, such as totals and averages, can be calculated in a query by using a(n) ________________.

Infinity

The join line for a one-to-many relationship will show the ________ symbol on the "many" end of the line.

False

You cannot update data while viewing a query datasheet

False

In a one-to-many relationship, the primary table is the "many" table.

False

Multiple selection conditions can be specified in a query by using relational operators.

False

The F5 key is a toggle that you use to switch between the Table Design grid and the Field Properties pane

False

Access allows you to change a field size in Datasheet view.

False

You can import a table from another Access database into your current database using the Import button on the Ribbon.

True

Aggregate functions perform arithmetic and statistical operations on selected records.

True

The Navigation Pane divides database objects into categories, and each category contains groups

True

A single set of field values within a table is a record.

True

A database is a collection of related tables.

False

Access allows you to modify a table structure in Datasheet view

True

Access can determine what data type to assign to each field based on the values you enter for the field. If the values entered do not provide enough information for Access to guess& the data type, the default type assigned is the Text data type.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set