Intermediate Course Contents

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

Links | Articles | About us | Privacy Policy