Access 2016 - Relational Databases & Subforms in pdf

Introduction

Microsoft Access allows people to effectively and efficiently organize data. This document has been developed to show you how to use multiple tables and relational databases in Access 2016. The various sections presented in this document will help you to build a solid knowledge foundation of the software. The Microsoft Access Booklet Series will provide you the necessary knowledge on how to use Microsoft Office Access 2016. Before reading this booklet, it is recommended that you read the following Access 2016 documents at:

• Microsoft Access 2016 – Intro to Access
• Microsoft Access 2016 – Intro to Forms

Learning Objectives

The following objectives are covered in this document:

• Understanding the concept of relationships as they relate to tables.
• Knowing how to define data types for relationships.
• Having the ability to create a relationship.
• Understanding relationships and forms.
• Knowing how to create a form for a two table relationship.
• Knowing how to create a tab form for a multi-table relationship.