Next week, Excel Exam

Microsoft Access

Why? (Compared with Excel)

* more secure
* faster
* smaller
* more powerful
* more features

Database: stores your data, gives you ways of accessing your data, querying your data, changing your data

Database: a bunch of tables
Table: a bunch of records
Record: a bunch of fields
Field: col, or actually just one unit of data

Query: SQL:
select first, last, salary from Customers where Age >= 34 order by last

Also, query designer in Access

Forms: to view and edit your data
Reports: for printing
Macros: programming

Homework:
Ch 1, practice exercise 2, custom coffee
If you cannot do step j, don't worry about it.

Also, think to your major. Make an Access database, with the following tables. Eventually you are going to link them. Tables to make:
* Faculty
* Students
* CourseCatalog
* Rooms
* Spring2012
* The_Name_of_One_Specific_Course

Figure out which will be primary keys and which will be foreign keys. Don't put too much into the data. Think 3 to 5 records for each.