| More
about Tables |
 |
What are the types of relationships? |
|
What are Parent/child tables? |
|
Why "One to many" relationships
are the key to a relational database. |
|
What does "referential integrity"
mean and what are its implications? |
| Complex
Queries |
|
How to create multiple table queries. |
|
Why adjusting the queries properties
can eliminate duplicate results. |
|
How to calculate totals
with queries. |
|
How to use complex criteria for more
advanced searches. |
|
Discover how and when to use: Action
queries, Delete queries, Update queries and Crosstab queries. |
| Forms
in Detail |
|
How to use calculated
fields and why the answers are not stored in tables. |
|
Exploring the power of "command
buttons." |
|
What is a Switchboard and why command
buttons are its most important element. |
|
How to set field properties. |
|
Creating Main forms and Sub forms. |
|
How to use "combo boxes"
to save data entry time and make searching for information lightening
fast. |
| Reports
in Detail |
|
How to create more flexible reports
by using parameter queries. |
|
How to group and sorting data for
more meaningful reporting. |
|
How to create calculated fields and
totals. |
|
How to turn a report into a Word
document or Excel spreadsheet. |
|
Discover how to work with
a multiple table report. |
| Tips
from the Pros |
|
What design sequence is best when
creating a database? |
|
Creating a fully automated application. |
|
Discover 5 ways to create forms and
reports in half the time. |
|
How to make your forms look great
- first time, every time. |
|
How to add
polish to your database so it looks like the work of a pro. |
|
Contact
details 
1. Beginners
2. Intermediate
3. Advanced
4. Introduction
to programming
5. Bespoke
training
|
