01. Open Report WHERE Condition (28:04)
Buttons on Main Menu for Reports
Replace Invoice with Grouped Report
Same field name on two tables
OrderT.F1 and OrderDetailT.F1
OrderID Header Section
Open Report to Specific Multiple Records
Print Multiple Invoices
Macro WHERE Conditions
Print All Invoices for a Customer
Print All Invoices Between Dates

02. Types of Action Queries (5:49)
What are Action Queries
Update Query
Append Query
Delete Query
Make-Table Query
Backup your data!
How to backup your database file
Online backup recommendations
Backing up a table

03. Update Queries, Part 1 (14:48)
Update Queries allow Complex Criteria
Change Select to Update Query
Update To Property
RUN vs Datasheet View Buttons
Preview Records to be Updated
Running the Update Query
Multiple Criteria
Change "XYZ Corp" in "PA"
Save Query
Nested IIF in Update Query
Assign Reps Based on Territory

04. Update Queries, Part 2 (10:26)
Capitalize States
UCASE() Function
Can't Delete a Table with Relationships
Manually Delete Relationships
Delete and Rename Backup Table
Restore Relationships
LCASE() Function
STRCONV() Function for Proper Case
Exceptions: Don't change McDonald

05. Update Queries, Part 3 (9:26)
Add 5% to all Product Prices
UnitPrice = UnitPrice * 1.05
Update all Paid Orders as Shipped