JPL JPL jpl
JPL
JPL
JPL
Home Home Home  
Contact News IT Consultancy MS Office Mapics AS 400 Customer Comments
JPL JPL JPL
John P Legge Computer Services
News / Frequently Asked Question & Tips -
Archive News

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,

Nov 2005
We have been running courses for the H&W Chamber of Commerce in a variety of Microsoft packages and also a series of private IT courses for Hydro Aluminium in Redditch. We've also won business in Bristol for training and in Runcorn for Mapics consultancy work. As part of the MDDI scheme John is doing work for a client in Liverpool which seeks to assist MD's in SME's with their training needs.

Oct 2005
I have recently conducted a mapics study at Concord Lighting in Sussex. I am also delivering Ms Outlook courses for the Chamber of Commerce in Worcestershire. For further details please email me.

July 2005
We installed a complete PC security system by Norton into Tooles transport of Droitwich and resolved many of their email issues.

May 2005
Established a relationship with Pitman training centres in Worcester to conduct future courses with them.

Apr 2005
NEW 1 day Intermediate Access course developed. For details please email us

April 2005
Designed and implemented an EDI system on the ISeries 400 at Webber in Bristol. This system takes remote sales orders from customers into the Mapics ERP system. PowerPoint course to be run for Solutions Child Care.

Feb 2005
Sold our software product 'Contact/Prospect' database written in Access to Birmingham City Council Shelforce. For further details please email us.

Feb 2005
Conducted a 2 day Mapics audit in the Customer Service department of IMI Cornelius in Sheffield. This greatly assisted the users in their understanding of the Mapics COM application.

Jan 2005
We are offering in the months of Jan, Feb and Mar for new potential customers a one day Mapics Review of their systems at an exceptional price. Please contact us for further details.

Also new updated PowerPoint course released for delivery. Again email for details.

Nov 2004
Attended a BCS lecture on 'Accessibility of web sites'. This was aimed at informing systems or marketing personnel responsible for the development of web sites to make them aware that the web site must be accessible for disabled people. For more information please email me.

Oct 2004
Conducted PowerPoint training course for Herefordshire & Worcestershire Chamber of Commerce. Developed a performance monitoring system and helped with training for Honeywell.

July 2004
I completed my Cotswold Way walk on Sunday 4th July in Bath at 3pm. For those of you following progress on this site you will have read that the weather was kind to me, I met some great people at the B&B's I stayed at and also on the walk.Highlights for me were the first days walk with Graham from Chipping Campden to Winchcombe, Mid week walk with Caroline from Painswick to Kings Stanley (a nice short one!!), the walk over Long Cam Down nr Dursley, the meeting up with 2 walkers for my last two days, seeing Di every other day and Naomi at Bath. I was surprised by the amount of woodland walks (about one third) and the steepness of some of the climbs. It was however a really great week. I'm now collecting in the sponsor money and am expecting to raise around £500 for Macmillan Cancer relief.
A big thank you to everyone who supported me in any way.

May 2004
Acquired a new customer, Honeywell Security in Runcorn. Performed a Mapics audit for them and subsequent consultancy covering Mapics Purchasing and MRP functions.

Feb 2004
Developed an Incident and Claims database in Access for Tooles Transport of Droitwich.

Jan 2004
** Announcement ** John will be walking the Cotswold Way which is a long distance footpath of about 100 miles from Chipping Campden to Bath at the end of June.He will be raising money for Macmillan cancer relief. If you would like to sponsor him please get in touch, initially by email on costwoldway@jplcomputer.co.uk. The URL for the Macmillan site featuring John's walk is :
http://www.macmillan.org.uk/supportus/inarea.asp?region=5&area=145&option=3

Dec 2003
Conducted demonstrations of Intuator at MG Electric and IMI Cornelius.

Nov 2003
Conducted Access database training course for the local Redditch Borough Council Economic Development department. Contact us for details at enquiries@jplcomputer.co.uk. Engaged in a business relationship for 'Jacana InTuator' with Momentum. The InTuator product is an efficient and cost effective data extraction tool which sits across Mapics ERP on the iSeries 400 range. It covers data analysis across all modules. Please get in touch to arrange a demo on line.

