intro to CSS

http://www.w3schools.com/css/default.asp

selectors and declarations

back to MS Access
field properties

to ask questions about the data, we use Queries

SQL - a standard query language you can use to talk to databases
http://www.w3schools.com/sql/default.asp

SELECT * FROM Customers
WHERE FirstName = "Peter"

query wizard:
what table?
what fields?
what shall we name this query?

then, we will need to fine-tune it in Design View.

SELECT Customers.Title, Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Customers.FullAddress, Customers.SSN, Customers.CreditCardNumber, Customers.DOB
FROM Customers;

we added the where clause using the design view, in the Criteria row.

SELECT Customers.Title, Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Customers.FullAddress, Customers.SSN, Customers.CreditCardNumber, Customers.DOB
FROM Customers
WHERE (((Customers.FirstName)="Peter"));

Access databases will typically have Tables, Queries, Forms, Reports

wildcards: * ?
* means match any number of characters, including zero character

j*sh

____________

josh
jish
joshua -- only this one won't match
jsh
jjsh
jaash