Introduction to Databases

Introduction

In this tutorial: Introduction > Getting Started > Your skills rating > What is a Database? > Start the Database Application > Creating Field Names > Entering Data > Create the Patient Table > Using Field Properties > Creating Lookup Tables > Relationships Between Tables > Types of Relationships > Create a Relationship > Use Queries to Extract Information > Produce Reports to Display the Data > Importing Data > Skills list > What Next and Summary
All Pages in this tutorial

Course Outline

In this tutorial you will learn how to use Microsoft Access 2010 to create and build a relational database. You will create some tables and enter data and use queries to extract information and create a report.

You should have attended the Introduction to Databases lecture that precedes this practical. If you missed this lecture, or would like to review the lecture notes, please refer to the handout.

Learning Outcomes

By the end of this session you should be able to:

• Design Tables and set Field Properties;
• Build Relationships between Tables;
• Use Queries to extract information;
• Produce Reports to display the data.

Next page.