 |
Why you must know your table properties
in detail. |
|
When to use "lookup tables"
and how are they created. |
|
Learn the different types of "Joins"
and when to use each. |
|
Design issues. |
|
How and when to use the "Database
Splitter." |
|
What is a Front end/back end design?
|
|
When do you use it? Where should
your data be stored in a multi-user, networked environment? |
|
How you can make sure
database performance is optimised How to use the "Performance
Wizard? |
|
How to link to external data sources. |
| Queries |
|
When to use Action queries. |
|
When to use Crosstab queries. |
|
When to use and how to create Union
queries. |
|
When to use make table queries. |
|
When to use append queries. |
|
How to create the above
queries. |
| Forms |
|
How to use the "tabbed control"
for clearer form layout. |
|
Why list boxes are essential for
many forms. |
|
Essential advanced combo box knowledge
for reducing data entry and faster searching. |
|
Referring to sub forms using calculated
controls. |
|
Why "domain functions"
(like DSum, DCount, DLookup) are must have functions
and why the pros use them everywhere. |
| Reports |
|
How to create Crosstab reports and
what are their limitations. |
|
Identifying when to create reports
containing sub reports. |
|
Examples of how to
produce those difficult to create reports, where grouping
is making your life difficult. |
|
Expert report techniques for rapid
design and a professional look. |
| Tips
from the Pros |
|
How top get external data into your
database. |
|
Critical factors to consider when
importing/exporting data. |
|
Rules on when to import
and when to link. |
|
Setting startup options for more
database control. |
|
Creating a password protected database. |
| Contact
details 
1. Beginners
2. Intermediate
3. Advanced
4. Introduction
to programming
5. Bespoke
training
|
