Enable Technology

ACCESS MACCLESFIELD TRAINING COURSES 

ACCESS TRAINING COURSES MACCLESFIELD




About Enable Technology Macclesfield Access Training Courses

We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Macclesfield. We will work with you prior to the course to tailor the Access syllabus to match your 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Dollond & Aitchison Limited, Birmingham City Council, GKN PLC, South Staffordshire Water PLC, Countrywide Homes Limited, TalkTalk Direct Limited, Wolverhampton City Council and Vodafone Group Services.




Microsoft Access

  • 2 day course
  • Location: Macclesfield
  • 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 ...
  • Macro Techniques
    Setting Table Relationships
    Database Security
    Using a Navigation Form
    Macros on Forms
    Creating and Using Reports
    An Introduction to VBA
    Creating and Using Macros
    Creating Queries
    Adding Records to a Table
    Adding Transactional Records
    DIY Forms
    Multi Table Queries
    Navigation Pane Protection
    Sorting and Filtering
    Modifying Forms
    Aggregation Queries
    Action Queries
    Database Wellness
    Importing and Exporting Records
    Creating a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Macclesfield
  • 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 ...
  • Declaring and Creating Object Variables
    Understanding Modules
    Using Expressions, Variables, and Intrinsic Functions
    Working with the Code Editor
    Understanding the DoCmd Object
    Setting Breakpoints
    Why Program in Access?
    Using the Do...Loop Structure
    Organizing Code and Procedures
    Working with Procedures and Functions
    Using Intrinsic Functions
    Calling Procedures
    Working with Properties
    Declaring Variables
    Locking Records for Updating
    Creating a Function Procedure
    Understanding Classes and Objects
    Using the With Statement
    Determining the Value of Expressions
    Naming Procedures
    Understanding Expressions and Statements

  • See Training Course Details...



Email us about this courses



Other Macclesfield Enable Technology Training Courses

DAX Macclesfield Training Courses
Power Query Macclesfield Training Courses
JQuery Mobile - Macclesfield JavaScript Training Courses
VBA Macclesfield Training Courses
TSQL - Macclesfield SQL Training Courses
Excel 365 Advanced - Macclesfield Excel Training Courses