ACCESS TRAINING COURSES BEDWAS
About Enable Technology Bedwas Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Bedwas. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Total Telecommunications Limited, University of Birmingham, Birmingham City University, South Staffordshire Water PLC, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, Shell UK Oil Products Ltd and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bedwas
- 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 ... Setting Breakpoints
- See Training Course Details...
Calling Procedures
Understanding Modules
Using Break Mode during Run Mode
Guidelines for use of Branching Structures
Understanding the Err Object
Understanding Data Types
Controlling Program Execution
Using the With Statement
Understanding Expressions and Statements
Creating a Function Procedure
Working with the ADODB Recordset Object
Working with the Application Object
Working with Properties
Using Intrinsic Functions
Understanding Collections
Using Message Boxes
Trapping Errors with the On Error Statement
Understanding Errors
Using the For...Next Structure
Understanding Objects
Microsoft Access
- 2 day course
- Location: Bedwas
- 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 ... Designing a Lookup Database
- See Training Course Details...
Parameter Queries
Importing and Exporting Records
An Introduction to VBA
Sorting and Filtering
Adding Transactional Records
Multi Table Queries
Setting Table Relationships
Adding Records to a Table
Database Wellness
Macro Techniques
Action Queries
Calculations in Queries
Creating and Using Macros
Modifying Forms
Understanding VBA
Creating Queries
Aggregation Queries
Creating a Lookup Database
Navigation Pane Protection
Modifying Table Structures
Email us about this courses
Other Bedwas Enable Technology Training Courses
SQL Bedwas Training Courses
Power Query - Bedwas Excel Training Courses
JQuery - Bedwas JavaScript Training Courses
Excel Power Pivot Bedwas Training Courses
Excel 365 Advanced Bedwas Training Courses
SSAS Tabular - Bedwas SQL Server Analysis Services Training Courses