ACCESS TRAINING COURSES LEAMINGTON SPA
About Enable Technology Leamington Spa Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Leamington Spa. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Total Telecommunications Limited, Birmingham Heartlands Hospital, Nationwide Building Society Limited, Norfolk Police Constabulary, Yell Group PLC, Keele University, Fujistu PLC and South Staffordshire Water PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leamington Spa
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using the Immediate Window to Call Procedures
- See Training Course Details...
Understanding Error Handling
Using the With Statement
Controlling Program Execution
Writing an Error-Handling Routine
Understanding Modules
Determining the Value of Expressions
Working with Properties
Introduction to Programming in Access
Declaring Variables
Understanding Expressions and Statements
Understanding VBA's Error Trapping Options
Working with Variable Scope
Naming Procedures
Specifying a Recordset Cursor Location - Optional
Specifying a Recordset Cursor Type
Working with Methods
Understanding the Err Object
Working with Boolean Expressions
Microsoft Access
- 2 day course
- Location: Leamington Spa
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... DIY Forms
- See Training Course Details...
Creating Queries
An Introduction to VBA
Adding Records to a Table
Using a Navigation Form
Database Wellness
Creating and Using Reports
Navigation Pane Protection
Importing and Exporting Records
Working With Records
Macros on Forms
Creating and Using Macros
Creating and Using Forms
Querying Techniques
Calculations in Queries
Designing a Lookup Database
Aggregation Queries
Setting Table Relationships
Understanding VBA
Data Validation
Macro Techniques
Email us about this courses
Other Leamington Spa Enable Technology Training Courses
DAX Leamington Spa Training Courses
SSIS - Leamington Spa SQL Server Integration Services Training Courses
SSAS Tabular - Leamington Spa SQL Server Analysis Services Training Courses
SSRS Leamington Spa Training Courses
Excel 365 Advanced Leamington Spa Training Courses
Power Query Leamington Spa Training Courses