| Database structure |
| |
Multi-file database solutions
Different types of relationships
Functions and calculations
If statements
nested If statements
Using global fields
Creating summary fields
Verifying data entry |
|
| Productivity |
| |
Complex
find and sort criteria
Using scripts with Find and Sort
Auto enter and validation
When to use the lookup option
Creating a master password
Creating limited access passwords |
|
| Layouts and reports |
| |
Advanced drawing techniques
Layout mode shortcuts
Customising tab order
Field format options
Revision of layout parts
Using sub-summaries
Grand summary parts
Incorporating related fields
Using portals
Sorting records in a portal
Editing related records |
|
| Scripts and buttons |
| |
Creating
a script
Overview of ScriptMaker
Attaching a script to a button
Using graphics as buttons
Invisible buttons
Non-printing buttons |
|