Learn to harness the power of Microsoft Access and get control of your data with this 2019 course.
**This course includes practice exercises and LIFETIME access**
What you’ll learn
- Practice what you learned with included exercise files.
- Sorting information and running queries.
- Creating tables and relationships.
- Navigating the Access 2019 interface.
- Design forms and generate reports.
- Learn valuable new skills for complex data projects at work.
- Supercharge your database projects.
- Discover how to into import data from Excel.
- Learn Queries, use validations, how to create and print reports.
- How to compact, repair and backup your database.
- How to create a linked table.
- Discover how to use the Query Wizard.
- Learn to use Model Dialog and Macros.
Course Content
- Introduction –> 7 lectures • 13min.
- Getting Started with Access 2019 –> 4 lectures • 40min.
- The Ribbon and Toolbars –> 4 lectures • 22min.
- Keyboard Shortcuts and Key Tip –> 2 lectures • 7min.
- Access Options –> 1 lecture • 9min.
- Tables –> 5 lectures • 43min.
- Importing Data –> 2 lectures • 17min.
- Backup, Restore and Repair –> 2 lectures • 10min.
- Datasheet View –> 3 lectures • 31min.
- Relationships –> 3 lectures • 31min.
- Forms –> 7 lectures • 54min.
- Subforms –> 4 lectures • 40min.
- Queries –> 4 lectures • 44min.
- Expressions –> 2 lectures • 19min.
- Reports –> 4 lectures • 34min.
- Printing –> 1 lecture • 8min.
- More Data Types –> 1 lecture • 11min.
- More About Forms –> 3 lectures • 34min.
- Exporting –> 1 lecture • 4min.
- Application Parts –> 1 lecture • 5min.
- More Access Options –> 1 lecture • 6min.
- Info Tab –> 1 lecture • 6min.
- Extras –> 1 lecture • 1min.
- Course Close –> 1 lecture • 1min.
Requirements
**This course includes practice exercises and LIFETIME access**
Microsoft Access remains an amazing tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer.
In this Microsoft Access beginners course, we start at the very beginning and assume you know nothing about MS Access. We take a project approach to this course, which means you build your own project out as we go. By the end of this Access 2019 course, you will have built out your own database with relevant functionality.
If you’ve used Excel in the past that will help, but it’s not essential. This course is really aimed at someone just starting out in Access.
In this course you will learn:
- Where to start in Microsoft Access and whether to use a template or not
- How to modify Access to suit your needs
- All about importing data and the datasheet view
- How tables work in Access and how to create relationships between them
- Creating forms and sub-forms that feed data into your tables
- How to run queries in Access
- Setting up validations and calculations using expressions in Access
- Printing from Access
- To start to use macros and Modal Dialog
- The basics of the Access web app
- Exporting and reporting in Access
***Exercise and demo files included***
This course includes:
- 7.5 hours of video tutorials
- 59 individual video lectures
- Exercise files to practice what you learned
- Certificate of completion
This course is designed for students that are new to Microsoft Access, are upgrading from a previous version, or have a basic understanding and are looking to sharpen their skills. If you’ve been using Access for years but are convinced that you’re not utilizing its full potential, then you need this course.
If your Excel spreadsheets keep crashing with too much data, then it’s time you got to know Microsoft Access. Let us show you how.
Here’s what our students are saying…
“Clearly explained. I have no prior knowledge of Microsoft Access, because of well explained topics, I completely understand this course. Thanks and see you in your advance course.”
– Allan Benzon
“Interesting. Seems comprehensive. Engaging. Great resources to make my learning experiences easier. Thank you.”
– John Dunn
“Outstanding way of explaining if you really want to learn access this is the best course on udemy to start with..Thank you Mr.Toby i just seen like 5 videos yet but i am sure this will be a great experience for me.”
– Faisal Riaz
Did you know?
Simon Sez IT teaches all sorts of software, including:
– Microsoft Excel
– Microsoft PowerPoint
– Microsoft Word
– Microsoft Project
– Microsoft Outlook
– QuickBooks
– Photoshop Elements
– Web Development Languages
– And so much more!