JPL JPL jpl
Home Home Home  
News / Frequently Asked Question & Tips -
Recent News
Click here for archive news

Jan 2009
Continuing with Microsoft Excel, PowerPoint and Access training courses for Iscar Tools in Birmingham
Increasing number of enquiries through web based marketing and google especially for Excel, PowerPoint, Word and Access training
Excel training course for Tiger Turf in Worcestershire
Mapics consultancy and programming on As400 for Kores in Essex, UK
Microsoft training courses for Chamber of Commerce
Access database development for Nexus Beds in Droitwich, Worcestershire



Dec 2008
Continuing Microsoft Access training for company in Birmingham.
Mapics As400 project for valves company in Bristol.
Training in Microsoft Access for company in Redditch, Worcestershire.
AS400 and Mapics consultancy for company in Essex.
Database design and implementation for Droitwich based bed company.
Meeting Infor for Mapics review.

Nov 2008
Conducting Microsoft Basic and Intermediate Training courses for ocmpany in Birmingham.
Gained AS400 work to run Query 400 course for Quinn Insurance in Ireland.
Gained 2 day contract for AS400 operations and support training for companny in North East.
Mapics and As400 support work in Bristol and Colchester and Harlow.
Excel training for Worcestershire company.
AS400 disk cleanup work for Iscar Tools.
RPG programming for Iscar in Birmingham.
Microsoft Access training and Advanced Excel training for Chamber Of Commerce in Worcestershire.

Oct 2008
Work gained this month includes:
AS400 (iSeries)/Mapics project for Price Variance for IMI Webber in Bristol. this will involve RPG and Query 400 programs.
A 2 day training vourse in Query 400 for Quinn Direct Insurance in Ireland
2 days of Excel training for Iscar Tools in Birmingham
I am continuing with Microsoft Training courses for the Chamber Of Commerce Herefordshire & Worcestershire.
Continuing development of Access database with Tooles Transport in Droitwich
Ad hoc PC work and training for Carers Careline in Redditch

Sept 2008
AS400/iSeries work for several companies using Mapics ERP software.
2 day Advanced Query 400 course for large Quinn company in Ireland.
Basic and Advanced Excel training for Iscar Tools in Birmingham.
Microsoft Access further development for Midlands food company.
Access, Excel and Outlook courses for the Chamber Of Commerce In Herefordshire and Worcestershire.
Intermediate Word training for private individual in Stratford.
MS Access Database training for Tooles Transport in Droitwich.
IT Training for charity workers in Redditch.
Meeting with Infor to discuss future business developments.

Aug 2008
Continuing Microsoft Access database development for midlands food company
Microsoft Access training for Tooles Transport in Droitwich, Worcestershire
Mapics consultancy for IMI Webber
Gained new contract for PC training for photography company in Worcester
Word training for Chamber of Commerce

July 2008
Conducting more Microsoft Access development for Scheff Foods in Birmingham
Contract gained for 4 days PowerPoint and Excel training for One Ltd in Worcestershire.
2 day training course planned in Access for The Rowan Charity
One day Excel training planned for Adams Carpets in Hartlebury
Two days Excel training for Kidderminster college
Mapics consultancy continuing and AS400 support for Webber, MGE and Kores
AS400 Query training taken place for Quinn Glass in Chester.

June 2008
Special offer for Mapics users. 1 day audit and half normal fee. Please fill in contact page details for more information.
Continuing work for Scheff Fodds on Access database development.
Courses to be conducted this month include:
Mapics introduction for IMI Webber
Query 400 for Quinn Glass in Elton
Microsoft Excel for Enterprise Rent A Car
MS office 2007 training for Chamber Of Commerce

May 2008
Conducting Mapics and As400 consultancy and training in Essex including Query 400 programming.
Continuing Access database development for Scheff Foods in Birmingham.
Excel and Access training for Chamber of Commerce.

