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 OVERVIEW OF DATABASES
The Flat File Database
The Relational Database
1.2 AN ACCESS DATABASE
a) Naming Conventions
2 CREATING A NEW DATABASE
Guided Exercise 1 – Create a Database
3 TABLES
3.2 CREATE A TABLE TO STORE RECORDS
Guided Exercise 2 – Create a Table
a) The Primary or Key Field
b) Data Types
Guided Exercise 3 – Create fields in a New Table
c) To Set a key field
3.3 INSERT RECORDS INTO A TABLE
Guided Exercise 4 – Insert Records Directly into a Table
3.4 ADDING NEW FIELDS OR CHANGING EXISTING FIELDS IN A TABLE
4 FORMS
Guided exercise 5 - Create A Form To Insert Data Into A Table
4.2 FILTER OR SORT INFORMATION USING THE FORM
4.3 CHANGE THE LAYOUT OF A FORM
a) To change the size of individual fields on a form:
b) Insert a Field into a Form
Guided Exercise 6 – Insert New Records Using a Form
5 QUERIES
Guided Exercise 7- Create a Select Query
a) Criteria that can be used for Select Queries
5.2 DISPLAY FIELDS IN A QUERY
5.3 SAVE A QUERY
5.4 MULTIPLE CRITERIA FOR QUERIES
a) The AND query
b) The OR query
6 REPORTS
Guided exercise 8 – creating a grouped report
7 USING A DROP DOWN LIST
a) Create a specific list
Guided exercise 9 – drop down list using a typed list
b) Create a Table to store a Drop Down List
Guided exercise 10 – drop down list from another table
8 LABELS
9 MAIL MERGE WITH WORD
10 INPUT MASKS
Guided exercise 11 - Creating an input mask
11 VALIDATION OF DATA ENTRY
Guided exercise 12 – validation of data