Advanced Course Contents

Advanced Tables

	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

Links | Articles | About us | Privacy Policy