April 2008
Conducted Intermediate Excel training for Midlans company Enterprose based in Banbury.
Continuing Access development for Birmingham based company Scheff Foods.
Training Chamber of Commerce company in Hereford in Excel.
Gave on site call out support in Mapics for Essex company following serious Mapics error caused loss of use of Purchasing enquiry.
Developed iSeries 400 operations and support course for IT network specialist in Bristol .

Mar 2008
Conducting training courses for Chamber Of Commerce in Excel & Access.
Continued training for Enterprise Rent A Car in Microsoft Word in Redditch.
Continuing with Mapics and As400 consultancy and developments.

Feb 2008
Ran Advanced Excel course for SciChem in Bilston.
Won contract to run training courses in Word, Outlook and Excel for Enterprise Rent A Car
Conducted Microsoft consultancy and training for Chessgrove Spa and Tooles Transport
Continuing Access database development for Chamber of Commerce customer.
Gained PowerPoint training contract for company in Milton Keynes.
Mapics training for IMI Webber in Bristol.
Microsoft Office course agendas now on line on the MS Office web page on this site. Feel free to download or peruse.
Conducting a course for Kidderminster college in Advanced Excel.

Jan 2008
New Advanced Excel course developed
New Customer comments page on site
Work gained with Chessgrove Spa, SciChem and Chamber of Commerce contracts over the next couple of months.

Dec 2007
Access Database training for SciChem in Bilston.
Two day course on Query 400 for Iscar Tools in Birmingham.
Microsoft Outlook and Excel trianing for Chessgrove Spa Bromsgrove.
Chamber of Commerce Microsoft training in a variety of modules including Access 2007 and Advanced Excel.
Mapics and AS400 consultancy for IMI Webber and MGE.

Nov 2007
New work planned for this month includes:
Chamber of Commerce associate Microsoft Office training
Outlook training for Tooles Transport in Droitwich
Microsoft Access training for 2 companies in the Midlands
Intermediate Word and Excel training for a Droitwich company
ISeries 400 and Mapics training for IMI Webber in Bristol

Oct 2007
Won business with a Redditch manufacturing company to build an Access Prospect Database for their sales people to use.
Running several Chamber of Commerce courses for Worcestershire & Herefordshire companies throughout October.
Continuing with Mapics and As400 Query, Mapics and RPG work.

Sept 2007
Won contract from IMI Cornelius to conduct Mapics training course and Query 400 training in Alcester and Sheffield.
Conducting further Excel training in Redditch for Enterprise Car Hire.
Conducting further Microsoft courses in Worcestershire on behalf of the Chamber of Commerce including Access and Excel.
Access database development for SciChem Chemicals and Supplies company in Bilston.

August 2007
I shall be conducting an AS400/Iseries 400 training course in Birmingham for a Tools company covering through a two day workshop all the essential features required to manage and support an AS400 environment.
On behalf of the Chamber I shall be running a Microsoft Excel and Word course in Office 2007 for a welding company in Ledbury.

July 2007
Won contract to start work on prospect information Microsoft Access database for Armstrong Burton Architects in Sutton Coldfield.
Won contract for ISeries 400 Query training for SAS Automotive in Solihull.
Microsoft Office Excel and Outlook training for  Heating company in Ledbury  on behalf of the Chamber Of Commerce H&W due to start
MS Outlook training planned for Tourist company near Malvern for the Chamber of Commerce.

June 2007
Conducted beginners and advanced Query 400 training for Quinn Group in Ireland.
Further Microsoft Office courses delivered on behalf of Chamber of Commerce.
Access database training delivered to Burton Armstrong architects in Sutton Coldfield.
Access training to be delivered for local Art and Design College.

May 2007
Started IT training work for local heating company in London and Manchester.
Continuing Mapics and AS400 work.
Chamber of Commerce Associate work in Microsoft Office training.

Apr 2007
John has passed his TAP Delivery Skills Refresher Course and has therefore gained TAP certification.
Starting work this month on an Access Database Design for local Droitwich business.

