How can we help?

You can also find more resources in our Help Center.

53 terms

BIM Ch 9 Vocab- MS Access

STUDY
PLAY
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.