Enable Technology



Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Macros on Forms
    Database Wellness
    Multi Table Queries
    Creating a Lookup Database
    Adding Transactional Records
    Database Security
    Creating Queries
    Formatting Tables
    Creating a Relational Database
    Creating and Using Macros
    Adding Records to a Table
    DIY Forms
    Using a Navigation Form
    Data Validation
    Macro Techniques
    Action Queries
    Parameter Queries
    Getting to Know Access 
    Importing and Exporting Records
    Designing a Lookup Database
    Modifying Table Structures

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • 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 ...
  • Working with the Application Object
    Using the Immediate Window to Call Procedures
    Using Intrinsic Functions
    Understanding the Err Object
    Working with Events
    Understanding Data Types
    Understanding Expressions and Statements
    Understanding Procedures
    Using the For...Next Structure
    Working with the Code Editor
    Setting Break Expressions
    Working with Boolean Expressions
    Understanding the Form Object
    Using Message Boxes
    Determining the Value of Expressions
    Specifying a Recordset Cursor Location - Optional
    Handling Errors
    Understanding Modules

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Power Graphics Uk Training Courses
Project 2016 Uk Training Courses
PHP - Uk PHP Training Courses
PowerPoint Advanced - Uk Office Training Courses
TSQL - Uk SQL Training Courses
SSRS 2008 - Uk SQL Server Reporting Services Training Courses