This course is currently in production. Enroll now!

In Production

This course is now in production. Enroll now to join in while these lessons are being developed and give your feedback!

Resources

• Full Course Lessons Page
• Course Topic Outline

Topics Covered

In Lesson 1, we are going to learn how to find the maximum value from multiple fields in the same record. For example, let's say you have 3 quiz grades, and you want to find the maximum grade. To do this we're going to use nested IIF functions, which we know how to do. We've done this in the Expert series but this is building up to something cool we're going to do in the next lesson with VBA.

In Lesson 2 we're going to take the example from Lesson 1 in which we found the greatest of three specific values and we're now going to turn it into a function so we can send any number of values to the function - could be 5, could be 50 - using something called a parameter array.

In Lesson 3 we are continuing with parameter arrays. We're going to learn more parameter array rules. We're going to learn how to loop through the items in the area with a For Each loop (instead of a For Next loop). We're going to see how we can pass different things to the array like objects. You can pass a list of fields to the function. We'll learn how to check for an empty array and the nothing value.

In Lesson 4, we will learn more stuff. This is just a placeholder. Real stuff coming soon...

Enroll Today

Enroll now so that you can participate with us as the videos are posted.

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.

Keywords

microsoft access, access 2016, access 2019, access 2021, access 365, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, parameter arrays, paramarray, array is empty, lbound, ubound, for each, is nothing, more...