INSERT INTO BOOKS

(ISBN, Title, Author, Publisher)

VALUES

("111", "C++ Recipes", "Josh Waxman", "Waxman Books")

UPDATE BOOKS

Set

ISBN="444"

Where Author="Josh Waxman"

UPDATE BOOKS

Set

ISBN=ISBN & " 2nd Edition"

Where Author="Josh Waxman"

Delete * From Books

Where Author="Josh Waxman"

CREATE TABLE

http://msdn.microsoft.com/en-us/library/bb177893(v=office.12).aspx

Quiz on tuesday, dec 6

next chap in book

material up to Nov 17th

read ch 8 book.

Final on 22nd, 6:30-8:30, here, in C205

SUMMARY QUERIES

Group by Clause

SELECT Publisher, AVG(ListPrice) As AveragePrice From BOOKS

GROUP BY Publisher

Select [Last Name], [First Name], Salary+Bonus As TotalSalary

from Employee

Calculate field

Split form

Form/SubForm

you need a defined relationship

There are two types of Macros.

Macros are USUALLY VBA

Access does have VBA

But they also have "Macros"

a few interesting Algorithms

Bubble sort

n elements i want to sort

each time, i do about n comparisons

i need to repeat it about n times

n squared

O(n^2)

Sorting machines