Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
|
Access
|
Microsoft Office program for databases
|
|
|
Alphanumeric
|
A combination of letters and numbers
|
|
|
Boolean
|
The use of terms AND OR NOT to query a database
|
|
|
Check digit
|
The last digit which is created as a redundancy check that the other digits are correct
|
|
|
Data collection/capture
|
Getting data from data entry forms manual input import
|
|
|
Database Management System
|
Complete database system including storage retrieval and updating querying
|
|
|
Field and *
|
A portion of a record which contains data -- * is required field entry
|
|
|
Flat file database
|
A series of file folders that you cannot relate data from one folder to another
|
|
|
Format
|
Field formats such as currency Y/N time
|
|
|
Format check
|
To see if contents of a field follow the required formation
|
|
|
Key identifier
|
A field with a unique number in a series of records
|
|
|
Length check
|
To make sure the field is populated with the correct number of characters
|
|
|
Query
|
The feature which searches a database to obtain results
|
|
|
Range check
|
To make sure the field is populated with the correct range of characters
|
|
|
Record
|
A series of fields that are related to one person object
|
|
|
Relational database
|
Records in a database that have more than one table to related to another table
|
|
|
Report Generation
|
To create a report from a query of the database
|
|
|
Structured Query Language (SQL)
|
Queries leave the DBMS responsible for planning optimizing and performing and producing the results
|
|
|
Table
|
Part of database which maintains relationships between key identifiers from other tables
|
|
|
Validation
|
To make sure the data complies with different checks of integrity (range check
|
|
|
Verification
|
To make sure that results obtained are based on correctness of data (i.e. no data redundancy)
|
