Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2016 Master Class: Beginner to Advanced
Section 1: Welcome to the Complete Microsoft Access 2016 Master Class Course!
Introduction (0:50)
Introduction and Three Data Problems Overview (4:56)
Section 2: THREE Major Data Problems That Access Completely Resolves
Access Solves the SIZE and SPEED Problem (3:37)
Access Solves the DATA SHARING Problem (3:40)
Access Solves the ONE to MANY Problem (3:31)
Section 3: Learning the Parts of the Access Screen
The Parts of the Access Screen (1:52)
Working with the Navigation Pane, Menu, Ribbons and Objects (10:20)
Section 4: TABLE Objects - the Basics
Creating Our First Table and Data Type (9:01)
Adding, Editing and Deleting Records (8:05)
Primary Keys: What They Are and Why They Are Important (3:48)
Adding Autonumbers, Primary Keys and Restructuring Tables (6:54)
Basic Table Sorting and Filtering (8:25)
Section 5: REPORT Objects - the Basics
What do Reports do? (4:11)
Modifying the Report (5:41)
Working with Controls, Report and Layout Views (9:33)
Section 6: QUERY Objects - the Basics
Basic Queries (6:46)
Query Criteria (5:12)
Date Criteria and Between (5:32)
Using OR in Criteria (4:17)
Parameter Queries (4:53)
Section 7: PROPERTIES - Making Thousands of Choices Manageable
Viewing Table Properties and Custom Formatting (9:51)
Field Validation and Other Field Properties (5:32)
Query Properties (4:53)
Report Properties (6:11)
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)
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)
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 and MAKE TABLE ACTION Queries (8:32)
ACTION Queries - DELETE (2:48)
Calculations in Queries and Formatting Results (5:33)
A Parameter Query Trick (5:07)
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)
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)
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)
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)
Modify the Add Order Macro to Plug the Name and Address (9:31)
New Customer and Exit Buttons (10:32)
A Special Startup Macro (2:35)
Section 15: Creating a Multi-Page Invoice
Create an Invoice Report from the Orders Subform (8:14)
Change Invoice Recordsource and More Formatting (5:23)
Create an Invoice Button on the Orders Form (4:07)
Test a Multi-Page Invoice and Final Formatting (8:57)
Section 16: Final Thoughts
Access is Built for Networking (6:42)
THREE Best Practices in Table Design with (8:21)
What's New in Access 2016 (5:54)
Teach online with
Creating Our First Table and Data Type
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock