Beginning Microsoft Access For Non-Programmers

Beginners Access Guide with no Programming Experience Required - Save expensive consulting fees and fix it yourself

What you'll learn

Learn how to fix simple issues in existing Access databases

Learn how to make tables and import data

Learn how to make forms, queries, and reports

Learn how to make a new Access application from scratch

Requirements

No Access experience needed. Basic familiarity with Windows and Office applications like Excel is helpful.

Description

This course is designed for beginners who suddenly find themselves responsible for a Microsoft Access database — whether you need to fix an old one, build a small system, or just understand how to keep things running. I've been an Access consultant for many years and I would get calls from clients along the lines of, “We used this database a long time ago, but the original programmer isn’t around anymore — now what do we do?”  This course is built to answer exactly that situation! Often you'll need to bring in a professional consultant but if it's a small correction or adjustment, hopefully I can save you $1000 for a consultant when it's something you'll be able to solve yourself.You don’t need to be a programmer to succeed here. We’ll focus on the fundamentals of Access: tables, queries, forms, and reports. You’ll see how to organize data, create entry screens, and produce useful reports without heavy coding. While some VBA (this is the coding language that Access uses) will be introduced when necessary, every piece of code is explained clearly, so even non-programmers can follow along with confidence. This is not an instructional course on VBA programming or coding.What makes this course different?Unlike many Access courses that tie lessons directly into a single “course project,” this one separates the two:Step-by-step lessons first — You’ll learn each feature in small, practical mini-projects, so you can use the concepts right away.Then, the course project — Once you’re comfortable with the basics, we’ll bring everything together in a larger project. This way, when you’re building it, you’ll already have the skills under your belt.Practice files - In addition, database files are included before and after each lesson, so you can follow along on your own (recommended), but if you need to "reset" back to a certain lesson you can go back to that file. For example, Lesson 10 will have two Access files - a before, in case you need to reset to the beginning, and an after - in case you just need to see the "solution" at the end.By the end of this course, you will be able to:Understand the structure of an Access database (tables, relationships, and queries)Build forms for entering and managing data without confusionCreate reports that summarize information clearly and professionallyTroubleshoot and adapt existing databases with confidenceUse a small amount of VBA to automate tasks, but only when it adds real valueThis course is for non-programmers, office professionals, and anyone who needs to make or maintain an Access database but doesn’t know where to start. If you’ve ever wished you could manage an Access system without relying on someone else, this course will give you the skills to take control.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Access Basics - Tables

Lecture 2 Preparing Tables in Excel

Lecture 3 Importing Tables into Access

Lecture 4 Relationships, Primary and Foreign Keys

Lecture 5 Creating Tables

Lecture 6 Referential Integrity

Lecture 7 Lesson 2 Addendum

Section 3: Access Basics - Queries

Lecture 8 Query Techniques

Lecture 9 Introduction to Queries

Section 4: Access Basics - Forms

Lecture 10 Forms Part 1

Lecture 11 Forms Part 2

Lecture 12 Forms Part 3

Section 5: Access Basics - Reports and Macros

Lecture 13 Reports Part 1

Lecture 14 Reports Part 2

Lecture 15 Macros

Section 6: Course Project

Lecture 16 Project 01A - Planning the Project

Lecture 17 Project 01B - Building the Main Menu

Lecture 18 Project 02 - Customers Form

Lecture 19 Project 03 - Products Form

Lecture 20 Project 04 - Beginning the Orders Form

Lecture 21 Project 05 - Continuing the Orders Form and Building Order Lines Subform

Lecture 22 Project 06 - Orders Search Part 1

Lecture 23 Project 07 - Orders Search Part 2

Lecture 24 Project 08 - Orders Form Continued - Opening Orders and Adding Phones

Lecture 25 Project 09 - Start Order Lines Subform

Lecture 26 Project 10 - Order Lines and Totals

Lecture 27 Project 11 - Deleting Order Lines, Phones and Emails

Lecture 28 Project 12A - Beginning the New Orders Process

Lecture 29 Project 12B - New Orders Form, Part 1

Lecture 30 Project 13A - New Orders Form, Part 2

Lecture 31 Project 13B - New Customers Form, Part 1

Lecture 32 Project 14A - New Customers Form, Part 2

Lecture 33 Project 14B - Adding New Phones and Emails on Orders

Lecture 34 Project 15 - Connecting New Orders to the Main Orders Form

Lecture 35 Project 16 - Finish Up Forms

Lecture 36 Project 17A - Reports Part 1

Lecture 37 Project 17B - Reports Part 2

Lecture 38 Project 18 - Splitting Databases, Course Conclusion

Small businesses or nonprofits without a dedicated IT staff who need to create or maintain a Microsoft Access database.,Office managers, administrators, or analysts who’ve inherited an Access database that’s broken or outdated, and don’t have access to the original developer.