database - used to store information in tables, relational databases - many tables that can be linked, flat file database - has one table only, primary key - uniquely identifies each record in a table, foreign key - when the primary key in one table appears in another table, entity - be a single thing, person, place, or object, field - stores a single data item in a table, record - made up of individual fields that contain data about entities, query - used to filter and extract information from a database, forms - used to add, edit or delete data in a table, report - used to output data. can be created on tables and queries. , macro - software program that allows automation of repetitive tasks, import data - bring data in from another source, export data - send data out to another source, data type - determines the kind of data that will be stored, eg. a date or a time, boolean - yes or no value; true or false, captions - used to give 'proper English' names to field headings, data redundancy - unnecessary duplication of data in a database, data integrity - refers to the accuracy and consistency of data stored, field size - the number of characters needed for any field entry,

Database key terms

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?