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