The Visual Basic Editor is a programming environment designed to help you write Access VBA code. In this video, learn how to work in the Visual Basic Editor.
- [Instructor] When you write or edit VBA code in Access,…you'll do so using the Visual Basic Editor.…The editor gives you all the tools you need…to manage your code effectively.…When you're in an Access database window,…there are two ways to get to the Visual Basic Editor.…The first is to go to the create tab on the ribbon,…and click Visual Basic.…Or as the tools tip shows, you can also press ALT+F11.…That's the shortcut I'll use most of the time.…So I'll go ahead and press ALT+F11,…and we're in the Visual Basic Editor.…
When you open the Visual Basic Editor,…you should see two panels over on the left.…The first is the project explorer…and that contains code, if any,…for the current Access Database…as well as any other Microsoft Office programs…you might have open.…And then below that there is the Properties panel.…And that displays properties…for anything that you might have open.…That could be a code module,…code associated with the form and so on.…If you don't see the project explore, for example,…if it's been closed,…
- 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.