OVERVIEW
Microsoft Access is a highly popular database application that comes standard in the Microsoft Office and Office 365 business software suites.
Access is an easy to learn program that enables you to create and manage databases that you can use to access and manipulate the data from within the application or allow it to be accessed by other programs for analysis and interpretation.
Even if you've never done programming you'll be surprised how quickly you can become productive with VBA!
Upon completing requirements for this module, the student will be able to:
- Be able to create and test vba subroutines and functions
- Be comfortable with moving to and from the vba editor
- Take control of the keyboard within forms
- Control interaction between forms and pass data back and forth
- Tie sorting to clicking on controls within forms
- Create and debug pull down filters on forms
- Create the capability to instantly search for records
- Use recordsets within forms to locate specific records
- Convert queries into SQL and place them inside vBA code
- Create complex reports using embedded queries and recordsets
- Secure forms by turning off resize and close capabilities
- Hide the menu and navigation pane and bring them back
and much, much more...
The duration of this module is 2 weeks.
Frequently Asked Questions
Short courses require no formal qualifications, degrees, or documentation.
However, we ask that you carefully read the admission criteria on each course page to determine whether it suits you.
if you have a laptop it's fine, however, the academy has computers you will use during lectures.
