Beginners Course Contents

Database Primer
	What is a flat file database and why are they too limited for most applications?
	What is a relational database and how can it help you?
	When must you use a relational database?
	When should you use Excel and when should you use Access?
Table Creation
	What are tables and why are they the building blocks of Access?
	What are: fields, data types, primary key?
	3 essential tips on correctly naming fields.
	Why every table must have a primary key.
	How to create relationships between tables.
	How to add fields to an existing table.
	What are records?
	The 7 critical steps all Access users must take when designing a table.
	Why you should never use the form wizard?
	The 5 simple mistakes every beginner makes when creating tables and how to avoid them.
Query Creation
	What are queries and why are they so important?
	How to design a Select query to interrogate your data.
	Using parameter queries to make your query use more flexible.
	What is a Dynaset?
	How to add fields to a query you made earlier.
Form Creation
	What are forms and when are they used?
	Why forms are the "bricks" of a Microsoft Access application.
	How to create a form for easy data entry.
	What are the types of form and when should you use each?
	How design view can make your forms look how you want.
	How to add fields to an existing form.
	10 common mistakes beginners make when designing forms.
Report Creation
	What are reports and when would you use them?
	How to create a professional looking report.
	What are the types of report and when should you use each one.
	Why understanding design view is essential if you want valuable reports.
Macros
	What is a macro and why are they used?
	What is the autoexec macro and why is it so important?
	How to create a simple autoexec macro.
Essential Tips
	When should you use the wizard for: tables, queries, forms and reports?
	How you can create a user friendly application with command buttons.
	How to get immediate help when you are stuck for what to do.
	Why more time spent planning can save you hours in the long run.
	How the right mouse button can save you heaps of time when designing in Access.
Contact details 1. Beginners 2. Intermediate 3. Advanced 4. Introduction to programming 5. Bespoke training

Links | Articles | About us | Privacy Policy