ACCESS TRAINING COURSES KENILWORTH
About Enable Technology Kenilworth Access Training Courses
We offer intensive two and three days Access courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a venue near you in Kenilworth. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Loughborough University, Yell Group PLC, Birmingham City University, Birmingham City Council, Keele University, University of Birmingham, TalkTalk Direct Limited and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kenilworth
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with Boolean Expressions
Working with Inline Error Handling
Using the Do...Loop Structure
Understanding Constants
Working with the ADODB Recordset Object
Using the Select Case...End Select Structure
Stepping through Code
Understanding Errors
Calling Procedures
Controlling Program Execution
Using Visual Basic Help
Debugging Code
Using the If...End If Decision Structures
Working with Variable Lifetime
Understanding the DoCmd Object
Using Message Boxes
Specifying a Recordset Cursor Location - Optional
Working with the Code Editor
Microsoft Access
- 2 day course
- Location: Kenilworth
- 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 ... Data Validation
- See Training Course Details...
Macros on Forms
Macro Techniques
Adding Transactional Records
Database Security
Working With Records
Designing a Lookup Database
Action Queries
Navigation Pane Protection
Calculations in Queries
Sorting and Filtering
Adding Records to a Table
Parameter Queries
Aggregation Queries
Database Wellness
Querying Techniques
Understanding VBA
Creating Queries
DIY Forms
Creating and Using Reports
Relational Database Design
Email us about this courses
Other Kenilworth Enable Technology Training Courses
SSAS Tabular Kenilworth Training Courses
JQuery Mobile Kenilworth Training Courses
Excel 365 Intermediate - Kenilworth Excel Training Courses
Excel Power Pivot - Kenilworth Excel Training Courses
PL/SQL - Kenilworth SQL Training Courses
TSQL - Kenilworth SQL Training Courses