Term
|
Definition
| Any organized collection of data |
|
|
Term
| What are 3 organizations who uses a database? |
|
Definition
School District, Government, Banks, Rewards Program, |
|
|
Term
| What are examples of databases? |
|
Definition
| Cookbooks, Contact Information,Online Shopping |
|
|
Term
| What makes Access Database different? |
|
Definition
| Relational Table Structure |
|
|
Term
| Why use Relational Structure? |
|
Definition
So you don’t have to renter information, storage is more efficient, improve accuracy |
|
|
Term
|
Definition
Something that links relational tables together. Primary Key is the original key |
|
|
Term
| What are some examples of a Transaction |
|
Definition
| Which students are in which classroom, who you loan an object to |
|
|
Term
| What are the first 3 steps in database design? |
|
Definition
Capture all the data you need to store, Identify repeated data, move it to its own table |
|
|
Term
|
Definition
| Where you store your data |
|
|
Term
|
Definition
| Ask questions of your data base |
|
|
Term
|
Definition
| Helps enter data quickly, give data base a finished look |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Similarites Between Excel and Access |
|
Definition
Both have columns and rows,Organize data,Sort/Filter |
|
|
Term
Differences Between Excel and Access
|
|
Definition
Access has relational tables,Queries and Reports Forms |
|
|
Term
| What are Records in a Database? |
|
Definition
| A row, has all of the data |
|
|
Term
What are Fields in a Database?
|
|
Definition
A column, single piece of data |
|
|
Term
|
Definition
| The structure of your data (text, number, date/time, hyperlink, etc.) |
|
|
