quiz 3 next tues

from last end of chapter 8 in New Perspectives Book
probably: ch 6, 7, 8

Ada_Lovelace first computer programmer
for Babbage's analytic engine

Practice Access Exam 1.
Practice Access Exam 2.
Access Review Presentation.


Access practice exam files.

UPDATE Positions
Set Salary=Salary + Salary*10%
Where Salary <= 50000

Query design:

1) select table or tables
2) select fields
3) set criteria
4) set sorting order

SELECT Positions.Title, Positions.Description
FROM Positions
where salary>30000

SELECT Positions.Title, Positions.Description, Positions.Salary
FROM Positions
ORDER BY Positions.Salary;

there is a like operator
where
author like "G*"

like "J?sh"

usually on a test
begins with
ends with
contains

G*
*g
*g*

Web Page Assignment

The web page assignment is due the day of the final exam.
Use a simple text editor. Not Frontpage, Dreamweaver.


Your web site should include: lists (UL, LI, OL, images, tables, bold, colors, paragraphs, etc.)


All the files and directories making up your web pages assignment must be within the public_html directory of your UNIX account. The filename of your main web page must be called index.html and located directly in the public_html directory of your UNIX account. Your web page assignment has to have at least the following:

• Pictures - Create a directory called pictures in your public_html directory. Don't forget to set the proper permissions for the pictures directory. Place all of the image files (pictures) you are using in all of your web pages in the pictures directory.
• About me - Create a web page (html file), in your public_html directory, describing yourself. Include a "photo", real or imagined, of yourself on this web page. Create a link to this web page in your main web page (index.html).
• My family - Create a web page (html file), in your public_html directory, describing your family. You can link to their web pages from there or include scanned pictures if you like! Create a link to this web page in your main web page (index.html).
• My friends - Create a web page (html file), in your public_html directory, describing your friends. You can link to their web pages from there or include scanned pictures if you like! Create a link to this web page in your main web page (index.html).
• My hobbies - Create a directory called hobbies in your public_html directory. Don't forget to set the proper permissions for the hobbies directory. Create a web page (html file), in the hobbies directory, that describes your hobby. Provide links to at least 2 web sites that deal with your hobby and you can put pictures there too. Create a link to this web page in your main web page (index.html).
• Queens College - Create a link to the college's main web page in your main web page (index.html).

Be Creative!!!

Experiment!!!

Make it look nice!!!

did ch 8
lossless vs lossy compression

msaccess
language: SQL

query
SELECT
INSERT
DELETE
UPDATE

CREATE TABLE
DROP TABLE


Select * From Courses

Select section, days, time, room From Courses

Select section, days, time, room From Courses
Where days='Tue Fri' AND
(time = '8:15 -- 9:05 am'
OR
time='10:15 -- 11:05 am')

INSERT INTO Positions (Title, Salary, Description)
Values ('TA', '1000', 'student teacher')

Delete * From Positions where PID=4

Comprehensive HWs (so far) to hand it
1) New Perspectives Labs at end of each chapter
2) Screenshot of anything
3) Codecademy (screenshot of progress at end of semester)
4) Grauer Excel, practice exercises ch 1 and ch 2
5) Writing a UDF (user defined function in Excel)
6) Intermediate web project 1
7) Create and submit toy database

=IF(H3>=100, 105, Average(E3:G3))
=IF(h3 = "yes", Average(E3:G3, 100), Average(E3:G3) )