Newcastle University

Access 2010 Module 1 - New Users

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.

Workshop Overview

This workshop is suitable for new users to Microsoft Access.

Learning Objectives

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

• Become aware of Relational Database theory
• Build and modify tables
• Define relationships
• Build and modify forms
• Design and run a query
• Produce and modify reports
• Use some features new to Access 2010

Outline Programme

The workshop programme is as follows:

• Introduction to relational databases
• Creating 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 and filter records
• Create select queries
• Create and modify simple reports
• Import data from Excel

Note

In addition to the workshops we offer we also have the on-line courses available through the SDU's Learning Resource Centre.