link to description of web page assignment.

Practice Access walkthroughs

#1


and #2

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


Access practice exam files.





SELECT Balance, AID, BID, CID
FROM Accounts
WHERE Balance > 10000 OR
BID="B30"

SELECT Balance, AID, BID, CID
FROM Accounts
WHERE Balance > 10000 OR
BID="B30"
ORDER BY Balance

SELECT Accounts.AID, Accounts.CID, Accounts.BID, Accounts.Balance
FROM Accounts
WHERE (((Accounts.BID)="B50"))
ORDER BY Accounts.AID;

Select * From Accounts, Branch
Where Accounts.BID = Branch.BID

called an INNER JOIN

SELECT Customers.LastName, Customers.FirstName, Accounts.Balance, Branch.Location, Accounts.OpenDate
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BID) ON Customers.CID = Accounts.CID
WHERE (((Accounts.Balance)<=2000) AND ((Accounts.OpenDate)>=#1/1/2007#));

Select * From Accounts, Branch, Customers
Where Accounts.BID = Branch.BID and Accounts.CID = Customers.CID

the only one able to view a cookie is the website that wrote the cookie

embed advertisements from other sites in a website

3rd party cookie


http://www.cs.qc.cuny.edu/fulltime.php


Database: collection of tables and means of dealing with that data.
Table: collection of records
Record: collection of fields
Field: a single unit of data

start access: msaccess
access must have a database file to work against
changes to your data automatically save
no undoing in access

back up their databases regularly

Create/ Table design
data vs. meta-data


redundancy
inconsistent data


solution:
relational database
primary key, foreign key

course index spring 2012
http://www.cs.qc.cuny.edu/schedule/sp12/sp12.htm

Goal seek
 good, but limited
  -- can only set the target cell to a specific value
  -- can only fiddle with one other cell
  -- no constraints
Solver
http://cs101.wvu.edu/media/1/10/19/35/Excel_Chapter_8.pdf

Pivot Tables

Text to Columns

in excel
hidden programming language
called VBA
visual basic for applications

imperative programming languages
Alt-f11: VBA editor
Ctrl-G immediate window
? means print

? 5
 5
? 5 + 2
 7
? 50 + 100 / 2
 100
? "Ryan"
Ryan
? Len("Ryan")
 4
myName = "Josh"
? myName
Josh


Excel Exam
Sun, Apr 22

First Web assignment:

1) Write up a single webpage about your favorite sport.
Use 2 pictures to illustrate it. Some text should be:
* bold
* italics
* bold italics
* underlined

Also, include a link to another webpage somewhere on the Web
which discusses your sport.

Use WinSCP to make this web page.



1) We logged in
2) We created public_html folder. (one time only)
3) We dbl-clicked on public_html to enter that folder
4) We created hello.html
5) We changed the properties on hello.html
6) We saw that web page in a web browser
http://cs12.cs.qc.cuny.edu/~loginname/hello.html

Prepare for the Excel exams

Excel practice exam files,

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


Walkthroughs:
Exam 1



Exam 2


Exam 3


Exam 4


Exam 5