Introduction

In the course MS Access 2013: Introduction, you will familiarise yourself 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. You will also familiarise yourself with an easy way of creating simple forms and reports.

Lessons

• Introduction to databases
• Program interface and the database objects
• Creating a table in the Datasheet view
• Creating a table in the Design view
• Special field types and working with fields
• Designing databases
• Analysis of the relations between tables
• Relations and referential integrity
• Working with tables
• Searching and editing records
• Filtering and sorting records
• Select queries
• Sorting records in select queries
• Working with criteria in select queries
• Calculated fields
• Joining tables in queries
• Creating a lookup column
• Editing the query of a lookup column
• Creating forms
• Creating reports