Microsoft Access: Complete MS Access Mastery for Beginners
- 7 hours on-demand video
- 3 articles
- 5 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- At the end of this course, you will be able to create a simple DATABASE in Access from scratch.
- You will know how to create and modify TABLES in Access.
- You will know how to create FORMS for enter data into your tables.
- You will know how to create QUERIES to ask questions of your Access database.
- You will know how to create REPORTS for sharing and presenting your data in a clear, professional way.
- You just need to have a PC, basic computer skills and an installed copy of Microsoft Access on your computer.
- You don't need any previous experience with MS Access or Excel.
- This course starts at the very beginning.
Welcome to the Access 2016 course.
Thank you so much for joining me.
Do you need to learn Microsoft Access, but feel intimidated or
overwhelmed by the thought of it?
Are you ready to learn a ton of practical, hands on Access skills?
If so, you found the right course!
This course is designed to get you feeling comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.
Is it the Right Fit?
Will this course be a good fit for you? Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine tune and expand your skills in an easy, stress-free way.
Skills to Impress Your Boss
While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.
Start at the Very Beginning
We'll start out with a complete tour of Access and it's tools. Then, I'll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.
Create a Database from Scratch
I'll walk you through creating a complete Access database from scratch.
I'll show you how to create tables and connect those tables to each other using relationships.
I'll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss.
I'll also share insights and productivity tips along the way.
Let's Get Started!
Are you ready to take your productivity and hopefully even your job prospects to the next level? Let's get started with Access 2016.
Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.
- Anyone who needs to learn Microsoft Access, but might be intimidated or feel overwhelmed by it.r
- This course is for students brand new to Access.
- This course is also for students who have some experience with Access or Excel and need to learn more about Access.
Welcome to Access 2016: Complete Microsoft Access Mastery for Beginners. In this lecture I'll introduce you to some basic database concepts and give you a tour of a Microsoft Access template.
In this video I'll take you on a tour of the Microsoft Access dashboard, tools and ribbon.
At the end of this lecture, you'll understand the four most basic objects in Microsoft Access: Tables, Queries, Forms and Reports. And you'll understand the role that each of these objects plays in your Access database.
In this lecture I'll walk you through creating your first two tables in Access. Tables area the backbone of a database. They are where all of your data, or information, is stored in Access.
Appending data allows you to add data into an existing Access table from another source, such as Excel. In this lecture I'll show you the ins and outs of appending and Excel file into our Access database.
In this lecture, you'll learn how to add combo boxes and navigation buttons to your Access forms. This allows you to create a better user experience for anyone entering data into your form. It also allows you to restrict the data entered, using a combo box drop down, so they can only enter data that exists in a specified field in your table.
Now we enter the advanced section of the course. It's gonna get a little more challenging from here, but take your time, bear with me through the intro stuff and it will all make sense in the end. This is where your skills will go to the next level in Access!