Enable Technology

ACCESS NEWTOWN TRAINING COURSES 

ACCESS TRAINING COURSES NEWTOWN




About Enable Technology Newtown Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver Access courses at your site. We are also more than happy to organise a local course at a socially distanced training location in Newtown. We are happy to discuss customising the course content should you have particular Access training 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Birmingham City University, South Staffordshire Water PLC, Homeserve PLC, Canadian High Commission, Countrywide Homes Limited, West Bromwich Building Society, Royal Air Force and Queen's Medical Centre Nottingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newtown
  • 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 ...
  • Using the With Statement
    Creating a Standard Module
    Declaring Variables
    Understanding the Err Object
    Working with Methods
    Using Debugging Tools
    Understanding Procedures
    Naming Procedures
    Understanding Objects
    Using Break Mode during Run Mode
    Navigating the Access Object Hierarchy
    Using Visual Basic Help
    Using the If...End If Decision Structures
    Understanding Error Handling
    Understanding the Development Environment
    Understanding Modules
    Using the Do...Loop Structure
    Working with the ADODB Recordset Object
    Why Program in Access?

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Newtown
  • 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 ...
  • Calculations in Queries
    Creating a Lookup Database
    Creating and Using Macros
    DIY Forms
    Data Validation
    Navigation Pane Protection
    Adding Records to a Table
    Modifying Table Structures
    Macro Techniques
    Macros on Forms
    Creating and Using Reports
    Working With Records
    Adding Transactional Records
    Database Security
    Creating and Using Forms
    Aggregation Queries
    Creating Queries
    Action Queries
    Understanding VBA
    Setting Table Relationships
    Getting to Know Access 

  • See Training Course Details...



Email us about this courses



Other Newtown Enable Technology Training Courses

Oracle SQL Newtown Training Courses
Excel 365 Intermediate - Newtown Excel Training Courses
Report Builder - Newtown SQL Server Reporting Services Training Courses
SSRS Newtown Training Courses
Power BI Newtown Training Courses
Excel 365 Advanced - Newtown Excel Training Courses