00. Intro (7:55)

01. Setup Core Tables (27:10)
AssetT
EntityT
HistoryT
ConditionT
Query for Entities Based on Available Info
EntityQ

02. Setup Core Forms (26:10)
EntityF
EntityListF
Double Click to Open EntityF
Search Box in List Form
Enter Assets in Table
Assign ParentID
Create AssetF
Make Combo Boxes

03. Asset List & Child Subform (35:09)
Create Asset List Form
Create Child Subform
Click to Open Selected Asset
Recolor Fields Based on Values
Hide Owner, Location for Children

04. History Log (16:58)
Track Changes to Any Asset
Note Field Values in Log Table
Create LogIt Subroutine
VBA / SQL INSERT INTO

05. Topics for Part 2 (10:39)
List of Topics to Cover Next

06. Review (5:09)