Access 101: A Quick Start Guide to Microsoft Access

These are my Access best practices. There are many like them, but these are mine.

Mike Wolfe

Oct 5, 2023 • 3 min read

Access 101: A Quick Start Guide to Microsoft Access

Does the world really need another Microsoft Access tutorial? Frankly, no.

There are many great resources already, among them:

So if the world doesn't need another Access tutorial, why am I writing this series?

Because I need a Microsoft Access tutorial for my interns and future employees.

How This Series is Different

To transmogrify the first line of the Rifleman's Creed of the U.S. Marine Corps:

These are my Access best practices. There are many like them, but these are mine.

This will be a very opinionated series. To reduce confusion for my beginners, there won't be much, "Well, you could do it this way OR you could do it that way." It will simply be, "This is THE way" (even if other common approaches may exist in the wider world).

Hey, I Don't Read this Blog for Beginner Topics!

When I started this blog, I did it in large part because I felt there was a void in advanced Access and VBA topics on-line, especially since the heyday of Access and VB6 in the late 90's and early 00's. Worry not! I fully intend for nolongerset.com to remain the premiere site for advanced Access and VBA content.

Here are a few points to reassure you advanced readers out there:

  1. While the content of each of these articles will be aimed at beginners, I will also be including a Further Reading section with links to more advanced topics related to each article.
  2. I won't suddenly start writing nothing but beginner-level articles; I would get bored with that myself. Instead, expect to see these articles sprinkled in among the usual advanced topics.
  3. As with my existing beginner articles, I will be covering topics that come up regularly on Access forums. Rather than typing up similar answers repeatedly, you'll be able to just drop a link to one of these articles.
  4. You'll no doubt disagree with some of my "best" practices and can let me know about it in the comments section or on social media.

Curriculum

These topics are arranged by category and broken down by skill level. If you are brand new to Access, I recommend reading the articles in skill level order. In other words, read all the form/report/control/VBA articles in the Intro skill level, then all the articles in the Basic skill level, etc.

This is a living list. New topics may be added at any time. Check back often as links to articles will be added as they are written.

Tables

Intro

Beginner

Queries

Intro

Beginner