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
1 How this booklet works
2 Review of relationships
2.1 One To Many relationship
2.2 Many to Many relationship
2.3 One To One relationship
2.4 Referential Integrity
2.5 Cascade Update Related Fields
2.6 Cascade Delete Related Records
3 List box or combo boxes
Guided Exercise 1 – Create List and Combo boxes
4 Option buttons, Check boxes and toggle buttons
Guided Exercise 2 – Create Option buttons
5 Option groups
Guided Exercise 3 – Creating an Option Group
6 Creating forms with multiple pages or tabs
Guided Exercise 4 – page tabs
6.1 Page tab with a subform based on a query
Guided Exercise 5 – placing a subform based on a multi-table query onto a tabbed page
6.2 Changing the behaviour of fields in a form
Guided Exercise 6 – changing the behaviour of fields in a form
6.3 Change page/tab order
6.4 Insert extra pages/tabs
7 Calculations in queries
7.1 Creating a calculated field in a query
Guided Exercise 7 – creating a calculated field in a query
Guided Exercise 8 – Using a calculated field in a Report
7.2 Using a total query
Guided exercise 9 – creating a total query
8 Calculations in forms
Guided Exercise 11 – calculations in forms
The Nz Function
9 Calculations in reports
Guided exercise 12 – calculations in reports using the summary option
10 If statements
Guided Exercise 13 – IIf statements
10.1 Conditional formatting
11 Use a crosstab query
Guided Exercise 14
12 LINKING TABLES
12.1 To link tables