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
Access 2003 advanced
1 database Design
1.1 first normal form (No Repeating Groups)
1.2 Second Normal Form (Eliminate Redundant Data)
1.3 third normal form (Eliminate fields that do not depend on the key field)
2 Developing a database
2.1 step one – what kind of data is needed?
2.2 step two – go through the normalisation process
2.3 step three – types of field that will be used?
2.4 step four – create the tables and the relationships
2.5 step five – insert test data
2.6 step six – create forms queries and reports
2.7 step seven – insert real data
2.8 step eight – ask opinions?
3 Understanding relationships between tables using access
3.1 One To Many relationship
3.2 many to Many relationship
3.3 One To One relationship
4 Referential Integrity and creating relationships
4.1 referential integrity
Cascade Update Related Fields
Cascade Delete Related Records
4.2 creating relationships in an access database
Create a drop down list between the tables
Guided exercise 1
5 list box or combo boxes
To sort a list or combo box alphabetically
6 Check boxes, option buttons and toggle buttons
Guided exercise 2
7 Option groups
Guided exercise 3 – creating an option group
8 Creating forms with multiple pages or tabs
Guided exercise 4
8.2 Change page order
8.3 insert extra pages
9 Calculations in queries and total queries
guided exercise 5 – using a total query
9.2 Updating data from a query
Guided exercise 6 – updating data in a table using a single table query
Guided exercise 7 – updating data in a table using a multi-table query
10 Calculations in forms
Guided exercise 8 – calculations in forms
the Nz Function
11 calculations in reports
Guided exercise 9 – calculations in reports
12 If statements
Guided exercise 10 – If statement
13 Use a crosstab query
Guided exercise 11
14 LINKING TABLES