Microsoft Access VBA Introduction Training Course Outline
Audience: This Access VBA introduction course is designed for existing Access users who need to use VBA to automate database tasks or simplify complex database sequences.
Course Duration: 2 days
We are happy to arrange for a trainer to contact you to help tailor you course.
Course Availability: Monday – Saturday
Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.
Course Location: This Access VBA introduction training course can be delivered either at our London training venue or at your offices.
Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.
At Course Completion
After completing this course, students will be able to:
- Use the VBA code editor
- Create message boxes and variables
- Create function procedures
- Understand Visual Basic concepts
- Trigger code in various ways
- Create loops
- Manipulate Recordsets
- Debug procedures and handle errors
- Automate Forms
- Link to Excel and Word
- Modify queries
Module 1: The VBA code editor
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
Module 2: Messages and variables
- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables
Module 3: Creating functions
- Passing arguments
- Returning values
Module 4: Visual Basic explained
- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA
Module 5: Triggering code
- Attaching code to forms
- Attaching code to buttons
- Attaching code to events
- Manipulating form/control properties
- Making code not form-specific
Module 6: Looping
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
Module 7: Recordsets
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
Module 8: Debugging and error handling
- Stepping through macros
- Setting breakpoints
- Trapping for errors
- Case studies
Module 9: Automating Forms
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms
Module 10: Linking to Excel and Word
- Referencing other applications
- Manipulating Excel from Access
Module 11: Modifying queries
- Basic SQL statements
- Amending queries’ SQL
Microsoft Office Access 2016 (also known as Microsoft Access, or simply Access) is a database application. In this context, data refers to information that is usually in the form of text or numbers, and this information is stored in a table. Information in one table may relate to information in zero, one, or many other tables. One or more tables of information, when grouped together in a logical way, are collectively referred to as a database.
Access is designed to enter, edit, and analyze the data in a database. Queries are used to extract information from the tables based on search criteria. You can use a form as a user-friendly method of viewing, entering, or modifying data. Access can also generate reports (such as quarterly sales by each employee) based on the data in the database.
Microsoft Access is the Microsoft Office relational database product. It is only available on the PC platform and is not available for Mac OSX Microsoft Access is used for efficient data management and storage. It is primarily used to track and manage very large quantities of data: like customer’s contact details, order numbers etc.
Mouses Microsoft training courses take you on a journey from being a complete beginner through to an advanced user who will then be able to make full use of the application’s capabilities and beyond.
Taught by highly efficient, expert MCT trainers with many years of experience our hands-on courses mean that you will gain practical experience as well as useful tips and tricks. Full access to our extensive library of software help guides is included in the price.
- Microsoft Access Training courses London