Enable Technology



Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Action Queries
    An Introduction to VBA
    Macros on Forms
    DIY Forms
    Designing a Lookup Database
    Creating a Relational Database
    Creating and Using Macros
    Data Validation
    Sorting and Filtering
    Adding Transactional Records
    Creating and Using Forms
    Formatting Tables
    Importing and Exporting Records
    Creating and Using Reports
    Creating a Lookup Database
    Modifying Forms
    Macro Techniques
    Creating Queries
    Using a Navigation Form
    Querying Techniques
    Multi Table Queries

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Stepping through Code
    Using Expressions, Variables, and Intrinsic Functions
    Using Break Mode during Run Mode
    Understanding the Development Environment
    Understanding Modules
    Understanding Expressions and Statements
    Using the If...End If Decision Structures
    Using the CacheSize Property - Optional
    Understanding Errors
    Understanding Error Handling
    Trapping Errors with the On Error Statement
    Creating a Sub Procedure
    Working with Procedures and Functions
    Using Intrinsic Constants
    Understanding Control-of-Flow Structures
    Using Visual Basic Help
    Using the For Each...Next Structure
    Working with Properties
    Introduction to Programming in Access
    Creating a Function Procedure
    Writing an Error-Handling Routine

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Power Graphics Uk Training Courses
Excel Advanced Uk Training Courses
Power BI Uk Training Courses
Oracle SQL Uk Training Courses
SSRS 2008 Uk Training Courses
Crystal 2013 Uk Training Courses