Ch 3, practice exercises 1-4

The web assignment
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html

But:
I also want you to incorporate a bit of CSS in it
http://www.w3schools.com/

lecture notes

three steps in the wizard
1) choose your table(s)
2) choose your field(s)
3) name the query

THEN, you will likely need to go to Design View
there, you will choose your criteria, sorting order, etc.

SELECT Accounts.CID, Accounts.BID, Accounts.Balance
FROM Accounts;

SELECT CID, BID, Balance FROM Accounts WHERE BID="B5";

SELECT Accounts.CID, Accounts.Balance, Branch.Location, Customers.FirstName, Customers.LastName
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BID = Accounts.BID) ON Customers.CID = Accounts.CID
WHERE (((Branch.Location)="Central"))
ORDER BY Accounts.AID;

HW: Not chapter 1. yes, chapter 2, access, practice exercises 1-3

Cartesian Product
Select, Customers.CID, FirstName, LastName
OrderID, OrderDate,Orders.CID,Cost
From Customers, Orders;

SELECT * From Customers, Accounts
WHERE Customers.CID = Accounts.CID
This is called an INNER JOIN


SELECT * From Customers INNER JOIN Accounts
ON Customers.CID = Accounts.CID

lecture

note to self
pick up at example 16 or 17

start access:
start/run/
msaccess

http://www.officelive.com/en-us/

openoffice.org

Database - data and methods of accessing that data
a collection of Tables

Table - a collection of records

Record - a collection of fields

Field - one unit of information

Query - a question about the data

Form - a means of modifying the data in a controlled manner

Report - a means of displaying the data, often for printout

walkthru excel practice 5

walkthru excel practice 4

walkthru excel practice 3

walkthru excel practice 2

Walkthru, first practice Excel exam

more to come...