Join Curt Frye for an in-depth discussion in this video What you should know, part of Access: VBA.
- [Instructor] Before I get started with the main part of this course, there are a few things that I thought you should know about my approach and Microsoft Access programming, in general. The first is that it'd be very helpful if you know how to create and manipulate Access database objects. A lot of things that I do in these movies assume that you already know how to create forms and so on, so I go through them pretty quickly. Second of all, when I refer to variables, which hold values, I will often use a prefix, such as cur for currency values or S for strings.
So I might refer to a variable spelled curSale as either the sale variable or a curSale, it all depends on how I feel in the moment as I am saying a sentence. So you can ignore the prefix, almost always that tells you what type of variable I'm working with and just focus on the last part. Also, Access databases can be large. So rather than have a lot of files of a couple of megabytes, I decided to work in a single database. And what that means is that the database you work with might look different after you've worked with it for a bit.
So that means that certain code modules might appear over on the left side of the Visual Basic Editor that you don't see in the movie. Or you might see things in the movie you don't see on your own screen. Don't worry about it, that's normal. You'll have everything you need to complete the exercises. And finally, you should have a willingness to explore. Access is a vast program and it's an extremely powerful and yet, extremely usable, consumer database. So don't be afraid to dig around and see what you can find.
- Working with macros
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Manipulating database objects
- Adding, editing, and deleting records
- Looking up values in a table
- Automating processes with macros
Skill Level Advanced
What you should know1m 38s
1. Introduction to Visual Basic for Applications
2. Define Variables, Constants, and Calculations
3. Add Logic to Your VBA Code
4. Debug Your VBA Code
5. Manipulate Database Objects Using DoCmd
6. Read and Manipulate Table Data
7. Manipulate a Database Using the Application Object
8. Control Forms and Reports Using the Me Object
9. Automate Processes Using Macros
Next steps1m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.