Enable Technology

ACCESS BROMSGROVE TRAINING COURSES 

ACCESS TRAINING COURSES BROMSGROVE




About Enable Technology Bromsgrove Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the 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 can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in Bromsgrove. We are happy to discuss customising the course content should you have particular Access training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Royal Air Force, Fujistu PLC, Vodafone Group Services, Unipart Group, West Bromwich Building Society, Canadian High Commission, DHL Express and Nationwide Building Society Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bromsgrove
  • Telephone on 01952 938014
  • 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 ...
  • Writing an Error-Handling Routine
    Creating a Function Procedure
    Calling Procedures
    Creating a Sub Procedure
    Considering Variable Scope and Lifetime Together
    Using the Immediate Window to Call Procedures
    Trapping Errors with the On Error Statement
    Understanding Data Types
    Stepping through Code
    Locking Records for Updating
    Using the CacheSize Property - Optional
    Understanding the Order of Events
    Understanding Objects
    Declaring and Creating Object Variables
    Understanding the Form Object
    Understanding the DoCmd Object
    Understanding the Err Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Bromsgrove
  • 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 ...
  • Creating a Relational Database
    Working With Records
    Modifying Table Structures
    Macro Techniques
    Aggregation Queries
    Using a Navigation Form
    Parameter Queries
    An Introduction to VBA
    Navigation Pane Protection
    Adding Transactional Records
    DIY Forms
    Relational Database Design
    Creating and Using Reports
    Creating and Using Macros
    Database Security
    Querying Techniques
    Modifying Forms
    Understanding VBA
    Getting to Know Access 
    Creating and Using Forms
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Bromsgrove Enable Technology Training Courses

Report Builder - Bromsgrove SQL Server Reporting Services Training Courses
TSQL - Bromsgrove SQL Training Courses
SSAS Tabular - Bromsgrove SQL Server Analysis Services Training Courses
JQuery Bromsgrove Training Courses
DAX Bromsgrove Training Courses
Excel Power Pivot - Bromsgrove Excel Training Courses