Access Developer 16 Lessons

Welcome to Microsoft Access Developer 16. Total running time is 1 hour, 58 minutes.

S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark

          Only $44.99
          Members pay as low as $22.50

Lessons

Database Files

Resources

Full Course Description Page
Topic Outline
PDF Handbook
Video Lessons Download ZIP File (229 MB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

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 Developer 16 Lessons

Age	Subject	From
3 months	Developer 16 Lesson 5	Ken Wykoff
3 months	Developer 16 Lesson 2	Ken Wykoff
8 months	DAO.Recordset	Rolf Widmer
12 months	Scared of Alex	Andrew Shaw
2 years	Lesson 3 1507	Maggie M
2 years	German Language Problem SQL	Sebastian Respondek
2 years	trick	Leonard Duval
3 years	Form Record SourceRecordset	Sami Shamma
4 years	Recordset in a Subform	Lesli Cochran
4 years	If Statement in Recordset	Teeka Leone
4 years	StatusBox	Alexis Cao
5 years	List Box	Jim Baldner
6 years	Set Focus Fix	James Gray
6 years	Lesson 5 of developer 16	John Miller
6 years	D16 Lesson 5 Posted	Richard Rost
6 years	D16 Lesson 4 Posted	Richard Rost
6 years	Access D16 Lesson 3	Richard Rost
6 years	Access D16 Lesson 2 Posted	Richard Rost

Subscribe to Access Developer 16 Lessons
Get notifications when this page is updated

Intro

In lesson 16, we will continue working with multi-select list boxes in Microsoft Access, discuss whether it is possible to use formatting and color in list boxes, look at a clever workaround if it is not, and start working with recordsets to access table data directly in VBA code.

Transcript

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

In Developer 16, we are continuing our work with multi-select list boxes. We will learn whether or not it is possible to have formatting and color in list boxes. If it is not, we will learn a really cool workaround. Then we will begin working with recordsets to learn how to access the data in tables directly from our VB code.

I will be using Microsoft Access 2019 with my Microsoft 365 subscription in this class. These lessons should work for anybody using 2007 and up.

Of course, this is a Developer Level lesson. I strongly recommend that you have taken my Beginner, Expert, Advanced, and Developer lessons, levels 1 through 16.

Now it is time to get our learning caps on and get started with Lesson 1.

Quiz

Q1. What is the main topic covered in Microsoft Access Developer Level 16?
A. Multi-select list boxes and recordsets in Access
B. Creating tables in Access
C. Designing forms from scratch
D. Importing data from Excel

Q2. What formatting features are discussed regarding list boxes in this lesson?
A. Embedding images directly in list boxes
B. Adding sorting features to list boxes
C. Formatting and color in list boxes, and workarounds if not possible
D. Adding hyperlinks to list box items

Q3. What new concept related to data access will be introduced in this lesson?
A. Creating macros for automation
B. Working with queries only
C. Accessing data in tables directly from VB code using recordsets
D. Using relationships to connect tables

Q4. Which version of Microsoft Access is used by the instructor in this course?
A. Access 2003
B. Access 2007
C. Access 2019 with Microsoft 365 subscription
D. Access for Mac

Q5. Who is the instructor for Developer Level 16?
A. John Smith
B. Susan Jones
C. Richard Rost
D. Mary Johnson

Q6. Before taking this course, what does the instructor recommend?
A. Having experience with SQL only
B. Taking Beginner, Expert, Advanced, and Developer lessons 1 through 16
C. Using only Access 2013
D. Reading the Access user manual

Q7. For which versions of Microsoft Access will these lessons work?
A. 2003 and earlier only
B. 2007 and up
C. Access 365 only
D. Access Web App only

Answers: 1-A; 2-C; 3-C; 4-C; 5-C; 6-B; 7-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 Microsoft Access Developer Level 16. I am Richard Rost, your instructor for this course.

In this lesson, we will continue working with multi-select list boxes. We will explore whether it is possible to apply formatting and color within list boxes. If it turns out that native formatting options are not available, I will show you an interesting workaround that can achieve a similar effect. After that, we will start working with recordsets, which involves accessing and manipulating data in tables directly through VBA code.

For this course, I will be using Microsoft Access 2019 together with my Microsoft 365 subscription. However, the material covered should be applicable for anyone using Access 2007 or later versions.

As a reminder, this is an advanced Developer Level lesson. If you have not yet completed my Beginner, Expert, Advanced, and Developer series through level 16, I highly recommend doing so before starting this course.

Let's get started with Lesson 1 and continue building your Access development skills.

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

Multi-select list boxes in Access
Formatting and color in list boxes
Workaround for colored list boxes
Introduction to recordsets in VBA
Accessing table data directly with VB code