Database Basics
Tables
Forms
Queries
Reports
100
A collection of related data, stored in an organized manner so that it can be retrieved later
What is a Database?
100
A set of facts or figures systematically displayed, especially in columns
What is a Table
100
Used to present a user friendly graphical interface for entering and altering data in a database.
What is a from
100
Way of selection only the records in a database that match certain criteria
What is a query
200
Business, Transport, Search, Online, Government
What are types of Databases?
200
Software in which spreadsheets can be made
What is Excel
200
CSV
What is Comma separated Values
200
AND, OR, and NOT used to combine criteria
What is Boolean Operators
200
Complex sets of Data from multiple tables, and queries laid out in an easy to understand format
What are requirements for a report
300
A field which is different for every record in that table
What is Primary Key?
300
Software in which you can either import spreadsheets, or make your own within the document
What is Word
300
TSV
What is Tab Separated Values
300
Query that prompts the user for a value when he query is run
What is Parameter Query
300
Ensuring the data is correct, relevant, and up to date
What is Data Integrity
400
Field which might frequently be used to search a table
What is Secondary Key?
400
Allows the user to specify requirements for each character of the input
What is Input Mask
400
A point where two systems, subjects, organizations, etc., meet and interact
What is an Interface
400
Parameter queries allow criteria to be specified at _____ rather than ____
What is run time rather than sign time.
400
The process of ensuring that data is in the correct format fro a particular field.
What is Data Validation
500
The process of creating a relational database which has no redundant data
What is Normalism
500
To avoide typing mistakes that may have occured when the data was entered.
What is Entering Data Twice
500
Clickable image object used with graphical operating systems
What is a Command Button
500
SQL
What is Structured Query Language
500
Validation is to checking data in the correct format as ______ is to checking data actually shown
What is verification
M
e
n
u