Quiz 3 Flashcards
Data
A collection of numbers and text
Table
A list of data organized into fields and records
Data type/Field type
Defines the type of information that can be stored. i.e. text, numbers, dates, etc.
DBMS
A DBMS is a collection of programs that enable you to enter, organize, and select data in a database.
Report
Structures for written output of data
Structured Query Language (SQL)
The language you use to talk to a database
Information
Meaning derived from data
QBE
MS Access 2010 supplies a graphical user interface (GUI) called the Query By Example Grid or (QBE) grid
Fields
A piece of a table containing data type
Foreign key
A field that defines a relationship between 2 tables.
1) Must be a primary key (unique) in at least one of the tables
2) The field names on each table do not have to match as long as the information is the same.
3) The related fields must be the same data type number, text etc.
Database
A large collection of data stored in a well-defined structure
Query
Question structures to sort, filter and select specific information
Used to extract information from a database
A request for information from a database
To extract information from the Database you must use a Query which is a “question” or “request”
Criterion
An expression that tells the DBMS which records to retrieve
Form
Structures for screen views of data
Structures for screen view and input of information
Used to simplify viewing and inputting of information
Primary Key
A field, or combination of fields, which uniquely identifies a record in a database
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
Cascade Delete Related Records
Removing any entry in a primary key field will automatically remove all entries in foreign key fields of related tables.
Cascade Update Related Records
Updating any entry in a primary key field will automatically update all entries in foreign key fields of related tables.
Requirements of a valid foreign key
1) Must be a primary key (unique) in at least one of the tables
2) The field names on each table do not have to match as long as the information is the same.
3) The related fields must be the same data type number, text etc.
Creation of dynasets
Dynaset only includes records that have matching keys on both tables. This is called an inner join which is the default join type in Access.
When you run the query a dynaset, or subset of the database is displayed.
You can make changes to this dynaset and the changes will be reflected in your database, because the dynaset is just a view of your database
Field Properties
– Field size
– Input Mask
– Validity
– Default Value