September 2003
Attended a seminar on E Commerce and the Law. It is important to realise that there are many legal aspects associated with selling on the Internet. We can offer a free fact sheet detailing guidelines in this area. Contact us for details.

July 2003
Successfully went live at IMI Webber with WIP/FGI system using Mapics XA on iSeries 400.

May 2003
Ran iSeries Query 400 Training course for IMI Cornelius on JBA business accounting applications.For details of similar courses on other ERP systems including Mapics please email us.

April 2003
Started WIP and FGI Systems Implementation at IMI Webber, Bristol.

March 2003
Completed a conversion from Mapics XA4 to Mapics XA6 for a manufacturing company in Essex.

February 2003
Recently attended a seminar on email and internet security. This covered topics such as hackers, spam mail and company policy.Please contact us if this is an area of concern in your company as we may be able to assist.

January 2003
We have launched a link to a PowerPoint presentation on XML on our IT consultancy page.
Feel free to have a look at this and reply back with comments of interest.

December 2002
Attended a lecture as part of the British Computer Society on XML in SME's. We intend to put a PowerPoint presentation on this topic on the site soon - so watch for further details.
Attended a B2B presentation at the National B2B Centre at University of Warwick. Topics inlcuded the use of 'Open Source' progamming for Web design. For further details please email us.

November 2002
Assisted a manufacturing company in Essex with installation of an iSeries AS400.

October 2002
Implemented EDI statements between two key commercial companies in the drinks dispense industry.
Conducted Microsoft PowerPoint training course for two sales managers in Leicester.

September 2002
Recently completed a Data extraction exercise for a software company operating with a large finance house in Sussex. This involved analysing the AS400 database and writing queries and programs to effect a transfer to their SQL package.

August 2002
We are continuing working with an IMI subsidiary in Bristol enhancing their use of Mapics XA on the iSeries AS/400. They are using a variety of Mapics modules including Accounting Management, Purchasing and COM. We conduct training courses for them and are fully integrated with their IT dept. to assist with problem solving and project implementation.

July 2002
We were involved with the successful 'going live' of a new Mapics XA site in Leicester. My involvement included planning, training, writing of some simple update programs and handholding in the early days.
The site was one of our early customers when I started up our business and it was good to see them change over to the Mapics system which the rest of the IMI Cornelius group are using.

July 2002 - Special Offers on training Courses
We are currently able to offer special prices on Microsoft Training courses when 2 or more courses are booked in block for September and October.
For details of courses see web site and for prices contact us via email.

June 2002
Final training in Mapics conducted for Gaskell & Chambers division of IMI Cornelius as they are integrated onto the AS/400 Mapics XA system.

April 2002
Started project to implement Mapics XA at a site in Leicester from Unix CS3 system.

February 2002
Completed EDI work for Harlow manufacturing customer with large stationery chain.

January 2002
Completed EDI work for Midlands Customer with large food retail chain.

October 2001
Designed and conducted MS Office PowerPoint course training

September 2001
Updated Web Site to contain JPL news/ FAQ / World PC News. Thank to Elaine Parry for new photos.

June 2001
Became member of the British Computer Society

May 2001
Developed Contact Management database for 'Prospecting and Call Management' in access for resale to small and medium business

April 2001
Developed Admissions database for Residential Care Home

JPL
FAQ's
AS400
How do I calculate the size of a library?

Use the GO DISKTASKS command to run on a weekly schedule and then use the Print disk space option within that command to see the size of both the library and objects within it.

MS Office
Can I create calendar anniversary or birthday dates in MS Outlook from my Access database?

Yes. This can be achieved by using the 'File Import' Wizard from within Outlook. You can then select to import from an Access database and map from Access fields to the Outlook Calendar by first creating a Contact.

Mapics

Informational PTF SH01200 has a large amount of useful details regarding announcements for Mapics releases.
You can also download the latest PTF summary to see how up to date or behind you are!!
This ptf can be accessed using the AFDWEBGET Internet commands once you have downloaded the Ptf from the Internet or by using SNDPTFMAPS in ADFSRC.

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.