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 Database Design
1.1 First Normal Form
1.2 Second Normal Form
2 Relationships
2.1 One to Many Relationships
2.2 Many to Many relationship
2.3 A One To One relationship
2.4 Creating Relationships
Guied Exercise 1 - Use a Drop Down Field to create the Relationship
Cascade Update Related Fields
Cascade Delete Related Records
3 Multi-Table Queries
Guided Exercise 2 - Using more than one table in a query.
4 The Parameter Query- a Review
Guided Exercise 3 – A Parameter Query
5 Action Queries
5.1 The Make Table Query
5.2 The Delete Query
Guided exercise 4 - Using a make table and delete query:
5.3 The Append Query
Guided exercise 5 - Using the append query:
5.4 Update queries
Guided exercise 6 - Using the update query:
6 Forms and Sub-Forms
Guided exercise 7 - Creating a sub-form
7 Reports
7.1 Grouped reports
Guided Exercise 8
7.2 Changing Report Layout
Guided Exercise 9
8 Command Buttons
Guided exercise 10 – creating command buttons
9 Start Up Form
Guided Exercise 11 – Create a Startup Form
9.1 Add buttons to the StartUp Form