SQL Statements
SELECT - tells ADO what fields to retrieve from which table. For example:

SELECT * FROM TableName WHERE - limits what data is selected. An asterix means all elements (columns) in the database.
SELECT * FROM TableName WHERE FieldName = 'Value'

ORDER BY -sorts what is returned.
SELECT * FROM TableName WHERE FieldName > 50 or FieldName < 100 ORDER BY FieldName2, FieldName3

INSERT INTO - adds a new record to the table.
INSERT INTO TableName (FieldName1, FieldName2) VALUES ('Value1', 'Value2')

DELETE FROM - deletes records from the table.
DELETE FROM TableName WHERE FieldName = 'Value'

UPDATE - changes the values of particular fields of the table
UPDATE TableName SET FieldName = 'New Value' WHERE FieldName2 = 'Value2'
UPDATE ComicCollection SET StreetValue = StreetValue + 10 WHERE Title = 'X-men'

LIKE - used to search through records
SELECT * FROM TableName Where FieldName LIKE '%%Value%%'

Wild Card Characters! The % (percent sign) indicates there can be characters before or after the value.