ACCESS TRAINING COURSES NEATH
About Enable Technology Neath Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local venue in Neath. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: University of Birmingham, Nuclear Engineering Services, GKN PLC, Barclays Bank PLC, EDF Energy PLC, Capita Group PLC, Royal & Sun Alliance Group PLC and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Neath
- 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 ... Multi Table Queries
- See Training Course Details...
Formatting Tables
Navigation Pane Protection
DIY Forms
Setting Table Relationships
Modifying Table Structures
Macro Techniques
Getting to Know Access
Creating a Relational Database
Adding Records to a Table
Designing a Lookup Database
An Introduction to VBA
Modifying Forms
Creating a Lookup Database
Relational Database Design
Database Security
Data Validation
Sorting and Filtering
Creating Queries
Action Queries
Adding Transactional Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Neath
- 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 the Select Case...End Select Structure
- See Training Course Details...
Working with Procedures and Functions
Using Input Boxes
Understanding the Form Object
Using the For...Next Structure
Organizing Code and Procedures
Using the Object Browser
Setting Break Expressions
Working with Inline Error Handling
Debugging Code
Naming Procedures
Understanding Objects
Working with Events
Understanding Collections
Using Break Mode during Run Mode
Determining the Value of Expressions
Understanding Procedures
Understanding Data Types
Email us about this courses
Other Neath Enable Technology Training Courses
PL/SQL - Neath SQL Training Courses
SQL - Neath SQL Training Courses
SSRS Neath Training Courses
Data Warehouse Neath Training Courses
DAX Neath Training Courses
VBA Neath Training Courses