Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access Masterclass; Level 1 & 2 - Beginner to Intermediate
Introduction
Introduction - How To Ensure You Have A Great Course Experience (2:51)
In The Rare Case Where You Don't Have Access (2:14)
Everything about Tables
Intro To Working With Tables and Navigation (3:51)
Fundamentals of Editing Records (Adding and Deleting) (4:14)
Sorting in Access (1:32)
Filtering in Access (2:24)
Using Find and Replace (2:37)
Creating Our First Table, 1 (4:13)
Creating Our First Table, 2 (2:47)
Creating Our First Table, 3 (1:41)
Field Properties 1 (field size,format,input masks) (7:00)
Field Properties 2 (Default Values and Validation Rules) (6:33)
Field Properties 3 (Peculiar but Important Feature to Understand, Allow Zero Length Field Property) (3:12)
Lookups in Tables (7:33)
Changing Order of Fields, Deleting/Adding New Fields/Selecting multiple at Once (2:37)
Working with Reports in Access
Intro to Reports and Report Wizard (7:24)
Laying out Report Components; Move, Resize, Align Report (7:23)
Unbound Controls in Access (1:38)
Bound Controls in Access (2:36)
Calculated Controls in Access (1:52)
Creating Our First TextBox Control in Report (10:07)
Adding Our Second Control in Report (4:55)
Filtering and Grouping in Reports (2:26)
Conditional Formatting in Reports (3:18)
Queries (Select Queries)
Intro to Queries and Designing Queries (6:44)
Sorting in Queries (2:40)
Criteria In Queries (3:06)
Wildcards In Queries (2:24)
Formulas In Queries (5:20)
Calculations In Queries (2:06)
Advanced Select Query: Parameter Query (Why Are They Useful in Business Context?) (3:34)
Advanced Select Query: Top (Records) Query (3:19)
Advanced Select Query: Total Queries (groups of records/table totals) ( (2:15)
Advanced Select Query: Crosstab Query (4:22)
Action Queries
Update (5:13)
Make Table (3:11)
Append (4:48)
Intro to Forms
Intro To Forms (1:01)
Creating Customer Form (5:20)
Alignment in Forms (3:11)
Styling our Form (3:01)
Controlling Tab Order (1:51)
Creating Transactions form List (1:38)
Adding SubForm to Customers Form (4:58)
Final Touches For Our Customer Transactions Form (7:13)
Database Design 1 (Becoming a Database Expert from Other Areas)
From Spreadsheet Expert to Database Expert (1:25)
From Coding/Programming Pro to Database Expert (1:32)
The Role of the End User vs. Developer (1:34)
Database Design 2, Illustrating Normalization Practically
1st Rule(s) of Normalization Illustrated (Hands-On) (2:43)
2nd Rule of Normalization Illustrated (Hands-On) (1:55)
3nd Rule of Normalization Illustrated (Hands-On) (1:50)
Database Design 3, Table Design
Tips for Primary Key Creation (3:59)
Is Duplication Sometimes Necessary? (1:38)
A Real Example of Non-Normalized Data Becoming Normalized (2:44)
Field Type Consistency (0:57)
Database Design 4, Relationships and Referential Integrity
Relationships and Referential Integrity Intro (4:03)
One-To-Many Relationship Type (1:55)
Many-To-Many Relationship Type (4:09)
One-To-One Relationship Type (1:03)
Referential Integrity Hands-On Illustration (6:42)
Cascade Delete Hands-On Illustration (3:46)
Cascade Update (1:02)
Importing Excel into Access using GUI and Database Principles
Intro to Excel and Access (1:26)
Excel to Access, Problem 1 (heading/fields not in first row) (3:42)
Excel to Access, Problem 2 (import errors) (4:49)
Excel to Access, Problem 3 (data check/considerations before import) (3:10)
Many Excel Files to One (2:01)
Preparing A Table To Import Our Big Excel File (6:13)
Normalize By Creating Tables And Relationships (8:14)
Append from Master to Individual Tables in Order (8:26)
Essence of Programming - Program Flow
Control Structures (1:41)
Decision Structures (If-Then-Else) (5:24)
Loop Structures (Do-While) (4:57)
Intro To Macros
Creating an AutoExec Macro (4:23)
Standalone and Embedded Macros (2:12)
Exploring Options in Macro Action Catalog (6:03)
Button Control Macros using Wizard (9:44)
AutoExec Macro 2 - Using Table and Form to Create Welcome Message, 1 (11:50)
AutoExec Macro 2 - Using Table and Form to Create Welcome Message, 2 (2:14)
AutoExec Macro 2 - Finishing Touches (2:57)
Importing Excel Using VBA Code
The Easiest and Quickest Way To Import with VBA (8:59)
Using VBA to Import Excel Files And Creating Better User Experience (27:38)
Using VBA To Create The Best User Experience Possible (12:47)
Finish Line
Congrats/Final Thoughts (1:03)
Final Touches For Our Customer Transactions Form
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock