Welcome

Welcome! Calculator & Commission Forms VBA

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

Welcome to Microsoft Access Developer Level 2. In this course we will build on Access Developer Level 1 by working with Visual Basic programming and related topics. We will talk about prerequisites, versions of Access that are supported, and resources for the course database. The lessons will cover building a calculator form using VBA, creating custom subs, working with parameters and the Select Case statement, and building a sales rep commission calculator.

Navigation

Prev: D02
Next: Lesson 01

Keywords

Access Developer, VBA, calculator form, Visual Basic programming, custom sub, Select Case statement, sales rep commissions, commission form, Access 2016, Office 365, build calculator, parameter in VBA, VBA code, advanced macros

Subscribe to Welcome
Get notifications when this page is updated

More Information

Transcript

Welcome to Microsoft Access Developer Level 2 brought to you by AccessLearningsOn.com. I am your instructor Richard Rost.

Welcome to the Developer Series of Places. The Developer Series of Places covers Visual Basic programming and all kinds of other good stuff. It follows Access Developer Level 1. So this is Level 2 in the Developer Series.

You should have also completed my Beginner, Expert, and optionally the Advanced Series. The Advanced Series is mostly macros and a lot of people do not necessarily need to learn macros, but Beginner and Expert for sure and of course make sure you have finished Access Developer Level 1 before taking this class.

This class was recorded using Microsoft Access 2016. Everything should work pretty much fine for you if you are using 2013, 2010, probably 2007. If you are going all the way back to 2003, I think most of what I have covered in today's class will also be available. If you have that old of a version of Access, it is time to upgrade.

I recommend you move up to at least 2013, but 2016 is where it should be. Get an Office 365 subscription. A couple of dollars a month and is well worth it. All the upgrades, all the updates.

The database for today's class can be found there: 599-cv.com-slash-databases. You do not have to download that database to build today's project. You can start from scratch. We are going to be building a brand-new couple of forms that were not in the database from before. If you want to download it, go ahead, but you do not need it for today's class.

Let us take a look at what is covered in today's class.

In lesson 1, we are going to start using VBA to build a calculator form.

In lesson 2, we are continuing with our calculator. We are going to get a little more advanced with our Visual Basic code. We are going to learn some things like creating a custom sub and adding some parameters and learning the Select Case statement.

In lesson 3, we are going to build another type of calculator to calculate sales rep commissions.

In lesson 4, we are continuing with the commission form that we started in lesson 3.

Thank you.

Intro

Quiz

Q1. What is the main focus of Microsoft Access Developer Level 2?
A. Visual Basic programming and advanced development techniques
B. Creating reports in Access
C. Learning database security
D. Importing data from Excel

Q2. What is recommended before taking Access Developer Level 2?
A. Completing only the Expert Series
B. Completing the Beginner and Expert Series, and Developer Level 1
C. Completing only the Advanced Series
D. Starting with Level 2 directly

Q3. Which versions of Access will most features in this class work with?
A. Only Access 2016
B. Access 2010, 2013, and 2016, possibly 2007 and 2003
C. Only Access 2007 and earlier
D. Only Access 365

Q4. What is mostly covered in the Access Advanced Series, according to the instructor?
A. Macros
B. SQL programming
C. Table design
D. VBA programming

Q5. What is suggested regarding upgrading Microsoft Access?
A. Upgrade to at least Access 2013, ideally 2016 or Office 365
B. Remain on Access 2003 for compatibility
C. Use Access 2007 because it is free
D. Downgrade to Access 2010

Q6. Where can you find the database for the class?
A. 599-cv.com-slash-databases
B. accesslearningson.com-databases
C. Provided as an email attachment
D. On Microsoft's website

Q7. Do you have to download the class database to complete the project?
A. No, you can start from scratch with new forms
B. Yes, it is required for all activities
C. Only if you are using Access 2003
D. Only if using Office 365

Q8. What is the primary topic in lesson 1?
A. Using VBA to build a calculator form
B. Designing a report
C. Creating macros
D. Data import features

Q9. What programming concept is introduced in lesson 2?
A. Custom subroutines with parameters and Select Case statement
B. Referential integrity
C. Table normalization
D. Data encryption

Q10. What type of project is the focus in lessons 3 and 4?
A. A sales rep commission calculator form
B. Report design
C. User security module
D. Macros for navigation

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

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 part of the Developer Series, specifically Access Developer Level 2, presented by AccessLearningsOn.com. I'm Richard Rost, your instructor for this course.

In the Developer Series of Places, we focus on Visual Basic programming in Microsoft Access and many advanced topics that go beyond what was covered in the previous level. This course builds on the foundation you should have already established in Beginner and Expert levels. Taking the Advanced series is optional, as it centers on macros, and not everyone needs to cover those, but you absolutely should have finished Developer Level 1 before working through this class.

All the material in this class was recorded using Access 2016, but the concepts and techniques will work in Access 2013, 2010, and most likely even in 2007. If you still use Access 2003, most parts of this course will apply, although it's definitely time to consider upgrading. I recommend using Access 2016 or at least 2013 under an Office 365 subscription, which gives you ongoing updates and features for just a small monthly fee.

You can find the example database used in today's lessons at 599-cv.com/databases, but downloading it is not required. We'll be creating new forms during this course, so you can start from an empty database if you wish. If you do want the sample file, it's available, but not essential.

Here is what we will cover in this class. In lesson 1, you will learn how to use VBA in Access to build a calculator form. Lesson 2 continues the calculator example, taking the Visual Basic code further by introducing how to create a custom subroutine, work with parameters, and use the Select Case statement. For lesson 3, we will set up a new calculator specifically for calculating sales rep commissions. Lesson 4 continues this work and develops the commission form further to handle more complex requirements.

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

Building a calculator form with VBA in Access
Writing Visual Basic code for form controls
Creating custom subs with parameters in VBA
Using the Select Case statement in VBA
Developing a sales rep commission calculator
Continuing and refining the commission form

Primary Topics

Access VBA programming, calculator form creation, custom subs and parameters, Select Case statement, commission form development

Secondary Topics

Access version compatibility, database download options, Office 365 recommendations