Access 2013 Module 1 - Overview of Access 2013 and Database Design Theory

Aimed At: Staff who would benefit from an overview of relational databases and especially for staff who use Access to build or maintain simple databases. All staff are strongly advised to attend this module before any of the succeeding modules to gain an understanding of the essential database theories that underpin all Access work.

Workshop Overview

This workshop is suitable for new users to Microsoft Access but staff should be aware that this application requires users to gain a basic understanding of database theory.

Learning Objectives

At the end of the workshop participants will be able to:

  • Aware of Relational Database theory
  • Build & modify tables
  • Define relationships
  • Build & modify forms
  • Design & run a query
  • Produce & modify reports
  • Use some features new to Access 2013
Outline Programme

The workshop programme is as follows:

  • Introduction relational database theory
  • Create database tables
  • Set primary keys and field properties
  • Establish relationships between tables
  • Create simple forms
  • Modify form design
  • Enter records using a form
  • Enter records using a datasheet
  • Delete, find, sort & filter records
  • Create select queries
  • Create & modify simple reports
  • Import data from Excel

To further enhance your understanding of Access, you can access our online Access courses available through SDU's Learning Resource Centre.

Booking Details

Valerie Stuart

09:15 - 16:30


1 Day


Vicky Beesley Ext. 83424

Related Information

Books and Videos
Online IT Courses