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.