The aim of this two day course is to provide students with relevant skills to design database Tables, create Forms for data entry, create Queries to analyse their data and generate Reports. During the course students will create a database, user navigation, help, simplified input techniques and much more. The course is designed for delegates wishing to create a working database using all the features listed below. Delegates must have attended the Access for beginners or have a sound working knowledge of the database application.

To create and edit a more complex Microsoft® Access database.

• Create and plan a database

• Create effective data input techniques

• Set up effective navigation using buttons and hyperlinks

• Import and export data

• Test database accuracy

Database terms and concepts - Relationships - Tables - Queries - Forms - Reports

Plan a database - Planning techniques - The importance of planning

Create tables and enter test data - Related tables - Lookup Tables - Import data

Link tables to create relationships - 1:1 - 1:Many - Many:Many - Many:1

Create input Forms - Main Data Entry Forms - Subforms - Popup Forms

Create input Forms and Sub-Forms and enter data - Control Techniques

Edit Form design - Editing Techniques - Images - Tools

Add command buttons to Forms for Navigation - Open/Close Forms and Reports

Add combo boxes and list boxes to Forms - Employ good data entry techniques

Create Queries to manage data - Data for Reports - Output - Action Queries

Create parameter Queries, adding calculations to Queries - Techniques

Create and edit Reports - Automatic Reports - Controlled Reports

Create a Navigation structure linking Forms, Reports and Queries - Plan Navigation