Master Microsoft Access database creation and management in this comprehensive 5.5-hour tutorial. Designed for users comfortable with spreadsheets who need more analytical power and a stronger interface, learn to build robust databases for small to medium-sized businesses. Begin with database fundamentals before progressing to table construction, relationship determination, data querying, and user-friendly interface creation. Explore macros, VBA programming, form design, switchboards, and advanced features like record locking and startup options. Gain hands-on experience through practical exercises and learn to create powerful, customized database solutions to streamline organizational operations.
Overview
Syllabus
Start
Introduction
Free-Floating Parent and Child Forms
Starting Your First Macro
Adding Actions to Your First Macro
Three Ways to Trigger Macros
Creating Command Buttons Without the Wizard
Joining Forms by a Shared Field
Parent Form Size and Position
Child Form Size and Position
If-THEN and IN-List
Creating Combo-Boxes by Typing Entries
Combo-Boxes from Imported Tables
SETVALUE and GOTOCONTROL
Introduction to VBA
SELECT CASE Example in VBA
Debugging Simple Macros
Radio Buttons in VBA
Wrapping Up
Introduction
Compacting and Repairing Databases
Hyperlinks in Tables
Hyperlinks from Pictures in Forms
Switchboard Using Command Buttons
Read-Only Form Buttons
Switchboard Manager Method
Navigation Forms as Switchboards
Record Locking
Startup Options
Special Keys
Wrapping Up
Taught by
Learnit Training
Related Courses
Related articles
Reviews
5.0 rating, based on 1 Class Central review
-
This was a great cap to the set of Access courses. I'm sure I'll be referring back to the modules for a quick refresher on certain topics, but this set of courses provides a great base knowledge for using this program. Thank you Learnit and thank you Dan for a great teaching style.
