Microsoft Access Training Workshop

Microsoft Access Training Workshop

Microsoft Access Training Workshop

Microsoft Access Training Workshop

The Microsoft Access training courses are available on-site, or at a training room or online through live video conferencing.

Half Day or Full Day Workshop – Foundation / Intermediate / Advanced Level

Just how do you keep an accurate account of your customers’, company or prospects’ details; target the right audience for mail shots; manage your customer relationships? All this and more is achievable through an Access Database. This course will help those new to, or familiar with, MS Access learn essential features and functions to be able to confidently work within the program.  Being confident in Microsoft Access is essential for anyone who either works or aspires to work in an database environment. The course is for anyone wanting to learn how to utilise the current version of this powerful database programme. It will guide you through a wide range of aspects of Microsoft Access. You will gain hands-on, practical experience throughout, meaning you can put the theory into practice. There are three levels: Foundation, Intermediate and Advanced. Book onto the workshop that is right for you, or contact us now to ask for guidance on which is right and to book.

Course Descriptor

The course descriptors below are a summary and indicative of topics that will be covered, however the workshops and training content can be tailored to specific requirements if required.

Microsoft Access Foundation

  • Getting Started
  • Creating Tables
  • Datasheet view
  • Filters
  • Forms
  • Enhancing a Form
  • Queries
  • Understanding Relationships
  • Basic Reports
  • New Office 2016 / 365 features

Microsoft Access Intermediate

  • Advanced Table Design
  • Advanced Queries
  • Develop Relationship concepts
  • Customising Reports
  • Sharing Data Across Applications  
  • Splitting a Database
  • Advanced Form
  • New Office 2016 / 365 features

Microsoft Access Advanced

  • Structuring Existing Data
  • Writing Advanced Queries
  • Simplifying Tasks with Macros
  • Creating Effective Reports
  • Maintaining an Access Database  
  • Splitting a Database
  • Advanced Form
  • New Office 2016 / 365 features

Microsoft Access Expert

  • Integrating Access into Your Business – XML data, Outlook &Email Connection
  • Automating a Business Process with VBA – Modules, Code & Procedures
  • Managing Switchboards  – Create, Modify & Start-up Options
  • Sharing & Distributing Data – Importing, Linking & Exporting
  • New Office 2016 / 365 features

Who Should Attend?

This course will help you learn some of the fundamental actions you can carry out in Access before advancing your knowledge to more in-depth features. Access is widely used in a variety of job roles and it is suitable for a wide audience. This course is ideal for you if you work in, or aspire to work within an office environment and want to brush up on your database skills. Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access. Existing users will learn how to get the most out of Access, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Access trainers. So, new and regular users at all levels of Microsoft Access can participate in all of these workshops and courses.

This course is designed for anyone looking to gain experience and knowledge of this popular Microsoft Office database program. If you are looking to update your skills from an earlier version of Microsoft Access, this course will show you all the new features and help you find your way around the newest version of the software in a business setting..

Why should you attend?

By the end of this workshop, you will:

  • Develop your ability to navigate Microsoft Access – enable you to start, build, update and maintain a database;
  • Learn essential features and functions – You will learn how to use your data to it’s maximum potential by utilising queries, forms and reports in Access;
  • To understand not only database concepts, but also learn how to create your own business database;
  • Be familiar with all the changes and updates to the newest version;
  • To be confident in working  with the program;
  • Learn shortcuts and tips about how to use Access in the most efficient way;
  • Show your commitment to continuing professional development and help towards your career progression opportunities.

Additional Information

Delegates should, if possible, bring their own laptop to the course (though laptops will be available for those without one)