Access Training Courses

  • Access 2013 Part 1 - 1 day

    In this one day course you will: Identify the components of Access 2013 and the parts of a database, Organize data in tables, View data in tables, Create queries, Design forms and Generate reports.

  • Access 2013 Part 2 - 1 day

    In this 1 day intermediate course you will learn to: Streamline data entry, Maintain data integrity, Join tables togther, Create flexible queries to display specific records, allow for user criteria in queries and modify data using queries, Enhance form appearance and ease of use, Customise reports without specific print layouts, Share data across applications.

  • Access 2013 Part 3 - 1 day

    In this 1 day advanced course you will learn to: Restructure existing data into appropriate tables, Write advanced queries, Create and revise macros, Make effective use of forms and reports, Maintain an Access database using tools.

  • Access 2010 Level 1 Introduction - 1 day

    In this one day course you will: Identify the components of Access 2010 and the parts of a database, Organize data in tables, View data in tables, Create queries, Design forms and Generate reports.

  • Access 2010 Level 2 Intermediate - 1 day

    In this 1 day intermediate course you will learn to: Streamline data entry, Maintain data integrity, Join tables togther, Create flexible queries to display specific records, allow for user criteria in queries and modify data using queries, Enhance form appearance and ease of use, Customise reports without specific print layouts, Share data across applications.

  • Access 2010 Level 3 Advanced - 1 day

    In this 1 day advanced course you will learn to: Restructure existing data into appropriate tables, Write advanced queries, Create and revise macros, Make effective use of forms and reports, Maintain an Access database using tools.

  • Access 2010 Level 4 VBA and Administration - 1 day

    In this 1 day advanced course you will learn to: Integrate Access using XML, Automate business processes using VBA, Create and modify a switchboard, Distribute and secure databases and Share databases with SharePoint.

  • Access 2010 Transition from Access 2003 - 1 day

    In this one day course you will: Identify the components of the Microsoft Office Access 2010 interface, Build tables and forms and also work with macros, Create queries and reports, Work with external data, Build a database for the web.

  • Access 2007 Level 1 Introduction - 1 day

    Understand the concepts and features of Access 2007. Learn to create, use and edit tables, queries, forms and reports. Work with fields and records. Enter data in a form, query data and create reports.

  • Access 2007 Level 2 Intermediate - 1 day

    In this 1 day intermediate course you'll learn to: Control data entry, Join tables and create flexible queries. Enhance form appearance and ease of use, Customise reports and Share data across applications.

  • Access 2007 Level 3 Advanced - 1 day

    In this 1 day advanced course you'll learn to: Structure existing data, Write advanced queries, Harness macros, Make effective use of forms and reports, Maintain an Access Database.

  • Access 2007 Level 4 VBA and Administration - 1 day

    In this 1 day advanced course you'll learn to: Integrate Access using XML, Automate business processes using VBA, Create and modify a switchboard, Distribute and secure databases and Share databases with SharePoint.

  • Access 2007 New Features - 1 day

    Learn the essential new features of Access 2007. Improve your database design, presentation and distibution prowess by updating your Access skills to Access 2007.

  • Access 2003 Level 1 Introduction - 1 day

    Learn the concepts and features of Access 2003. Learn to create, use and edit tables, queries, forms and reports. Work with fields and records. Enter data in a form, query data and create reports.

  • Access 2003 Level 2 Intermediate - 1 day

    In this 1 day intermediate Access 2003 course you'll learn to: Design a database, Control data entry, Join tables and create flexible queries. Enhance form appearance and ease of use, Customise reports and Share data across applications.

  • Access 2003 Level 3 Advanced - 1 day

    In this 1 day advanced Access 2003 course you'll learn to: Structure existing data, Write advanced queries, Harness macros, Make effective use of forms and reports, Maintain an Access 2003 database.

  • Access 2003 Level 4 VBA and Administration - 1 day

    In this 1 day advanced Access 2003 course you'll learn to: Create data access pages and web pages, Integrate Access using XML, Automate business processes using VBA, Create and modify a switchboard, and Distribute and secure databases.

Microsoft Access

About Access

Microsoft Access is a database management system which allows users to gather and work with large sets of data. Access is employed professional for many reasons such as; keeping track of guest lists, storing phone numbers, inventories etc. It is a vital piece of software for somebody who wants to analyse a large amount of data in a productive and time-saving way. Access is highly efficient for tracking, reporting and sharing data with others.

Access offers a professional-looking application which is an industry-standard for database management. The user interface is fairly easy to navigate and provides many familiarities for those who are common users of other Microsoft Office applications. Advanced users of Access can use VBA to write intensive solutions with data manipulation and user control. Access has the ability to import and export data in many different formats, including; Excel, Outlook, SQL Server and Oracle. The compatibility with SQL is particularly beneficial to programmers.

A few features from Access 2013

  • Drill-through links which let you quickly view details about a related item.
  • Callouts for setting properties, a time saving tool for finding a particular setting faster.
  • Quickly open in a browser via Launch App button.
  • Table templates - a great time-saving feature.