Microsoft Access Training in Northern Ireland with Mullan Training

Microsoft Access Training

in Belfast City Centre
(Opposite Europa Hotel)

from £185 per day

        

Courses are delivered in our training suites
opposite Europa Hotel
(at  Mullan Training -
max 12 delegates)

Click to view the Mullan Training website


Access Intro Course

At the end of this course:

  • You will have a good working knowledge of MS Access
  • You will feel more confident using Access, and be able to create a database from scratch
  • You will understand using tables, fields and records and the rules for entering your data
  • You will have the foundation from which you can create simple queries, use forms and, ultimately create reports

    Click here for details

Access Advanced Course

At the end of this course:

  • You will have a complete understanding of the higher functions of Access
  • You will learn to automate functions by creating simple and then very advanced macros
  • You will advance your querying ability and then to use SQL statements in your queries
  • You will discover how to work with objects, and the fundamentals of database management
  • Finally you will be taught how to protect your valuable data sources

    Click here for details

Access VBA Course

At the end of the course the delegate will have covered the fundamentals of VBA, including:

  • working with procedures and functions
    understanding objects
  • using expressions, variables and intrinsic functions
  • They will have mastered how to:
    control program execution
  • Work with forms and controls
  • Work with the PivotTable object

    Finally the course also includes modules on:
  • debugging code
  • handling errors to ensure minimal downtime
  • while building and effecting the program

    Click here for details

from £185 per delegate
Public Schedule training course in Belfast

in Microsoft Access

 


Interested??
For more details:

 

We are a Microsoft Certified Application specialist

 CITB Accredited

CITB Approved - Our courses are registered
& approved with CITB so you will
be eligible for funding

 



 

   

 

Application Specialist

 

Click to view details of the MOS and MCAS Exams availabile in our Testing Centre

 

Mullan Training have been providing comprehensive training in Microsoft Access - Intro, Advanced and VBA Levels - for more than 15 years, and can help you get to know the product and utilize the many tools and techniques available within this vast application.

Our training suites are in Belfast City Centre, opposite Europa Hotel - easy to find with public transport just opposite!!!

Click to view our belfast city centre training suites

We can provide training in:


Click here to view our Public Course Schedule and see the dates we are running our courses on...
View our Public Course Schedule
 

Microsoft Access
Course Description
Introduction
Visit the Mullan Training Website
Course Outline

Our Introduction to MS Access course is suitable for complete beginners to Microsoft Access.

Prerequisites

A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Access is required.

Benefits

At the end of this course you will have a good working knowledge of MS Access. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

After completing this course you will be prepared to attend the Advanced MS Access training course.

 

Course Outline - click here to view online or download as a Word document from our website

Views Available Within Access

  • Table
  • Query
  • Report
  • Form
  • Switch Between Design View and Datasheet View/ Form View/ Preview/ Run

Create New Database File

  • Why Create a File First
  • Object Naming Rules

Database Tables – Create

  • Field Names
  • Data Types - corresponding field properties and how they differ according to the data type selected
  • Primary Key Fields
  • Format
  • Caption
  • Required
  • Input Mask
  • Validation rule
  • Indexing
  • Create lookups to standardise data entry

Database Tables – Manipulate Records

  • Sort Records
  • Delete Records & Fields
  • Use Find & Find And Replace
  • Rename Fields
  • Use The Filter/ Sort Facility (By Selection, By Form, Advanced Filter/ Sort)

Define Relationships

  • Establish Relationships (One-Many, One-One)
  • Enforce Referential Integrity
  • Cascade Update/ Delete Related Fields

Forms

  • Why To Use The Form To Input Data
  • Create With And Without The Wizard
  • Form Types - MultiTable, Columnar, Justified, SubForms
  • Move Labels And Fields Around The Form (Together And As Individual Items)
  • Align Objects, Snap To Grid
  • Adjust “Fineness” Of Grid
  • Adjust The Form Size
  • Select And Move/ Resize Multiple Objects
  • Set Background Fill, Text Colour
  • Sections Of A Form
  • Toolbox (Combo Box, Command Buttons, Drawing Tools, Pointer)
  • Introduce Command Buttons

