Excel vs. Access
We would use this type of program for data analysis, rather than data management.
What is Excel (or other spreadsheet program?
A computer system that organizes and stores data so that it can be useful at a later point in time.
What is a database?
This uniquely identifies a record in a database.
What is a primary key?
This element of a database stores fields and columns of data.
What is a table (or entity in an ERD?)
This type of program allows multiple users to access store and manage data.
What is Acccess (or a elational database management system)?
We sometimes refer to this type of document as a "flat file" as it relates to databases.
What is a spreadsheet?
This is also called a referencing key and links two tables (or entities) together.
What is a foreign key?
This part of database represents a single row of data/information in a table.
What is a record?
With this program, there is more risk of losing or compromising data.
These are the four types of objects in Access.
What are tables, queries, forms and reports?
In a database, this element represents categories of information such as "Name" or "Address"
What is a field (or attribute in an ERD?)
This program is best for asking more complex queries of the data.
What is Access?
The purpose of this Access object is to give the user a "friendly" way to enter or view data.
What is a form?
This program is better for straightforward mathematical/logical queries.
What is Excel?
In this type of network relationship, a computer (such as a desktop) connects to another larger computer that acts as a kind of engine to deliver programs.
What is a client-server network?