March 2007
Won business to develop a Database in Access for local specialist bed company
Won contract to perform Microsoft Office training for a Ledbury heating company through the Chamber of Commerce.
Continued with Mapics consultancy for Kores, MGE and IMI Webber.
AS400 programming design work for sales picking lists for Webber in Bristol.
Trained new member of staff for Carers Careline in Redditch on Excel and Word.

Feb 2007
During Feb I've conducted a number of training courses on behalf of the Chamber Of Commerce in Access, PowerPoint and Excel.
I've also had the opportunity to develop a prospect database for a Farm Foods company in Herefordshire.
Conducted AS400 Query training for staff worknig for Quinn Group in Ireland.

Jan 2007
I have gained some Microsoft training work for Bosch UK and some preliminary consultancy work on Access with bed company in Droitwich.

Jan 2007
I shall be conducting AS400 and Microsoft courses for Quinn Ireland, a Worcestershire heating company, the Chamber Of Commerce Herefordshire & Worcestershire and a charity called Carers Careline.
Mapics consultancy assignments his month include Webber, MG Electric and Kores Nordic and IMI Cornelius.
I have also supported recently a new customer who had Access Database issues.

December 2006
John conducted a series of IT courses in Outlook 2003 for the Fire Officers in the county
He secured work for Jan 2007 to conduct training in Ireland for Quinn Enterprises.

Sept 2006
John Legge has become an accredited member of the Institute of IT Trainers.
Continued during the month to run a variety of IT courses including Mapics MRP, Access, Excel and PowerPoint.

Aug 2006
Completed project for IMI Webber to include material surcharges on all their software linked to Mapics
Microsoft Office training in Intermediate Excel for Carers Careline
Gained orders for work in September from Barloworld Scientific in Stone and Kores in Harlow for Mapics education.

May 2006
Won business for Scientific and Chemical Company in Bilston to conduct a 2 days Access course.
Continued with Microsoft training for Chamber of Commerce.

Mar 2006
Continuing work with the Chamber of Commerce in Hereford & Worcestershire on a training programme for the Fire Brigade.

Mar 2006
Developed a full 1 day course on an 'Introduction to AS400 RPG programming'. Please contact us for details

Feb 2006
Performed AS400 Query training for Quinn in Ireland.
Won more business with Chamber Of Commerce for training courses in MS Excel

Feb 2006
New Customer in Northern Ireland gained. AS400 Query course to be conducted for the Quinn Group. Further Excel training to be conducted for IMI Webber in Bristol,


FAQ's
iSeries AS/400
How do I start off using AS/400 Performance collection?

Use the STRPFRT command and select the option to collect performance data. I suggest a period of 2 hours twice a week. The reports produced can be quite intimidating but the enquiry will get you started in monitoring the responses and transactions counts

Internet
What are the key points in building a Web site?

First get a domain name registered. This takes the form for example 'name.co.uk' or 'name.com' where name is unique to your business.

It is preferable then to link all your email addresses to your domain name so that people can send emails to john@name.co.uk or sales@name.co.uk instead of the more common ISP email addresses around ending in demon.co.uk or aol.com ; this is called email forwarding.

Design your web site on paper or using an editor like word or Frontpage.

Get it done professionally.

Register various search words or 'tags' with the main search engines.

Keep it upto date.

There are specialist companies who provide some of these services and we will be pleased to link you up with them.

Mapics
Popular Mapics files

Here is a list of the most popular Mapics files I use when writing queries.
MBBFREP - Customer File in COM
ITEMASA - Item Master File
MBF9REP - COM Invoice file
POMAST - Puchase Order file
MOMAST - Mfg Order File
SLQNTY - Stock Location File
IMHIST - Inventory Management History file
VENNAM - Vendor Master File
If you have any questions on these or other please email us on inquiries@jplcomputer.co.uk


Keep a watchful eye on this page for more Hints and Tips.

We offer detail support and implementation for any of these topics so if you would like assistance in making them work for you please e-mail your requirements and we will be pleased to help.