Developing Relational Databases using Access - DB05

General Description

Build relational databases that take advantage of the functionality of Access. Utilise macros and form techniques to make your database efficient and user friendly.

Target Audience

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

Pre-requisites

Participants should be able to add data to a database, create and use queries and reports. Experience working with table and form design is an advantage.

Duration

2 days

Learning Outcomes

• Review relational database theory
• Analyse good design of relational databases
• Implement relational constraints and rules at the table level
• Use design strategies to attain optimal normal form in designing a database
• Write action queries to carry out administrative tasks on table data
• Write macros to check and automate database operations and form functionality
• Integrate design methods to produce professional, user-friendly forms
• Quickly develop a user interface and menu system using Switchboards
• Compact a database to improve speed and efficiency
• Split databases into front and back-end databases
• Secure a database and prepare it for general use