Microsoft Access Training

Microsoft Access Training

MS Access 2013 Level 1Read more...

MS Access 2013 Level 2Read more...

MS Access 2013 Level 3Read more...

MS Access 2016 Level 1Read more...

MS Access 2016 Level 2Read more...

MS Access 2016 Level 3Read more...

AccTech Systems is an accredited testing center which means that when you are ready you can book your international Microsoft Office Specialist exam. With three certification levels Microsoft Office Specialist, Microsoft Office Specialist Expert and Microsoft Office Specialist Master, the MOS credential allows individuals to validate their skills and progress toward their career goals.

Live Instructors

Courses are delivered by experienced trainers, whom you can ask questions to directly. Classes also have a maximum of 10 delegates.

Accredited Training Provider

AccTech Systems is an accredited training provider with MICT Seta and Certiport Microsoft Office Specialist (MOS) certification.

Relevant & Focused

Courses focuses on the skills you need, with relevant exercises and plenty of time to review.

MS Access 2013 Level 1

1 day from 9:00 till 16:00

Description on this course

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2013 relational database application.

Intended Audience

This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and mange files and folders. To ensure your success, we recommend you first take one of our introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
• Windows XP Professional: Level 1
• Windows XP: Introduction

TOPICS COVERED

- Database Concepts

- Working with a Database

- Working with a Database Table

- Database relationships

- Working with Forms

- Working with Queries

- Working with Reports

MS Access 2013 Level 2

1 day from 9:00 till 16:00

Description on this course

You have the basic skills needed to work with Microsoft® Office Access™ 2013 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Intended Audience

Microsoft Office Access 2013 Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2013.

Prerequisites

To ensure the successful completion of Microsoft Office Access 2013 Level 2, the completion of the Microsoft Office Access 2013 Level 1 course, or equivalent knowledge, is recommended.

TOPICS COVERED

- Database Basics

- Relationships

- Customising Tables

- Working with Queries

- Working with Forms

- Working with Reports

- Managing the Database

MS Access 2013 Level 3

1 day from 9:00 till 16:00

Description on this course

The training in and use of Microsoft® Office Access 2013 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2013. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Intended Audience

The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2013, and it is a prerequisite to take more advanced courses in Microsoft® Office Access 2013.

Prerequisites

To ensure the successful completion of Microsoft® Office Access 2013 Level 3, the following courses or equivalent knowledge are recommended: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as Microsoft® Office Access 2013 Level 1, and Microsoft® Office Access 2013 Level 2.
Documentation

TOPICS COVERED

- Database Design

- Expert Form Design

- Expert Queries

- Expert Reports

- Working with Macros

- Expert Database Tools

MS Access 2016 Level 1

1 day from 9:00 till 16:00

Description on this course

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2016 relational database application.

Intended Audience

This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and mange files and folders. To ensure your success, we recommend you first take one of our introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
• Windows XP Professional: Level 1
• Windows XP: Introduction

TOPICS COVERED

- Database Concepts

- Starting with Databases

- Working in a database table

- Creating & designing tables

- Database Relationships

- Working with Forms

- Working with Queries

- Working with Reports

MS Access 2016 Level 2

1 day from 9:00 till 16:00

Description on this course

You have the basic skills needed to work with Microsoft® Office Access™ 2016 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Intended Audience

Microsoft Office Access 2016 Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2016.

Prerequisites

To ensure the successful completion of Microsoft Office Access 2016 Level 2, the completion of the Microsoft Office Access 2016 Level 1 course, or equivalent knowledge, is recommended.

TOPICS COVERED

- Database Basics

- Relationships

- Customising Tables

- Working with Queries

- Working with Forms

- Working with Reports

- Managing the Database

MS Access 2016 Level 3

1 day from 9:00 till 16:00

Description on this course

The training in and use of Microsoft® Office Access 2016 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2016. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Intended Audience

The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2016, and it is a prerequisite to take more advanced courses in Microsoft® Office Access 2016.

Prerequisites

To ensure the successful completion of Microsoft® Office Access 2016 Level 3, the following courses or equivalent knowledge are recommended: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as Microsoft® Office Access 2016 Level 1, and Microsoft® Office Access 2016 Level 2.

TOPICS COVERED

- Database Design

- Expert Form Design

- Expert Queries

- Expert Reports

- Working with Macros

- Expert Database Tools