Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Access

Microsoft Access Complete Beginner to Advanced

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports
Rating: 4.7 out of 54.7 (3,231 ratings)
25,207 students
Created by Kyle Pew
Last updated 5/2019
English
English [Auto], Italian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Manage Large Sets of Data in Microsoft Access Relational Design
  • Build an Efficient Database Table Design
  • Control User Data Entry Effectively
  • Build Dynamic Access Database Queries
  • Present Dynamic Reports
  • Build Automation, Saving Time and Money
Curated for the Udemy for Business collection

Requirements

  • Windows Machine with Microsoft Access
  • No Prior Microsoft Access Knowledge Needed

Description

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, and 2016

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

Who this course is for:

  • Users Looking to Gain a Working Knowledge of Microsoft Access from Beginner to Advanced

Featured review

Mehmet
Mehmet
220 courses
22 reviews
Rating: 5.0 out of 5a year ago
This is an excellent cource for learning access. I got an access application request at my company.Learnt in 1 week with this course,finished the application in 1month which is connected to a mssql database.It is right now used between two major corporations in canada as an Edi app. I heavily customised it with vbasic but the core of it came from this course.Just buy this course,I returned another big one on access from udemy.This one is better.

Course content

29 sections • 173 lectures • 13h 16m total length

  • Preview03:03
  • Preview02:54

  • Preview03:51
  • Preview03:05
  • Working with the Access Ribbon
    03:45
  • Access Object Panel
    04:12
  • Access File Tab
    03:19
  • Access Security Prompt
    03:19

  • Understanding the Purpose of Access Tables
    08:46
  • Building Relationships between Access Tables
    05:37
  • Using Access Queries to Select Specific Data
    09:15
  • Building a User Interface with Access Forms
    07:34
  • Reporting on Access Data with Access Reports
    05:53
  • Automate Access Tasks with Macros and VBA
    04:06

  • Working in Datasheet View within an Access Table
    06:15
  • Sorting the Datasheet View
    03:19
  • Filtering the Datasheet View with Filter by Selection
    03:33
  • Filter the Datasheet View with Advanced Filter
    04:35

  • Preview03:36
  • Creating an Access Database
    03:42
  • Designing Access Tables in Design View
    10:23
  • Adding Fields and Defining Common Data Types in an Access Table
    05:32
  • Field Size Property
    05:45
  • Field Caption Property
    02:48
  • Default Value Property
    04:08
  • Required Field Property
    01:30
  • Input Mask Property
    09:18
  • Custom Input Mask
    04:52
  • Working with the Lookup Wizard Data Type
    04:29
  • Edit a Table Field Drop Down
    01:54
  • Adding Field Descriptions
    02:00
  • Setting the Table's Primary Key Field
    05:49
  • Adding Records in the Datasheet View
    03:28

  • Table Exercise Introduction
    03:11
  • Building Additional Tables
    02:00

  • Understanding Access Table Relationships
    05:37
  • Creating Access Table Relationships
    08:29
  • Setting Up "Better" Table Relationships
    09:20
  • Setting the Relationship Properties
    06:16
  • Table Relationships Cascade Update/Delete
    04:41
  • Working with Sub Datasheets in Tables
    03:06
  • Creating Table Relationships with the Lookup Wizard
    07:24

  • Creating an Access Select Query
    06:26
  • Adding Criteria to an Access Select Query
    02:52
  • Using AND Conditions in an Access Query
    03:06
  • Using OR Conditions in an Access Query
    02:40
  • Another OR Condition
    02:11
  • Sorting Data within an Access Select Query
    01:42
  • Multi-Level Query Sort
    03:35
  • Working with Date Criteria in an Access Select Query
    04:01
  • Using the "Between" Operator
    02:00
  • Access Query Tip -- Using Table Fields within Query Criteria
    05:06
  • Using Wildcards in Query Criteria
    05:51
  • Access Query Tip --- DATA TYPE MISMATCH
    05:55
  • Saving an Access Query
    02:08

  • Creating a Calculated Field in an Access Query
    06:51
  • Using the MONTH() and MONTHNAME() Functions
    08:13
  • Using the IF() Function in a Query Calculated Field
    08:56
  • Finding the Difference Between Two Dates Using the DateDiff() Function
    06:02

  • Working with an Access Total Query
    02:12
  • Grouping and Summarizing Data with a Total Query
    06:55
  • Adding a Calculated Field to a Total Query
    04:00
  • Saving a Total Query
    01:29
  • Total Query Exercise -- Post in the QA Section
    02:27
  • Total Query Example -- Products Table
    01:34
  • Summarizing Data with a Crosstab Query
    06:28

Instructor

Kyle Pew
Microsoft Certified Trainer
Kyle Pew
  • 4.6 Instructor Rating
  • 256,891 Reviews
  • 828,651 Students
  • 19 Courses

Qualifications:

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio

SharePoint End-User 2007, 2010, 2013

VBA (Excel and Access)

Adobe SuitePhotoshop, Illustrator, InDesign

Maya (Modeling and Animation)

Unity3d (Game Design)

HTML, CSS and JavaScript

Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

Brocade

Chevron

Genentech

Facebook

Levi Strauss

PMI Mortgage Insurance

State Fund

Bank of the West

VISA

Walmart

and many more...


What Students have said about Kyle:

"Kyle was off the chart "GOOD""

"ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

"Awesome trainer because I'm computer "stupid" and he helped me understand it."

"Kyle Pew is very knowledgeable and presented information with exceptional skill."


In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.