ACCESS TRAINING COURSES BOOTLE
About Enable Technology Bootle Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. 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. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Bootle. 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Unipart Group, Homeserve PLC, Royal Air Force, West Bromwich Building Society, Shell UK Oil Products Ltd, Nuclear Engineering Services, Halfords Group PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: Bootle
- 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 ... Setting Table Relationships
- See Training Course Details...
Calculations in Queries
Macro Techniques
DIY Forms
Modifying Forms
Formatting Tables
Creating and Using Forms
Creating a Relational Database
Sorting and Filtering
Working With Records
Creating a Lookup Database
Database Wellness
An Introduction to VBA
Modifying Table Structures
Parameter Queries
Adding Records to a Table
Getting to Know Access
Aggregation Queries
Using a Navigation Form
Adding Transactional Records
Database Security
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bootle
- 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 ... Understanding Expressions and Statements
- See Training Course Details...
Understanding Control-of-Flow Structures
Using the For Each...Next Structure
Using the Immediate Window to Call Procedures
Working with Boolean Expressions
Writing an Error-Handling Routine
Understanding the DoCmd Object
Working with Methods
Understanding the Form Object
Controlling Program Execution
Working with the ADODB Recordset Object
Setting Breakpoints
Working with Procedures and Functions
Creating a Function Procedure
Debugging Code
Using Break Mode during Run Mode
Working with the Application Object
Using the If...End If Decision Structures
Understanding Recordset Cursor Properties - Optional
Email us about this courses
Other Bootle Enable Technology Training Courses
Excel 365 Advanced - Bootle Excel Training Courses
SSIS Bootle Training Courses
SSAS - Bootle SQL Server Analysis Services Training Courses
Power Query Bootle Training Courses
Power BI - Bootle Microsoft Power BI Training Courses
Excel 365 Intermediate Bootle Training Courses