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.

The wayback machine.

archive.org

www.bugmenot.com

www.retailmenot.com

google drive (google docs)

google groups (Usenet and more)

google books

google translate

* Goal Seek
* Solver
* Pivot Tables
Import / Export
* Macros
* VBA
* UDFs
* Express edition VB.NET Visual Studio

* CS courses
http://www.cs.qc.cuny.edu/

http://venus.cs.qc.cuny.edu/~ryba/

google reader
rss feed (XML) - extensible markup language

project gutenberg

Walkthru, Excel exams

Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.

PracticeExamFiles.zip

grace hopper, debugging

relative vs. absolute references, naming cells, mixed references

Homework:
Excel, ch 2, practice exercise 1

to submit homeworks, send to joshwaxman@gmail

colon operator
comma operator
space operator

http://www.ubuntu.com/download/desktop Homework: excel, chapter 1, practice exercise 1, midlevel exercise 3 Also for homework: Make up a bunch of temperatures. Convert them from F to Celsius, Kelvin, and Rankine http://en.wikipedia.org/wiki/Celsius

openoffice
libreoffice

http://www.snopes.com/

spybot search and destroy
http://www.safer-networking.org/

Quiz 2:

Quick-checks at the end of chapters 2 and 3 in lecture book
Multiple choice at the end of ch 3 in Grauer lab book