Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Adobe Photoshop Elements 11 – 12 Hours Video Training Course
        • Adobe Photoshop Elements 10
        • Adobe Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • PowerPoint
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010 – 9 Hours Video Training
      • Windows
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Pro 2021
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Introduction to Python
      • Java
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
    • Data Analysis
      • Introduction to Alteryx
      • Power BI
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Access > Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)

Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)

Microsoft Access remains one of the simplest database tools to learn. Better still, Access integrates well with other Office tools like Microsoft Excel. In this Microsoft Access tutorial, we take you through how to get set up in Access and start your database training journey. If you are brand new to databases, then this Microsoft Access for Beginners free course is for you!

Microsoft Access Tutorial

If you’re not sure you want to read a detailed Access database tutorial, don’t worry. This Access tutorial is nearly all video-led. The videos themselves are taken from our best-selling Microsoft Access for Beginners online course and are also hosted on our YouTube Channel.

To explain how this MS Access course works and what to expect, take a look at our first video:

SECTION 1

In this next video, we look at getting your version of Access set up and how to pick an Access Database template. Once we’ve downloaded and created our blank database we’ll introduce you to the Access Database definitions.


In the next section of this Microsoft Access tutorial, we look at the correct way to save, launch and open your Access databases. We’ll then launch a brand new Access database and show you how to start from scratch.

In this part of the Access course, we look at the Access Workspace and Backstage areas of Access. The next video takes you through the ribbon and the third the quick access toolbar. If you’re pretty familiar with Microsoft Office backstage, the ribbon and the quick access toolbar then you can probably skip past these Access tutorials!

In the next two videos, we look at contextual menus and the status bar in MS Access. These two, short videos will help you become more efficient in MS Access.

Next, we’re going to start to customize Access to be perfect for your needs. If you just want to keep the standard options, skip past this video.

SECTION 2

Now that we know our way around access, we know how to customize Access for our needs, we know how to import templates into Access then we’re ready to get into the good stuff and start populating our Access database with data. 

In this Microsoft Access tutorial, we look at how to create a table and fields in Microsoft Access.

Microsoft Access is all about storing and using large amounts of data. In order to do that in an effective way it indexes the data. In this video, we show you how to add fields and how to use indexed fields in Microsoft Access.

Now we’re starting to get somewhere – you’re going to be an Access expert in no time at all. In this next Access training video, we look at how to create a lookup field using the Lookup Wizard. A Lookup field limits or defines what data can go into which field and table. It’s essential to understanding how Access works:

So far we’ve just added text into our database, next we’re adding numbers into an Access database. Adding numbers into Access is not as easy as it may sound. Luckily, Toby is here to show you how:


If you’ve ever started using Excel as a database and realized quickly that you need a database tool. If that’s the case, then you’ll need this video as we show you how to import tables of data from Excel to Access.


In this final video of the series, we look at the hugely important topic of backing up your Access database. If you don’t, you risk losing all your data.

We hope you’ve found this Access training course useful and are now confident enough to go and start creating your own databases in Microsoft Access. If this has got you interested in learning more about Microsoft Access and you’re hungry for more Access tutorials, then we can help. 

All these videos were taken from our much longer, Microsoft Access 2016 for Beginners Course. Take a look at the full syllabus by clicking here.

If all this was information you already knew, then you probably need our Advanced Microsoft Access 2016 course. You can access both of these courses for one low, monthly fee by joining Simon Sez IT as a member

Most Popular Posts

  • How To Use Microsoft To Do: Microsoft To Do Tutorial
  • Microsoft Teams Tutorial – Getting Started.
  • HLOOKUP in Excel
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Join our list to receive 4 Free Courses!

Simon Sez Business Banner

Similar Posts

Advanced Formulas in Excel – 1 Hour Recorded Webinar

How to Create an Estimate in QuickBooks 2019 – Part 1

The Ultimate Zoom Tutorial

How to Set Up Sales Tax in QuickBooks 2019 – Part 1

How to Use Excel 2010 Pivot Tables and Charts – Part 2

How to use Flash Fill with Microsoft Excel 2013

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2021 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)