Enable Technology

ACCESS TIPTON TRAINING COURSES 

ACCESS TRAINING COURSES TIPTON




About Enable Technology Tipton Access Training Courses

Enable Technology offer short intensive skills based Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to 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.

Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a Access course at an alternative training site in Tipton. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Homeserve PLC, Lloyds TSB Bank PLC, Capita Group PLC, South Staffordshire Water PLC, Keele University, Norfolk Police Constabulary, Birmingham City Council and Dollond & Aitchison Limited.




Microsoft Access

  • 2 day course
  • Location: Tipton
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Adding Transactional Records
    Action Queries
    Modifying Table Structures
    Macro Techniques
    DIY Forms
    Relational Database Design
    Sorting and Filtering
    Multi Table Queries
    Creating a Lookup Database
    Data Validation
    Understanding VBA
    Aggregation Queries
    Creating and Using Macros
    Creating and Using Reports
    An Introduction to VBA
    Navigation Pane Protection
    Creating and Using Forms
    Setting Table Relationships
    Working With Records
    Querying Techniques
    Calculations in Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tipton
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Declaring and Creating Object Variables
    Trapping Errors with the On Error Statement
    Using Intrinsic Functions
    Working with the Application Object
    Using the Object Browser
    Understanding Expressions and Statements
    Navigating the Access Object Hierarchy
    Working with Variable Lifetime
    Working with Boolean Expressions
    Working with Events
    Guidelines for use of Branching Structures
    Stepping through Code
    Understanding Errors
    Working with Properties
    Using the For...Next Structure
    Determining the Value of Expressions
    Using Break Mode during Run Mode
    Working with Methods
    Organizing Code and Procedures
    Setting Break Expressions
    Understanding Procedures

  • See Training Course Details...



Email us about this courses



Other Tipton Enable Technology Training Courses

JQuery Mobile Tipton Training Courses
Power Query Tipton Training Courses
SSAS Tabular Tipton Training Courses
SSIS Tipton Training Courses
TSQL Tipton Training Courses
Excel 365 Basic Tipton Training Courses