Lessons

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Comments for Access Advanced 1

Age	Subject	From
3 years	Quotes	Mohei Eldin Fouad
3 years	Requery is not working	Arvind Singh
9 years	Microsoft Access Advanced 1	Ngala Elvis F.
10 years	Microsoft Access Advanced 1	Sulaiman Jalloh
10 years	Microsoft Access Advanced 1	Yasir
10 years	Microsoft Access Advanced 1	Dennis O

Subscribe to Access Advanced 1
Get notifications when this page is updated

Intro

In this lesson, you will learn advanced techniques for using macros in Microsoft Access. We will discuss what macros are, their advantages and limitations, and review sample macros from a real-world database. You will see how to build both standalone and embedded macros, make your macros more intelligent using the if-then-else statement, and explore different form events like opening, closing, and switching forms. This is Advanced Level 1.

Transcript

Welcome to Microsoft Access Advanced Level 1, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.

Welcome to the Advanced Series of Lessons. This is the first lesson in the Advanced Series. If you have never taken any of my classes before, there are nine beginner lessons. There are 32, I believe, expert lessons. This is the first advanced lesson, where we are going to talk about macros and events and things like that.

The series after this is the developer series, where we are going to talk about Visual Basic programming. The Advanced Series will focus on things that are a little more difficult than just building a database, but do not quite involve programming yet. We are going to get into macros, events, and a whole lot of other stuff.

As far as prerequisites go, I do strongly recommend that you take my beginner series and my expert classes, levels 1 through 32. Before taking this course, I assume you know certain things at the Advanced Class of the day. I assume you know most of the stuff that we covered in the expert series. So if you do not know basic form design, relationships, or anything like that, then definitely watch the expert classes first.

This class was recorded using Microsoft Access 2016, Office 365. Everything covered should work from 2007 until 2013. If you are using anything before 2007, then this class will not work for you because Microsoft dramatically changed the way that macros work in Access 2007.

Today's class is all about macros. Let's take a look at what is covered in each lesson.

In lesson 1, we are going to learn what macros are, the benefits of macros, the limitations of macros, and we will review some of the macros we have already created in our PC resale customer database.

In lesson 2, we are going to build some macros. We are going to build a standalone macro and a macro that is embedded in a form button.

In lesson 3, we are going to learn how to make our macros smart. We will learn how to open specific records from our macros, and we will learn about the if, then, else statement.

In lesson 4, we want to learn about a bunch of different events that occur when you open and close forms and switch between them.

Thanks for watching.

Quiz

Q1. What is the main focus of the Microsoft Access Advanced Level 1 course?
A. Database security settings
B. Building basic tables and queries
C. Working with macros and events
D. Advanced Visual Basic programming

Q2. Which series follows the Advanced Series in Richard Rost's Access courses?
A. Expert Series
B. Beginner Series
C. Developer Series
D. Intermediate Series

Q3. Which Microsoft Access versions does the recorded class specifically support?
A. All versions including before 2007
B. Only Access 2019 and newer
C. Versions from 2007 to 2013, including 2016 and Office 365
D. Only Access 2007

Q4. What is a recommended prerequisite before taking this Advanced Level 1 course?
A. Completion of the beginner and expert series (levels 1-32)
B. Programming experience in Visual Basic
C. Prior knowledge of macros only
D. No prior knowledge is necessary

Q5. Why is Access 2007 or newer required for this course?
A. Because the course only covers web databases
B. Because macros work fundamentally differently in 2007 and later
C. Access 2007 and later have a new report designer
D. The user interface was rebranded after 2007

Q6. What topics are covered in the first lesson of this Advanced Level 1 course?
A. Introduction to VBA code
B. What macros are, their benefits, their limitations, and reviewing sample macros
C. Creating custom ribbons in Access
D. Database security with passwords

Q7. What will be taught in lesson 2 of the course?
A. Advanced table indexing
B. Building standalone and embedded macros in form buttons
C. How to export data to Excel
D. Customizing navigation panes

Q8. Which concept is introduced in lesson 3?
A. User-level security
B. Queries with parameter prompts
C. Making macros smart with if, then, else statements and opening specific records
D. Relationships between tables

Q9. What events are the focus of lesson 4?
A. Events for importing external data
B. Events that occur when opening, closing, or switching between forms
C. Events related to table creation
D. Events for setting up relationships

Answers: 1-C; 2-C; 3-C; 4-A; 5-B; 6-B; 7-B; 8-C; 9-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone is the first lesson in my Microsoft Access Advanced Level 1 series. I am Richard Rost, your instructor.

This advanced series is designed for those who have already completed the beginner and expert level lessons. There are nine beginner classes and thirty-two expert lessons that cover all the foundational material you'll need. This course picks up where those leave off, introducing more advanced topics such as macros and event handling. We will not get into Visual Basic programming just yet; that is reserved for the developer series, which follows this one.

The focus of this class is on macros and events, providing you with skills that go beyond basic database construction but stop short of full programming. I strongly recommend that you complete the beginner and expert level courses before starting this series. I am going to assume you are already comfortable with things like basic form design and establishing table relationships. If those topics are still unclear, you should revisit the expert lessons.

This course was recorded using Microsoft Access 2016, Office 365 edition. However, everything we discuss here should also be applicable to Access versions 2007 through 2013. If you are using Access 2003 or earlier, you'll need to be aware that macros and many other features changed significantly starting with Access 2007, so this study track will not be compatible with those older versions.

Today, we are diving into macros. Here is what you can expect from each lesson in this course:

- In the first lesson, I will explain what macros are, the advantages they provide, and their limitations. We will also revisit some of the macros that we created earlier in the PC resale customer database.
- In lesson two, we will build new macros, including both standalone macros and those embedded within form buttons.
- Lesson three focuses on making our macros smarter. You will learn how to design macros that open specific records, and we will cover using if, then, and else statements.
- In lesson four, we will explore the various events that occur when opening, closing, and switching between forms.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Introduction to macros in Microsoft Access
Benefits and limitations of macros
Reviewing sample macros in a database
Building standalone macros
Creating embedded macros in form buttons
Using macros to open specific records
Implementing if then else logic in macros
Understanding form events when opening and closing
Working with events for switching between forms