Queries

  • Select
  • Parameter
  • CrossTab
  • Summary
  • Incorporate Calculated Fields

Reports

  • Create Reports Using The Wizard
  • Display Specific Records
  • Sort Records By Specified Fields
  • Apply Page Header/Footer
  • Specify Layout Of The Report
  • Specify Grouping Levels
  • Calculated Fields
  • Create Parameter Report

Create User Interface

  • How To Create A Database That Will Allow Non-Access Users To Enter/ View Data & Run Reports
  • Create Splash Screen
    Use Of The Autoexec Macro & StartUp Command

Get accustomed to Microsoft Excel with Mullan Training

 

Microsoft Access
Course Description
Advanced
Visit the Mullan Training website
Click here to view our course Outline

Our 1 day A dvanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access c ourse.

Benefits

At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.

You will then be qualified to progress to our VBA Access course.


Course Outline - click here to view online or download as a Word document from our website

Create Expressions

  • For Use Within Reports, Queries, Forms, Macros
  • Definition Of (Symbols, Fields, Identifiers, Operators, Functions)
  • Use To Define Calculated Control, Establish Validation Rule, Create Calculated Field
  • Create Using The Expression Builder

 

Forms

  • Create Forms With Macros To Create A User Interface
  • Calculated Fields
  • Use Expression Builder To Limit To Displayed Records
  • Insert Picture (Picture Properties, As Background, Etc – Also For Report)

 

Reports

  • Specify Grouping Levels (Grouping Header/ Footer, Group On, Group Interval, Keep Together)
  • Calculated Fields
  • Report Properties (Force New Page, Keep Together, Events, Etc)
  • Create Mailing Labels And Charts From Table/ Query Data

Macros

  • Create A Macro (Actions, Arguments)
  • Autoexec Macro
  • Macro Functions (Setvalue, Setmenu Item, Msgbox, Run, Etc)
  • Create A Macro Group
  • Add An Action To A Macro
  • Move An Action In A Macro
  • Enter An Expression In A Macro Action Argument
  • Use Conditions To:
  • Carry Out Actions Depending On Criteria
  • Validate Data
  • Show And Hide Macro Names And Conditions In The Macro Window

Queries

  • Use The ! And . (Dot)Operators
  • Expressions
  • Parameter Queries – With The Criteria Provided From A Form (Standard Or Custom Dialogue)
  • Action Queries (Update, Delete, Append)
  • Crosstab Queries
  • Calculated Fields

Course Outline

Microsoft Access
Course Description
VBA
Visit the Mullan Training website
Click to visit the NIExcelTraining website

This 2 day course is suitable for Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

Prerequisites

A high proficiency of Microsoft Access is essential, or completion of our Advanced MS Access course .

Benefits

At the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.


Course Outline - click here to view online or download as a Word document from our website

The VBA Programming Environment

  • When to use Visual Basic for Applications instead of Macros
  • Visual Basic for Applications Development Environment

Programming in the VBA Language Code Compilation

  • Finding Bugs

 

Error Handling in VBA

  • Ignoring Errors
  • Trapping Errors
  • Writing Useful Error Handlers

Class Modules and Form-Event Procedures

  • Using Form Events
  • Code Behind Forms
  • Changing Form Properties
  • Creating New Form Instances

Manipulating Data through Data Access Objects and SQL

  • Data Access Objects (DAO)
  • Opening Databases Programmatically
  • Database and Recordset Objects
  • Manipulating Data with VBA Methods
  • Finding Records in a Recordset
  • Editing Data in a Recordset
  • Using Recordsets to Manipulate Imported Data
  • Creating, Using and Deleting Queries from VBA

Changing Database Definitions through VBA

  • Using SQL to Manipulate Databases

 

 


 

  • Discount available for multiple delegates
  • Courses delivered on your own premises - up to 6 laptops, LCD projector and screen provided at no extra charge

Click to view the mullan Training website

Microsoft Access training in Belfast and
throughout
N Ireland

from

www.mullantraining.com