BIM Ch 9 Vocab- MS Access
The Microsoft Office RDBMS application
Adding data to the end of table
In order from lowest to highest
A field that stores a file
A field that automatically stores a numeric value that is one greater than that in the last record added
The column borders in a table
A field that stores dollar amounts.
Unnecessary data duplication.
An organized collection of related data.
A description of the data and the organization of the data into tables in a relational database.
The data for a table organized with fields in columns and records in rows.
Used to display the basic structure of a table in a datasheet with fields in columns and records in rows.
A field that stores a date or time.
In order from highest to lowest.
The table view that shows the field definitions for a table.
The data for a field.
A column in a table used to store data
Displaying records based on a specified criteria.
A field format that displays a value to a specified number of decimal places.
A database object used for entering records into a table and for viewing existing records.
Used for entering records with a form.
The way data in a field is displayed.
A field format that displays a number exactly as typed.
A field that stores a link to a file, e-mail address, or Web site address.
Converting a file created in one application for use by the receiving application.
A print setting that uses the widest part of the paper to print across.
The view used for formatting a form.
A date/time format that displays data in a form similar to Friday, May 5, 2009 or 10:12:30 AM.
A field size that indicates a whole number.
A field that stores data retrieved from a field in another table.
A date/time format that displays data in a form similar to 24-June-09 or 10:12 AM.
A field that stores several lines of text.
Word or words used to describe the data stored in a field.
Used to run, open, and manage the objects of an Access database.
A field that stores only numeric values.
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.
A print setting that uses the narrowest part of the paper to print across.
A field in a table that is designated to contain unique data.
(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.
A set of data for the fields in a table.
Used for displaying a specific record in a form or for displaying a new, empty record. Located at the bottom of a form.
The gray box to the left of each record in a datasheet.
A date/time format that displays data in a form similar to 6/24/09 or 10:12.
A field size that indicates a number with a decimal portion.
The number of characters or the type of number a field can store.
Placing records in a specified order.
A field format that displays a number with a thousands separator, usually a comma.
A database object that stores related data organized into rows and columns.
A field that stores characters (letters, symbols, words, a combination of letters and numbers) and numbers that do not require calculations.
Field classification based on the data stored.
Modifying a record.
A field that is either selected or not selected to represent yes/no, true/false, or on/off.