microsoft ultimate steal
http://www.microsoftstore.com/store/msstore/cat/categoryID.37826100

* import from Excel into Access
my advice: make sure that data type of foreign keys
and primary keys are set to what you want on import.
otherwise, you will problems in establishing relationships
in the relationship window.
set the primary key on Import

* In queries, here are the wildcards:
* means match anything, including nothing
j*sh
will match:
jsh
josh
jithsh
? means matching exactly one characted
j?sh
will match
josh
jish
NOT match jsh
NOT match jiiiish
contains Excel
*Excel*
Learning Excel Formulas
Excel Formulas 2010
Learning Excel
begins with
G*
Grauer
ends with
*ing
Starling

Like "*Excel*"


Today's date: Dec 16
Publish Date: Dec 1
Today's Date MINUS Publish Date <= 60
DATE() - PublDate <= 60


SELECT Book.Title, Book.Price, Book.PublDate
FROM Book
WHERE Book.PublDate > Date()-60;

joshwaxman@gmail.com

w3schools.com

select * from Accounts, Branch
where Accounts.BranchId = Branch.BranchID

SELECT Accounts.AccountID, Accounts.CustomerID, Accounts.BranchID, Accounts.Balance
FROM Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BranchID
WHERE (((Accounts.BranchID)="b50"))
ORDER BY Accounts.AccountID;

http://eniac.cs.qc.edu/~svitak/cs12/

quiz next week, based on multiple choice from
Access ch 1, 2, 3


SELECT Agents.FirstName, Agents.LastName, Properties.DateListed, Properties.ListPrice, Properties.SalePrice, Properties.SqFeet, Properties.Sold, [ListPrice]/[Beds] AS PricePerBR, ListPrice / (Beds + Baths) As PricePerRoom
FROM Agents INNER JOIN Properties ON Agents.AgentID = Properties.AgentID
WHERE (((Properties.Sold)=No));

Practice Access Exams

Practice Access Exam 1.
Practice Access Exam 2.

PracticeExamFiles.zip

Practice Access 1

Practice Access 2: