BCA Chapter 9
Card Set Information
BCA Chapter 9
Using a Relational Database
Used for displaying a specific record in a form or for displaying a new, empty rexcord. Located at the bottom of a form.
A set of data for the fields in a table.
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.
A field in a table that is designated to contain unique data.
A print setting that uses the narrowest part of the paper to print across.
Populating a database
Adding records to a database.
A field format that multiplies the value entered by 100 and displays it with a percent sign.
A field that stores only numeric values.
Used to run, open, and manage the objects of an Acess database.
Word or words used to describe the data stored in a field.
A field that stores several lines of text.
The Microsoft Office RDBMS application.
Adding data to the end of a table.
In order from lowest to highest. Also called alphabetical order when a sort is based on a text field and chronological when a sort is based on a date field.
A field that stores a file.
A field that automatically stores a numeric value that is one greater than thatin 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 the 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.