Creating Simple Databases - DB04

General Description

Collecting and manipulating information can be a labour intensive manual process in many organisations. Streamline your data collection process by using Access to develop your own database.

Target Audience

This session is intended for participants with a thorough knowledge of using Microsoft Access databases.

Pre-requisites

Participants should be competent in the learning outcomes of sessions DB01, DB02 and DB03.

Duration

3 hours

Learning Outcomes

• Identify components of effective databases
• Describe purpose of database relationships
• Design a single table database
• Create database tables
• Assign a primary key
• Determine and set field properties
• Enter sample data and test validity
• Create forms for data entry
• Format controls (Font, colour, size) on a form
• Move, resize and align controls on a form