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 DATABASES
1.1 AN ACCESS DATABASE
1.2 CREATING A DATABASE
Guided Exercise 1 – Create a database
1.3 CREATING YOUR FIRST TABLE
Guided Exercise 2 – Create a table in the student tracker database
Guided Exercise 3 – create fields in the new table
1.4 Data Types
1.5 The Primary or Key Field
1.6 Setting a key field
Guided Exercise 4 – Save the table AND let Access create a key field
2 Enter records into the table
Guided Exercise 5 – inserting records into the table
2.1 ADDING NEW FIELDS (OR EDITING EXISTING FIELDS) TO A TABLE
3 FORMS
Guided exercise 6 - Creating A Form To Input Data Into A Table
3.1 CHANGING THE LAYOUT OF A FORM
a)If you wish to enlarge the form:
b)If you wish to move the field name and data entry boxes:
3.2 INSERTING A NEW FIELD INTO A FORM
3.3 FINDING A RECORD THROUGH A FORM
3.4 PRINTING RECORDS FROM A FORM
4 QUERIES
4.1 CREATING A QUERY
4.2 Selecting fields for a query
Guided exercise 7 – create a query
4.3 SETTING THE CRITERIA FOR THE QUERY:
Displaying fields
4.4 SAVING THE QUERY
4.5 Multiple criteria for queries
The AND query
The OR query
5 REPORTS
5.1 To create a report:
Guided exercise 8 – creating a grouped report
6 USING A DROP DOWN LIST
Create a specific list
Guided exercise 9 – drop down lists
Choose the list from another table
7 LABELS
8 MAIL MERGE WITH WORD
9 EXPORTING DATA TO EXCEL
10 IMPORTING DATA FROM EXCEL TO AN ACCESS DATABASE