MSC Computer Training Booklets
The booklets that are sold on this website have been developed over a number of years with the kind assistance of our customers, and it is they who suggested that we market and sell them as part of our service.
We pride ourselves on producing easy to follow booklets with simple instructions, Illustrations and Guided Exercises that deal with the practicalities of using the particular programme(s). These help to explain how to carry out the skills that you need to develop in any particular programme. Included in the cost of the booklets are:
• A CD containing exercise files
• Printed exercise sheets
• Postage and Packing
Our books are not ALL listed on the website so if you can’t see the skill that you need to develop in the contents list please contact us at enquiries@msctraining.co.uk and we can get back to you.
CONTENTS
Command Buttons
To Create a Command Button With the Wizard
Worked example
1. start up forms
Worked Example of using a startup form:
changing the colour and design of a form
Placing text on the form
Changing the colour of the form
2. The parameter query
3. Action queries
3.1 The Make Table Query
3.2 delete queries
To create a Delete Query
Worked Example of using the make table and delete query:
When the query has been run and you have returned to query design view
3.3 The Append Query
Worked Example of using the append query:
3.4 update queries
To create an update query
Field name
Worked Example of using the update query:
4. calculations in queries
Worked Example of using calculations in queries
5. Calculations in reports
To Create A Calculated Control
Worked Example of using calculations in reports:
6. relationships between tables
6.1 One To Many
6.2 Many to Many
6.3 One To One
6.4 Creating The relationships
6.5 Join Types
To Create An Equi-Join:
To Create An Outer Join Or Change The Type Of Join
6.6 Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
worked example of creating a relationship between two tables
7. multi-table queries
Table
Field
8. forms and sub-forms
worked example of creating a sub-form