Description

A database is defined as "a collection of data arranged for ease and speed of search and retrieval." Microsoft Access 2003 is a database management system which allows you to create simple or complex databases for use in the classroom. You may want to create a simple register store information on pupil performance or even analyse your SQA results. This absolute beginners' opportunity will introduce the Access environment and take you step-by-step through the process of creating a simple database to store information for a school trip. You will learn to design the database create the structure and define the fields to store the information.

Content:

1. Be able to create and name a database file
2. Be able to create a table
3. Be able to create fields and specify data types
4. Be able to define the primary key
5. Be able to add/edit or delete information in a table
6. Be able to retrieve information using find and sort
7. Be able to print from a table in a database

Level: Beginner

Audience: All education staff

Pre Skills: Competence with a recent version of Windows

Hardware: Personal computer (PC)

Software: Microsoft Access 2003