This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Adding, Editing and Deleting Records
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock