ACCESS TRAINING COURSES BRISTOL
About Enable Technology Bristol Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Bristol. All Access courses can be customised to meet your particular requirements.
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 Wolverhampton City Council, Unipart Group, Aston University, Cadbury PLC, Vodafone Group Services, Nationwide Building Society Limited, Norwich Union PLC and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Bristol
- 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...
Database Wellness
Aggregation Queries
Macro Techniques
Adding Records to a Table
Querying Techniques
Action Queries
Modifying Table Structures
Multi Table Queries
Getting to Know Access
Designing a Lookup Database
Parameter Queries
Formatting Tables
Creating and Using Forms
Modifying Forms
Creating Queries
Macros on Forms
Navigation Pane Protection
Setting Table Relationships
Creating and Using Reports
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bristol
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Using the CacheSize Property - Optional
Trapping Errors with the On Error Statement
Handling Errors
Working with Procedures and Functions
Understanding Objects
Understanding the Order of Events
Understanding the Development Environment
Declaring Variables
Using the Select Case...End Select Structure
Considering Variable Scope and Lifetime Together
Using Break Mode during Run Mode
Understanding the Form Object
Understanding Classes and Objects
Working with Boolean Expressions
Working with the ADODB Recordset Object
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Email us about this courses
Other Bristol Enable Technology Training Courses
Power Query Bristol Training Courses
Excel 365 Intermediate Bristol Training Courses
Excel 365 Basic - Bristol Excel Training Courses
SSIS Bristol Training Courses
Excel Power Pivot - Bristol Excel Training Courses
JavaScript Bristol Training Courses