Microsoft Access Developer

Microsoft Access Developer An overall very useful course with impressive facilities. Would definitely recommend this course. I'm looking forward to creating my own database now. [SA HPA]

Introduction The aim of this three 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.

Course Objectives

By the end of this level you will be able to:

• 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

Content

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