ACCESS TRAINING COURSES WELLS
About Enable Technology Wells Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local training site in Wells. All Access courses can be customised to meet your particular requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Norfolk Police Constabulary, Royal & Sun Alliance Group PLC, University of Birmingham, Boots UK Limited, Carillion PLC, South Staffordshire Water PLC, Fujistu PLC and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wells
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding VBA's Error Trapping Options
- See Training Course Details...
Declaring and Creating Object Variables
Using Visual Basic Help
Naming Procedures
Understanding Objects
Understanding Errors
Determining the Value of Expressions
Using the Immediate Window to Call Procedures
Understanding Procedures
Using Input Boxes
Using Break Mode during Run Mode
Locking Records for Updating
Creating a Function Procedure
Understanding Error Handling
Understanding Classes and Objects
Using Debugging Tools
Microsoft Access
- 2 day course
- Location: Wells
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Modifying Forms
Understanding VBA
Data Validation
Importing and Exporting Records
Working With Records
Navigation Pane Protection
Sorting and Filtering
Aggregation Queries
DIY Forms
Adding Transactional Records
Action Queries
Getting to Know Access
An Introduction to VBA
Creating Queries
Multi Table Queries
Creating and Using Forms
Designing a Lookup Database
Macros on Forms
Database Wellness
Adding Records to a Table
Email us about this courses
Other Wells Enable Technology Training Courses
SSRS - Wells SQL Server Reporting Services Training Courses
Excel 365 Basic - Wells Excel Training Courses
VBA Wells Training Courses
JQuery - Wells JavaScript Training Courses
DAX Wells Training Courses
Power BI Wells Training Courses