As a bi-product of our transportation analysis experience, Lazarus Consulting provides software training in Microsoft Access, Microsoft Excel, Microsoft PowerPoint and Microsoft MapPoint.  Our primary niche is in the area of advanced Access database design training.

MICROSOFT ACCESS^TM
DATABASE TRAINING
Lazarus Consulting provides customized Microsoft Access training designed around each client’s specific business needs.  If your organization has an existing database need, we will customize a program to complete the database project while also providing valuable training for your staff in the development process.

Our training programs are best suited for experienced professionals, especially those with a strong background in spreadsheets.  Ideal students include professionals such as Accountants, Financial Analysts and Business Analysts.  Our training programs will empower experienced spreadsheet users to dramatically improve productivity by learning to apply an Access database solution to solve almost any business information problem.

Our training methods focus on the practical application of database technology.  Students learn much more than basic tricks and tips.  Most importantly, students learn to think in terms of database design logic.  Each custom training program involves actual client database projects, with emphasis placed on overall project concept design as well as detailed programming and development techniques. 

Currently all database training is based in Access 2000 or Access 2003. Training in Access 2007 will be available soon.  Most training projects will cover all areas of Access development including Tables, Queries, Forms, Reports and Macros. 

Click here to view or download our Access Training Brochure.

MICROSOFT MAPPOINT^TM
INTRODUCTORY TRAINING
Microsoft MapPoint is an excellent tool for making simple maps to design sales territories, map geographic information and analyze trends.  The software is very easy to use and works well with spreadsheet data.

Our MapPoint training program is a 3-hour introductory course that provides new users with the core knowledge and skills to become very effective MapPoint users.  The course also focuses on formatting and managing spreadsheet data to expedite the mapping process.

Most training projects cover all areas of MapPoint including creating territories, importing data, creating legends and a wide variety of tips, tricks and shortcuts.

Click here to view or download our MapPoint Training Brochure.

We also offer excellent training programs for Microsoft Excel and Microsoft PowerPoint.  Please contact us for more information or for a free preliminary consultation regarding any software training program.

Project-driven Access database training customized for your business needs.

PROJECT MENTORING
We will work with your staff member(s) on a scheduled basis once or twice per week until your project is completed. Your staff member will complete the project by being given specific tasks to perform between training sessions. Phone and email support will also be available between face-to-face sessions to keep the project on schedule. 

GROUP TRAINING PROGRAMS
Attendees will learn Access skills while also completing a valuable project. While most group training is focused on real projects and needs specific to your organization, we can also provide general training similar to that provided by the well-known national training organizations. Group training can be provided at your office or an outside location.

CASE STUDY:  NETWORK ANALYSIS
Lazarus Consulting provided a Fortune 500 company with a customized database to manage detailed operating data provided by the company’s truckload transportation providers weekly spreadsheet data files from each transportation provider, allocated certain internal costs and provided detailed cost and operating reports by plant, fleet, load and customer. Once completed, client analysts were able to easily process data, publish reports and maintain the database system.

CASE STUDY:  DATA WAREHOUSES
One of our most common training areas centers on using database technology to quickly organize transactional data from a client’s internal data warehouse system. Lazarus Consulting has developed a number of customized processing and reporting database solutions to provide periodic reporting, data mining and custom data analysis. Training includes a variety of tricks and techniques for creating reporting layers and data views not readily available in pre-existing internal client reporting tools.

CASE STUDY:  COST ALLOCATIONS
Lazarus Consulting designed a detailed database to allocate certain costs and revenues across 3,000+ products and 400+ profit centers. Costs and revenues were allocated based on various combinations of product, location, region, vendor and sales type criteria. After allocation, the system provided detailed reports by location, salesman, vendor and product as well as detailed year-end accounting journal entries.