Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Access Master Tutorial

Learnit Training via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course on Access is designed for individuals comfortable with spreadsheet programs like Excel, aiming to provide them with the skills to design, build, and manage databases effectively. By the end of the course, learners will be able to create tables, establish relationships, query data, and develop user-friendly interfaces. The teaching method includes video tutorials and practical exercises. The course is intended for small to medium-sized businesses seeking to enhance their data management capabilities.

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Access Master Tutorial

  • Adam Burkhimer
    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.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.