All our Courses and Diplomas at Pitman Training have been developed to give you practical hands-on experience, so that you can put your skills in to practice, as soon as you've completed the course. With courses, seminars and diplomas designed for specific careers, and workplace requirements, we're sure there's an option to suit you.

Types of Training

Personal development allows you to develop your skills and qualities to reach your career goals and aspirations. Maximise your potential by ensuring you maintain a clear development path.

If you're looking to progress your career, refresh your skills or simply want to learn something new, our courses, diplomas and seminars will help you gain valuable practical experience that is instantly transferable to the workplace.

Our Centres

Are you looking for your closest Pitman Training Centre? With 14 training locations available across Ireland, you'll be able to find us in a town or city near you.

We're not only in Ireland! We also have training centres in the UK and internationally as well.

If we don't have a training centre in your town or city, then just give us a call on 1800 532632 and ask to be put through to your nearest centre. We'll discuss your situation and see which of our training courses, including distance learning, will fit with your circumstances. With hundreds of flexible courses on offer, we're sure to have a tailored programme that's just right for you.

Access

An understanding of how to utilise Microsoft Access to its best is a highly worthwhile skill to have at your command. This is a popular database application is widely used across many employment sectors.

Is this for you?

This popular database programme is used in many industries by those wishing to keep accurate, up to date records of customers, projects, products etc. So, for example, if you're working as a PA, EA, VA, Secretary, Administrator or Customer Services Executive, learning how to use this software properly will help you and your skill stand out from the crowd.

Award and Associated Qualifications

Awarded 22 CPD points upon successful completion

Start Date

Flexible

Study Type

In centre, online, or a combination

Training Type

course

Duration

Around 20 to 22 hours

About this course

Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application that is widely used across many employment sectors.

Offering training in either 2010 or 2013, in this detailed and varied training programme you'll be guided through many aspects of Access including; database terminology; planning and design; defining relationships and creating a table; editing data; using advanced tools; using the query wizard; adding a field; exporting an html document; adding charts to forms; and creating macros.

Benefits:

• Learn how to use this popular database program

• The flexibility and value of a self-study course designed to enable you to work at your own pace

Lesson Four – Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design, using AutoFormat, modifying properties in a form

Lesson Five – Including: Using advanced sort, using filters, importing a table from an external database using a junction table to resolve a many to many relationship, defining a composite (primary) key, using a calculated control on a form, creating a multi-value field, creating an attachment field.

Lesson Six – Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries, creating and naming a calculated field in a query using aggregate functions

Lesson Seven – Including: adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating a split form, creating and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report

Lesson Nine – Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form, applying conditional formatting to a field

Lesson Ten – Including: creating a macro, adding a control button to a form, backing up a database, viewing database properties, compacting and repairing a database, encrypting a database using a password, saving the database as a previous version, splitting a database.

Aims and Objectives

To teach the Microsoft Access program to an employable level and to cover the Microsoft Certified Application Specialist test (MCAS) and ECDL Advanced (Database) exam.

Pre-Requisites

You don't need to have any specific previous experience or knowledge before starting this course.

Finance Options

Wherever possible our training is tailored to your needs. The cost of our training programmes depend on the course(s) you choose and varies according to duration and breadth. Rest assured we have a number of payment options available to ensure the cost of training is affordable and can be worked alongside your other financial commitments. Common ways people fund their training include: -

Self-Funded:

Flexible payment plans to help you spread the cost* available at many of our centres;

You could opt to pay upfront.

Company Funded:

Requesting funding from your employers needn’t be a daunting task. Many employers support and encourage their employees with their professional development and consider it a worthwhile investment to fund any training required.

* Terms and Conditions apply. Speak to a Course Advisor for full information on the options available to you.

Career Path

Gaining knowledge on how to effectively set up and manage databases within the Microsoft Access programme can be useful in many work environments.

Those working in Data Entry for example would need a good working knowledge of this system. If you work as a PA it's a good tool to help manage large amounts of data or utilise as a way to extract information from a large data set. Similarly Project Managers might find this a good tool to keep track of client contact information or essential project information and again, be able to extract information to assess.

It's uses are very adaptable and can be applied in most office-based jobs.

After your Access training, progression through other Microsoft Office training courses could lead to a full Microsoft Office Specialist (MOS) qualification a leading IT certification known globally. Holding this certification can be handy if you want to gain a role as a PA, EA, Office Manager or Operations Manager for example.