From the course: Access: VBA

What you should know

From the course: Access: VBA

Start my 1-month free trial

What you should know

“

- [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.

Contents