Udemy

Microsoft Access Level 3 - Advanced Access

Enroll Now
  • 309 Students
  • Updated 4/2021
4.4
(45 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 14 Minute(s)
Language
English
Taught by
Kirt Kershaw
Rating
4.4
(45 Ratings)

Course Overview

Microsoft Access Level 3 - Advanced Access

Become an Access Guru by Mastering Advanced Access Table Structuring, Subqueries, Macros, Table of Contents and More!

Drive Your Microsoft Access Skills to an Advanced Level

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert.  Below are just a few of the topics that you will master:

  • Table normalization and restructuring of poorly designed databases

  • More targeted Query results by using Subqueries

  • Perform summary calculations of intersecting values of row and column headings using Crosstab Queries

  • Automate data entry, based upon certain data entered into other fields, with Automated Macros

  • Alphabetically sort, label, and group records in your Reports

  • How to attach any file including documents and images to a record.

  • How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports

  • and much, much, more…

Course Content

  • 1 section(s)
  • 50 lecture(s)
  • Section 1 Normalization Standard

What You’ll Learn

  • How to normalize other databases for quicker data retrieval
  • Find unmatched and, or duplicate records using a Query
  • Reduce repetitive actions using Macros and adding Macro Buttons
  • How to require and automate data entry with Macros
  • Pull up related records fast using the Where Condition
  • Emphasize data, or records with Conditional Formatting
  • Compact, repair, backup and password protect your database
  • Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training

Skills covered in this course


Reviews

  • C
    C
    5.0

    Excellent thank you

  • J
    Jacques Greeff
    4.5

    Money well spent, i would consider myself an ecpert in MS Access but i'm still learning new things. 9/10

  • W
    William P. Mello
    4.5

    This course was easy to follow, with concise directions and explanations to achieve everything that was covered in this course. I would recommend this course to anyone and everyone!

  • N
    Nakacwa Sandra
    5.0

    Cool content

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed