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 that is widely used across many employment sectors.

Quick Enquiry

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 is widely used across many employment sectors.

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 of learning Microsoft Access

•  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

•  A reference guide to use and refer to on completion of the course.

•  The opportunity to gain the widely recognised Pitman Training Certificate

The lesson plan content for this Access course is detailed below:

Lesson One – Including: terminology, working with existing databases, opening a table, query, form and report, entering new records, searching and sorting

Lesson Two – Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, re-sizing columns, using the lookup wizard

Lesson Three – Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates, renaming an object

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 Eight – Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function, using the database documenter

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.

What we can help with:

  • Providing a comprehensive training programme outlining learning outcomes
  • Tailored personnel letters
  • Communication with finance departments to arrange payment options (upfront or payment plan*).

* 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 Personal Assistant (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 Personal Assistant, Executive Assistant (EA), Office Manager or Operations Manager for example. 

Access Course Training Centres

Location Address Region
Carlow Pitman Training Carlow, Unit 1A, Southcourt, Wexford Road Business Park, Carlow Enquire &
Book Now
Cork Pitman Training Cork, Unit 4, Airport East Business & Technology Park, Cork Enquire &
Book Now
Dublin Pitman Training Dublin, 3 Westland Square, Pearse Street, Dublin Enquire &
Book Now
Dundalk Pitman Training Dundalk, First Floor, Ramparts Shopping Centre, The Ramparts, Dundalk, Co Louth Enquire &
Book Now
Galway Pitman Training Galway, Centrepoint, Liosban Business Park, Tuam Road, Galway Enquire &
Book Now
Kerry Pitman Training Kerry, 2nd Floor Davcon Building, Monavalley Business Park, Tralee, Co. Kerry Enquire &
Book Now
Limerick Pitman Training Limerick, Unit 8 Chapel Court, Cathedral Place, Limerick Enquire &
Book Now
Maynooth Pitman Training Maynooth, Unit H 11 - First Floor, Maynooth Business Campus, Straffan Road, Maynooth Enquire &
Book Now
Mullingar Pitman Training Mullingar, Castle House, Castle Street, Mullingar, Co. Westmeath, Enquire &
Book Now
Naas Pitman Training Naas, Monread Shopping Centre, Monread Road, Naas Enquire &
Book Now
Sligo Pitman Training Sligo, Abbey House, JFK Parade, Sligo Enquire &
Book Now
Swords Pitman Training Swords, Chamber Buildings, North Street, Swords, Co.Dublin Enquire &
Book Now
Wexford Pitman Training Wexford, Unit 10, Westpoint Business Park, Clonard, Wexford Town Enquire &
Book Now
Waterford Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford Enquire &
Book Now
Laois Pitman Training Laois, Kea-Lew Business Park, Mountrath Road, Portlaoise, Co Laois, Enquire &
Book Now
Athlone Pitman Training Athlone, C/O Athlone Chamber, Unit 12, Inis Oir, Golden Island, Athlone Enquire &
Book Now
Carlow
Pitman Training Carlow, Unit 1A, Southcourt, Wexford Road Business Park, Carlow R93 VP94
Cork
Pitman Training Cork, Unit 4, Airport East Business & Technology Park, Cork T12 KW88
Dublin
Pitman Training Dublin, 3 Westland Square, Pearse Street, Dublin D02 N567
Dundalk
Pitman Training Dundalk, First Floor, Ramparts Shopping Centre, The Ramparts, Dundalk, Co Louth A91 R820
Galway
Pitman Training Galway, Centrepoint, Liosban Business Park, Tuam Road, Galway H91 RYD2
Kerry
Pitman Training Kerry, 2nd Floor Davcon Building, Monavalley Business Park, Tralee, Co. Kerry V92 XY58
Limerick
Pitman Training Limerick, Unit 8 Chapel Court, Cathedral Place, Limerick V94 F6K2
Maynooth
Pitman Training Maynooth, Unit H 11 - First Floor, Maynooth Business Campus, Straffan Road, Maynooth W23 R9V4
Mullingar
Pitman Training Mullingar, Castle House, Castle Street, Mullingar, Co. Westmeath, N91 Y896
Naas
Pitman Training Naas, Monread Shopping Centre, Monread Road, Naas W91 YR12
Sligo
Pitman Training Sligo, Abbey House, JFK Parade, Sligo V94 YH6Y
Swords
Pitman Training Swords, Chamber Buildings, North Street, Swords, Co.Dublin K67 A347
Wexford
Pitman Training Wexford, Unit 10, Westpoint Business Park, Clonard, Wexford Town Y35 YX60
Waterford
Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford X91 HY58
Laois
Pitman Training Laois, Kea-Lew Business Park, Mountrath Road, Portlaoise, Co Laois, R32 W0DT
Athlone
Pitman Training Athlone, C/O Athlone Chamber, Unit 12, Inis Oir, Golden Island, Athlone H91 RYD2

Looking for prices?

Request more details or call the team on 1800 532632

Download a Course Factsheet Now!

Simply enter your details below and we'll email you a copy of all the course details straightaway. 

Whats the difference?

We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs.

Course

Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.

Diploma

Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.

Course Fees?

Click below for more details or call us on 1800 532632.

Ready to improve your career?

Personal Training?

Quick Enquiry

Group or Corporate?

Quick Enquiry

Call us now and transform your career today

1800 532632

Connect with us on