Database Management MC

Created by jessica_dubee 

Upgrade to
remove ads

In a ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

relational

A unique identifier also is called a(n) ____ key.

primary

Each field has a data ____, which indicates what can be stored in the field.

type

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

auto number

Fields whose data type is Number often require you to change the field ____, which is the storage space assigned to the field by Access.

size

The ____ contains a list of all the objects in the database. You use this to open an object.

navigation pane

You work on objects such as tables, forms, and reports in the Access ____ area.

work

____ orientation means the printout is across the height of the page.

landscape

Database ____, also known as metadata, can include such information as the file's author, title, or subject.

properties

The simplest approach to recovery involves periodically making a copy of the database (called a ____ copy or a save copy).

backup

When you use ____, usually you are looking for those records that satisfy some criterion.

queries

The ____ wildcard symbol represents any individual character

question mark

Unless you specify otherwise, Access assumes that the criteria you enter involve ____.

equality

Often you will have more than one criterion that the data for which you are searching must satisfy. This type of criterion is called a ____ criterion.

compound

In a(n) ____ criterion, each individual criterion must be true in order for the compound criterion to be true.

and

If you want to create a criterion involving a range of values in a single field, you can use the ____ operator.

and

To order the records in a query result in a particular way, you ____ the records.

sort

A property sheet is a window containing the various properties of the object. To omit duplicates, you will use the property sheet to change the Unique Values property from ____.

no to yes

Common delimiters include all of the following EXCEPT ____.

tags

____ means creating groups of records that share some common characteristic.

grouping

If your criterion involves more than one field, use Filter By ____.

form

If your criterion for filtering is that the value in a particular field matches or does not match a certain specific value, you can use Filter By ____.

selection

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To do so, click the ____ for the field and then drag the field to the new location.

row selector

When you create a database, you define its ____; that is, you assign names and types to all the fields.

structure

A field that can be computed from other fields is called a ____ field.

either a or b

A ____ query will delete all the records satisfying the criteria entered in the query.

delete

An ____ query adds a group of records from one table to the end of another table.

append

A(n) ____ value is a value that Access will display on the screen in a particular field before the user begins adding a record.

default

You can use the ____ operator to specify a range of values

between

It is possible to include totals and other statistics at the bottom of a datasheet in a special row called the ____ row.

total

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