|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Welcome Welcome! Multi-Select List Box Tips Welcome to Microsoft Access Developer Level 16. In this course we will continue working with multi-select list boxes, discuss whether formatting and color can be used in list boxes, and explore a useful workaround if that is not possible. We will also begin working with record sets to see how to access data and tables directly from Visual Basic code. This course is designed for students who have already completed the Beginner, Expert, Advanced, and Developer lessons through Level 16, and is demonstrated using Microsoft Access 2019, though it should work for versions 2007 and newer. NavigationKeywordsAccess Developer, multi-select list box, list box formatting, list box color, list box workaround, recordsets, vba recordsets, access tables via vba, access listbox formatting, vba listbox color, access vba code, access 2019, microsoft 365
More InformationTranscriptWelcome 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 are going to learn whether or not it is possible to have formatting and color in list boxes. If it is not, we are going to learn a really cool workaround. Then we are going to begin working with record sets to learn how to access the data and 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. IntroWelcome to Microsoft Access Developer Level 16. In this course we will continue working with multi-select list boxes, discuss whether formatting and color can be used in list boxes, and explore a useful workaround if that is not possible. We will also begin working with record sets to see how to access data and tables directly from Visual Basic code. This course is designed for students who have already completed the Beginner, Expert, Advanced, and Developer lessons through Level 16, and is demonstrated using Microsoft Access 2019, though it should work for versions 2007 and newer. QuizQ1. What is the main topic covered in Developer 16 of the Microsoft Access course? A. Multi-select list boxes and their formatting options B. How to create reports in Access C. The basics of SQL queries in Access D. Managing security in Access databases Q2. What is discussed regarding formatting and color in list boxes? A. It is fully supported in Access and easy to implement B. It is not possible, but a workaround will be shown C. It is only available in Access 2021 and newer D. It is managed entirely through table properties Q3. What programming method will be introduced to work directly with tables and data? A. Macros B. Queries C. Recordsets in VB code D. Relationships Q4. Which version of Microsoft Access does the instructor use for this class? A. Microsoft Access 2003 B. Microsoft Access 2016 Standalone C. Microsoft Access 2019 with Microsoft 365 subscription D. Microsoft Access 2010 Starter Edition Q5. For which audience is this Developer Level lesson recommended? A. Absolute beginners with no prior Access experience B. Users who have only completed beginner lessons C. Those who have completed Beginner, Expert, Advanced, and Developer levels 1-16 D. Anyone interested in learning about databases Q6. What is suggested before starting with Developer 16? A. Take a break and come back later B. Practice SQL joins C. Complete all previous lessons up to Developer Level 16 D. Buy a new computer Answers: 1-A; 2-B; 3-C; 4-C; 5-C; 6-C 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. SummaryToday's video from Access Learning Zone focuses on Developer Level 16, where we continue exploring multi-select list boxes in Microsoft Access. I will address whether it is possible to apply formatting and color to list box items, and if it turns out that it can't be done natively, I'll show you an effective workaround to achieve a similar result. Next, we'll start working with record sets. This part of the lesson will teach you how to interact directly with data and tables using Visual Basic for Applications (VBA) code in Access. For this session, I'm using Microsoft Access 2019 with my Microsoft 365 subscription, but the material should be applicable if you're using Access 2007 or any newer version. I want to remind you that this is a Developer Level class, so you should already be familiar with Access at the Beginner, Expert, and Advanced levels, as well as Developer lessons 1 through 15. This background will help you get the most out of these lessons. Let's get ready to learn. 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 ListWorking with multi-select list boxes Exploring formatting and color options in list boxes Creating a workaround for list box formatting limitations Accessing data and tables directly from VBA code using recordsets Primary Topics
multi-select list boxes, list box formatting, list box color, formatting workarounds, recordsets, VBA data access Secondary Topics
version compatibility, course prerequisites |
||
|
| |||
| Keywords: Access Developer, multi-select list box, list box formatting, list box color, list box workaround, recordsets, vba recordsets, access tables via vba, access listbox formatting, vba listbox color, access vba code, access 2019, microsoft 365 PermaLink How To Use Multi-Select List Boxes With Formatting and Recordsets in Microsoft Access |
