Access Terms Flashcards
Meaning derived from the data
Information
A collection of numbers and text
Data
A large collection of data stored in a well-defined structure
Database
A collection of programs that enable you to enter, organize, and select data in a database
DBMS
An entity used to organize information by categories of like information
Table
An attribute (piece of information) of the table/entity
Field
Defines the type of information that can be stored. i.e. text, numbers, dates, etc.
Data type / field type
A field, or a collection of fields, whose values uniquely identify each record in a table
Primary key
Referential data integrity
A set of rules that specifies what records may exist in each table
–A record input with a foreign key must always have a matching record in the primary key table in the relationship
Question structures to sort, filter and select specific information
Query
Structures for screen views of data
Form
Structures for written output of data
Report
The language you use to talk to the database
Structured Query Language
QBE grid
Query by example grid
A field that defines the relationship between 2 tables
Foreign key
Relationship rules
•Must be a primary key (unique) in at least one of the tables
•The field names on each table do not have to match as long as the information is the same.
•The related fields must be the same data type
– number, text etc.
Removing any entry in a primary key field will automatically remove all entries in foreign key fields of related tables
Cascade delete related records
Updating any entry in a primary key field will automatically update all entries in foreign key fields of related tables
Cascade update related records
Related information input into the table
Group of fields
Record
Hierarchy of data in a database
File Table Record Field Data type or Field type (also field properties)
