Introduction to Advanced Databases

Introduction

In this tutorial: Introduction > Getting started > Your skills rating > Understanding the database > Data relationships > Creating a Relationship > Adding Data > Creating a Lookup table > Forms > Creating a Form > Querying Data > Reporting Data > Skills list > Summary
All pages in this tutorial

Course Outline

In this session, you will be taken through the steps of editing tables in an existing database and querying this data. You will copy an existing database onto your file space so you can refer to it later.

Learning Outcomes

By the end of this session, you will:

• Be introduced to some of the main functions in MS Access.
• Learn how to build a simple relational database.
• Learn how to query a database and store results in Access.
• Be introduced to some of the theory of database design that you will need when designing your own database.
• Be encouraged to utilise and explore the help facilities and menus.
• Have the opportunity to raise questions.

Next page.