01. Getting Started (9:01)
Download sample database
Unzip the database file
Don't run Access from inside a ZIP file
Security Warning - Active Content Disabled
Enable Content button
Setting up a trusted location
Set up a Databases Folder
Database shortcut on Desktop
Quick Review of Level 1
02. Form Design 1 (12:51)
Building forms from scratch
Build a user-friendly interface
Form design is more art than science
Rebuild customer form
Expand / collapse Ribbon
Record Source Property for a Form
Bind Form to CustomerT
Delete order by and filtering
Add existing fields, Field List
Switch to Form View
Switch to Design View
Adding fields to form
Deleting a field
Click and drag method
Add multiple fields
Shift-click method
Ctrl-click method
Move text box without label
Move label without text box
Using keyboard to move objects
Delete just the label
Resize text box or label
Select multiple objects
Resize, move multiple objects
Edit the text of a label
Move last name next to first name
Close the Field List
Align Controls Left
Size Controls To Widest
Selecting Objects with Ruler Bar
Foreground, Background Colors
03. Form Design 2 (12:52)
Double-click to add field
The Grid dots
Grid dots v. lines
Sizing objects on the Grid
Size to Grid
Resize the Form itself
Format Painter
Quick Launch Toolbar
Change Form background color
Textbox background color
Label foreground color
Select using the rulerbar
Align Left, Center, Right
Ctrl-Click to select objects
Special Effect Property
Shadowed
Change Font
Themes
Standard Color vs Theme Color
More Colors
Full Color Palette
Shape Outline
Line Color, Thickness, Type
04. Intro to Relationships (15:53)
Why Relationships
Relationship Types
One-to-Many
One-to-One, Many-to-Many
Primary Key, Foreign Key
AppointmentT Table
Default Value
Date() Now()
Multiple Appointments per Customer
05. Appointment Form (20:25)
Create AppointmentF
Add Fields
Format Align Left
Undo (Ctrl-Z)
Customer Combo Box
Relational Combo Boxes
Combo Box Wizard
Store Value in CustomerID
Name Property
Control Source Property
Forms Save Position
Tab Order (Auto Only)
Command Button Wizard
Open Form Show Specific Records
Find Records
06. Q&A From Students (25:12)
Customize the Ribbon
Can’t See Text
Print Form in Design View
Start AutoNumber >1
Combo Box Always Open
Maximum Database Size
Maximum Number of Fields
Access on a Mac
Restore Deleted Textbox
Green Triangle
#Name? Error
Unrecognized Database
Checkbox Background Color
Multiple Tables on a Form
Thumbtacks on File List
LACCDB Files
07. Review & What's Next (5:21)
Review of Topics
Coming Up Next...