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