Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2016 Master Class: Beginner to Advanced
Section 1: Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course!
Introduction & Course Benefits: How To Get Started With Microsoft Access 2016! (2:15)
Section 2: THREE Major Data Problems That Access Completely Resolves
A Quick Note BEFORE Starting Section 2
Bruce's Intro and Three Data Problems Overview (4:56)
Access 2016 Solves the SIZE and SPEED Problem (3:37)
Access 2016 Solves the Data Sharing Problem (3:40)
Access Solves the One to Many Problem (3:32)
Section 3: Learning the Parts of the Access Screen
The Parts of the Access Screen (1:52)
Direct Download of Database File
Working with the Navigation Pane, Menu, Ribbons and Objects (10:20)
Quiz 1: The Parts of the Access Screen
Section 4: TABLE Objects - The Basics
Creating Our First Table and Data Type PDF (9:01)
Adding, Editing and Deleting Records (8:05)
Adding Autonumbers, Primary Keys and Restructuring Tables (6:54)
Basic Table Sorting and Filtering (8:25)
Quiz 2: Review of the TABLE Object
Section 5: REPORT Objects - the Basics
What Reports do? (4:11)
Modifying the Report (5:41)
Working with Controls, Report and Layout Views (9:33)
Quiz 3: Review of the REPORT Objects
Section 6: QUERY Objects - the Basics
Basic Queries (6:46)
Query Criteria (5:13)
Date Criteria and Between (5:32)
Using OR in Criteria (4:17)
Parameter Queries (4:53)
Quiz 4: Review of Basic Queries
Section 7: PROPERTIES: Making Thousands of Choices Manageable
Viewing Table Properties and Custom Formatting PDF (9:51)
Field Validation and Other Field Properties (5:32)
Query Properties (4:53)
Report Properties (6:11)
Quiz 5: Review of Properties
Section 8: FORM Objects - The Basics
Creating a Form with the Wizard (4:14)
Cleaning Up the Form - Working With Controls (7:41)
More Form Cleanup - Moving Labels, Adding Rectangles, Font Color (10:20)
Resize Header and Detail and Finish Form (4:35)
Quiz 6: Review of Basic Forms
Section 9: Advanced TABLES
Using the Lookup Wizard (5:16)
Setup Lookups Without the Wizard (5:45)
Advanced Sorting and Filtering (5:48)
Working with Related TABLES (6:01)
Quiz 7: Review of Advanced Tables
Section 10: Advanced QUERIES
Using TOP queries (4:02)
Using TOTAL Queries (9:10)
ACTION queries - UPDATE (6:25)
ACTION queries - APPEND (4:27)
Multi Table Queries and MAKE TABLE Action Queries (8:32)
ACTION queries - DELETE (2:48)
Calculations in Queries and Formatting Results (5:34)
A Parameter Query Trick (5:07)
Quiz 8: Review of Advanced Queries
Section 11: Advanced REPORTS
Reports based on the Parameter Query Trick (11:03)
Calculations in Reports (4:24)
Sorting with Reports (2:16)
Adding an Order Month to Our Query (5:36)
Subtotals in Reports (5:12)
Label the Subtotals and Report Total (5:55)
Conditional Formatting (7:24)
Quiz 9: Review of Advanced Reports
Section 12: Advanced FORMS
Add a Combo Box to Our Orders form (8:09)
Setting the Tab Order (3:38)
Using TAB controls (5:39)
Continuous Forms 1 - Add a Calculated Field (2:51)
Continuous Forms 2 - A Shortcut for Creating (4:25)
Add a Subform (4:47)
Change a Textbox into a ComboBox (4:57)
Quiz 10: Review of Advanced Forms
Section 13: Automating Things In Your Forms
The Hooks - Form and Report EVENT Properties (12:26)
Updating the Main Form Total (9:00)
Recalculating the Order Total (6:49)
Quiz 11: Review of Automating Things in Your Forms
Section 14: More Form Automation: BUTTONS and MACROS
Create a Go To Customer Button (8:25)
Create a To Orders button in a Subform (4:07)
A New Order Button on the Customer Form (9:09)
New Customer and Exit Buttons (10:32)
A Special Startup Macro (2:35)
Quiz 12: Review of Buttons and Macros
Section 15: Creating a Multi Page Invoice
Create an Invoice Report from Orders Subform (8:14)
Change Invoice Recordsource and More Formatting (5:23)
Create Invoice Button on Orders Form (4:07)
Test a Multi Page Invoice and Final Formatting (8:57)
Quiz 13: Review of Creating a Multi Page Invoice
Section 16: Final Thoughts
Access is Built for Networking (6:42)
THREE Best Practices in Table Design (8:21)
What's New in Access 2016 (6:20)
Section 17: Conclusion
Want More?! Watch Our Special Bonus Lecture & Continue Learning With Us Today! (1:35)
Test a Multi Page Invoice and Final Formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock