Access Seminars

Access Asset Management Seminar Part 1

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)

Access Registration Seminar Part 1

00. Intro (3:42) 01. Lesson 1 (10:46) Registration Discussion Security Topics Startup Form Form Open Event The Windows Registry 02. Lesson 2 (10:26) GetSetting from Registry SaveSetting to Registry MsgBox Command InputBox Command Quit Command 03. Lesson 3 (11:45) Random Number Generator Checking Counter Key 04. Lesson 4 (8:42) Timing Out Registration Annual Subscriptions DateAdd Function 05. Review (5:26)