BIM Ch 9 Vocab- MS Access

Created by arsimpson 

Upgrade to
remove ads

53 terms

Access

The Microsoft Office RDBMS application

Append

Adding data to the end of table

Ascending order

In order from lowest to highest

Attachment field

A field that stores a file

AutoNumber field

A field that automatically stores a numeric value that is one greater than that in the last record added

Boundary

The column borders in a table

Currency field

A field that stores dollar amounts.

Data Redundancy

Unnecessary data duplication.

Database

An organized collection of related data.

Database schema

A description of the data and the organization of the data into tables in a relational database.

Datasheet

The data for a table organized with fields in columns and records in rows.

Datasheet view

Used to display the basic structure of a table in a datasheet with fields in columns and records in rows.

Date/Time field

A field that stores a date or time.

Descending order

In order from highest to lowest.

Design view

The table view that shows the field definitions for a table.

Entry

The data for a field.

Field

A column in a table used to store data

Filtering

Displaying records based on a specified criteria.

Fixed

A field format that displays a value to a specified number of decimal places.

Form

A database object used for entering records into a table and for viewing existing records.

Form view

Used for entering records with a form.

Format

The way data in a field is displayed.

General number

A field format that displays a number exactly as typed.

Hyperlink field

A field that stores a link to a file, e-mail address, or Web site address.

Importing data

Converting a file created in one application for use by the receiving application.

Landscape orientation

A print setting that uses the widest part of the paper to print across.

Layout view

The view used for formatting a form.

Long form

A date/time format that displays data in a form similar to Friday, May 5, 2009 or 10:12:30 AM.

Long Integer

A field size that indicates a whole number.

Lookup field

A field that stores data retrieved from a field in another table.

Medium form

A date/time format that displays data in a form similar to 24-June-09 or 10:12 AM.

Memo field

A field that stores several lines of text.

Name

Word or words used to describe the data stored in a field.

Navigation Pane

Used to run, open, and manage the objects of an Access database.

Number field

A field that stores only numeric values.

Percent

A field format that multiplies the value entered by 100 and displays it with a percent sign.

Populating a database

Adding records to a database.

Portrait orientation

A print setting that uses the narrowest part of the paper to print across.

Primary key

A field in a table that is designated to contain unique data.

RDBMS

(Relational Database Management System) A software application that contains tools to manage data, answer queries, create user-friendly forms for data entry, and generate printed reports.

Record

A set of data for the fields in a table.

Record controls

Used for displaying a specific record in a form or for displaying a new, empty record. Located at the bottom of a form.

Record selector

The gray box to the left of each record in a datasheet.

Short form

A date/time format that displays data in a form similar to 6/24/09 or 10:12.

Single

A field size that indicates a number with a decimal portion.

Size

The number of characters or the type of number a field can store.

Sorting

Placing records in a specified order.

Standard

A field format that displays a number with a thousands separator, usually a comma.

Table

A database object that stores related data organized into rows and columns.

Text field

A field that stores characters (letters, symbols, words, a combination of letters and numbers) and numbers that do not require calculations.

Type

Field classification based on the data stored.

Updating

Modifying a record.

Yes/No field

A field that is either selected or not selected to represent yes/no, true/false, or on/off.

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