Access 2016 - The Complete Microsoft Access Beginners Course

Steve McDonald, Author, Instructor, Digital Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Lessons (4h 31m)
    • 1. Welcome to Access for Beginners

      9:52
    • 2. Take a Tour of the Access Dashboard and Ribbon

      10:08
    • 3. Learn About Access Objects: Tables, Queries, Forms and Reports

      11:57
    • 4. Create Your First Table in Access

      17:53
    • 5. Appending Data from Excel into Access

      7:50
    • 6. Importing Data from Excel into Access

      6:48
    • 7. Importing Data from a CSV Text File into Access

      7:35
    • 8. Database Design and Table Relationship Basics in Access

      7:18
    • 9. More Complex Database Design Scenarios

      3:53
    • 10. Primary Keys and Foreign Keys in Relationships

      14:07
    • 11. Introduction to Field Properties in Access Tables

      3:38
    • 12. Size, Format & Input Mask Field Properties

      16:04
    • 13. Default Value, Validation Rules & Indexed Field Properties in Access

      15:59
    • 14. Introduction to Access Forms

      8:35
    • 15. Create and Format a Form Using the Form Wizard

      14:04
    • 16. Add Controls to Your Form for Better Usability

      15:15
    • 17. Add Navigation Buttons and Drop Down (Combo) Boxes to Your Form

      16:08
    • 18. Introduction to Queries, Sorting and Filtering

      10:42
    • 19. Create a Query Using a Single Criteria

      7:53
    • 20. Criteria in Queries - Many Examples

      16:14
    • 21. Introduction to Reports - Create Your First Report

      6:10
    • 22. Create Two More Reports

      12:57
    • 23. Options - General and Current Database Option Tabs

      10:12
    • 24. Options - Datasheet and Other Option Tabs

      9:41
    • 25. Exporting Tables, Queries & Reports to Text, PDF and Excel

      5:03
    • 26. Course Summary

      5:14
38 students are watching this class

Project Description

This entire course is hands-on. That's how you learn. So, as you are going through the course, please snap a screenshot of your work (it could be a report, table, form or query that you've created) and share it here in the class projects.

Example:

8b57d553

Student Projects

Cal Coggins
2 comments