Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Learn Microsoft Access - The Complete Microsoft Access Course for Beginners

via Skillshare

Go to class Write review

This course may be unavailable.

Overview

Welcome to the Access 2016 course. 

Thank you so much for joining us. 

  • 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?

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

  • 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.

Syllabus

  • 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

Taught by

Steve McDonald

Reviews

Start your review of Learn Microsoft Access - The Complete Microsoft Access Course for Beginners

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.