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

In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?