The complete online training for Microsoft Access.

Overview

Are you looking to improve your knowledge of Access 2013? This course is ideal if you're a beginner or want to increase your knowledge. It will take you through the full range of functionality, from beginner level to using the advanced features and applications. Learn how to perform tasks at your own pace by following easy step-by-step actions and complete your training in bitesize chunks. Bookmarking allows you to dip in and out, so you can learn whenever suits you, plus you can jump directly to specific topics of interest quickly and easily.

Details

Using software similations and interactive excercises, you will quickly become familiar with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity.

During the course you will also familiarise yourself with an easy way of creating simple forms and reports. You will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and subreports.

Modules:

The course contains the following modules:

• Create and manage a database

• Build tables

• Create queries

• Create forms

• Create reports

Certificate

A learndirect certificate will be emailed to you when you have successfully completed the course.