When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Learn Microsoft Access - The Complete Microsoft Access Course for Beginners
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
6 hours 13 minutes 
english
Online - Self Paced
course
SkillShare
About Learn Microsoft Access - The Complete Microsoft Access Course for Beginners
Welcome to Access for Beginners
Take a Tour of the Access Dashboard and Ribbon
Learn About Access Objects: Tables, Queries, Forms and Reports
Create Your First Table in Access
Appending Data from Excel into Access
Importing Data from Excel into Access
Importing Data from a CSV Text File into Access
Database Design and Table Relationship Basics in Access
More Complex Database Design Scenarios
Primary Keys and Foreign Keys in Relationships
Introduction to Field Properties in Access Tables
Size, Format & Input Mask Field Properties
Default Value, Validation Rules & Indexed Field Properties in Access
Introduction to Access Forms
Create and Format a Form Using the Form Wizard
Add Controls to Your Form for Better Usability
Add Navigation Buttons and Drop Down (Combo) Boxes to Your Form
Introduction to Queries, Sorting and Filtering
Create a Query Using a Single Criteria
Criteria in Queries - Many Examples
Introduction to Reports - Create Your First Report
Create Two More Reports
Options - General and Current Database Option Tabs
Options - Datasheet and Other Option Tabs
Exporting Tables, Queries & Reports to Text, PDF and Excel
Advanced Section Introduction
VBA Introduction
VBA Setup
VBA Debug
Advanced Form Properties - Part 1
Advanced Form Properties - Part 2
Create and Format a Blank Form aka Intro to Advanced Forms
Adding Working Combo Boxes
Setting Combo Box Options
Further Refinements to Our Combo Boxes
Run an Event on the Category
Modify the Quantity Box
Modify the Cost Box
Finish the Total Cost Message Box
Good Form Design and Tab Order
Course Summary
What You Will Learn?
- Welcome to the Access 2016 course. .
- Thank you so much for joining us. .
- 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?.
- You might be wondering if this course will 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.
- 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..