Free Online Microsoft Access for Beginners Training Course

This free online Microsoft Access 2013 beginners training course teach you about creating, accessing, and manipulating databases with Microsoft Access. You will learn how to acquire a copy of MS Access 2013, study its new features, and learn how to use its touch screen interface. You will also study how to navigate and customize the Ribbon, navigate and customize the quick access toolbar, how to navigate and customize the status bar, and more!

What You Will Learn In This Free Course

Introduction to MS Access 2013

In this module you will learn about how you can purchase and acquire a copy of Microsoft Access 2013. Topics also cover what features are new in Access 2013, and how to use the touch screen interface in Access 2013.

Getting Started with MS Access 2013

In this module you’ll cover the basics of creating, opening, saving and using templates of database in Access 2013. Other topics cover how to access and use the Backstage View in Access 2103, how to access the online, offline and contextual help. You’ll learn how to recognise some of the most commonly used keyboard shortcuts, and how to activate and use key tips.

Access Options, The Ribbon and Toolbars

In this module you’ll learn about customizing the settings in Access 2013. Topics also cover how to navigate and customize the Ribbon, navigate and customize the quick access toolbar, and identify how to navigate and customize the status bar.

Database Basics

In this module you’ll learn about the principals of entering data into a table in your database. Topics show you how to specify and change the type and design of your tables data fields, and create an Access Web App.

Tables in Access 2013

In this module you’ll learn about the process of entering data and setting the restraints and conditions of the data?s type. Other topics show the purpose of a primary key and how to set one. You’ll learn how to create relationships between the tables in your Access database. You’ll be introduced to the principles of having a relationship between tables in your database, and learn about referential integrity and what it does in databases.

Datasheet View

In this module you’ll learn how to use the Table tools tab for formatting, inserting and deleting fields in Datasheet view. Other topics show you how to use Datasheet view when accessing, viewing or changing your database. Recognize how to set your field validation rules for data fields in your database, and how to set filters based on textual conditions and how to set filters based on Numeric conditions. You’ll also learn ways in which you can sort the records in a table.

Table Design

In this module you’ll learn how to index a record in a table, and why you would index a record. Other topics discuss the various different properties you can set for your table fields, and some of the data types available in a Access database. You’ll learn how to identify what an Input Mask property is, why to use it, and how, and distinguish how field properties are different and the same for the various data types available.

Forms

In this module you’ll learn about the process of creating a form using the Form Wizard in Access. Other topics show you how to change the layout of your form using design view, and review the advantages and disadvantages of the different form layouts. You’ll learn about many of the things you can do with the design of a form such as how to open and use the form Property Sheet, for each field in the form, and how table records can be changed and or added using a form.

Course assessment