ACCESS TRAINING COURSES MAESTEG
About Enable Technology Maesteg Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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. We also offer the option of scheduling of Access course at a venue near you in Maesteg. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Royal & Sun Alliance Group PLC, Norfolk Police Constabulary, Lloyds TSB Bank PLC, University of Birmingham, GKN PLC, South Staffordshire Water PLC, Birmingham City Council and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Maesteg
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Procedures
- See Training Course Details...
Using Input Boxes
Why Program in Access?
Working with Events
Understanding the Order of Events
Working with Variable Scope
Using Expressions, Variables, and Intrinsic Functions
Understanding Modules
Using Break Mode during Run Mode
Using the Do...Loop Structure
Using Intrinsic Functions
Working with the Application Object
Setting Breakpoints
Stepping through Code
Understanding the Development Environment
Working with Properties
Naming Procedures
Using the CacheSize Property - Optional
Microsoft Access
- 2 day course
- Location: Maesteg
- 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 ... Designing a Lookup Database
- See Training Course Details...
Aggregation Queries
Action Queries
Creating Queries
Database Wellness
Parameter Queries
Using a Navigation Form
Macro Techniques
Understanding VBA
Data Validation
Creating a Lookup Database
DIY Forms
Working With Records
Adding Transactional Records
Calculations in Queries
Database Security
Multi Table Queries
Modifying Table Structures
Modifying Forms
Sorting and Filtering
Setting Table Relationships
Email us about this courses
Other Maesteg Enable Technology Training Courses
SSAS Tabular - Maesteg SQL Server Analysis Services Training Courses
Data Warehouse - Maesteg SQL Training Courses
Excel 365 Basic - Maesteg Excel Training Courses
Power Query - Maesteg Excel Training Courses
Excel Power Pivot Maesteg Training Courses
Excel 365 Advanced - Maesteg Excel Training Courses