Microsoft Access Developer
n 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 ObjectivesBy 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
ContentDatabase 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
