Microsoft Access: Database Design

Course Overview

This practical two day course is designed for those who need to create relational databases using Microsoft Access.

The course covers how to plan, design and create a database to a detailed brief. You will learn to create different layouts, summarise information and produce reports. This course is run as a private course in order to tailor the content to your exact requirements.

Feel free to build a new database during the course or work on an existing database if you wish.

Course content

Database design concepts
· Planning a database
· Drawing up a database design
· Checking function meets need

Building components
· Using tables
· Relationships
· Meeting normal forms' rules
· Using forms

Designing Queries
· Parameter queries
· Action queries
· Query joins
· Crosstab queries

Advanced form techniques
· Organising field placement
· Using functions to control data entry
· Adding an option group
· Using a form as a user interface
· Creating a sub-form

Creating macros to use with forms
· Macro introduction
· Attaching a macro to a command button
· Editing a macro
Macros that add user interaction and automation
· Macros to automatically enter data
· AutoKeys and AutoExec macros

Reporting
· Designing reports
· Editing reports
· Adding functionality to reports

Switchboards
· Creating a switchboard
· Controlling database startup properties

Creating a splash screen
· Using a form as a splash screen
· Automating the splash screen

Database security
· End-user level security
· Password security

Questions and answers