Expert Systems Inc.
Database Technologies
Custom Microsoft Software Solutions
Expert Sytems Inc. - Custom Microsoft Software Solutions
  Skip Navigation Links.              Client Project History
This is a list of some of the projects that we have had the pleasure of working on over the past 20 years.
WhenCompanyProject TitleDescriptionPlatform
2007+Accurate DorwinContract/Quote Forcasting SystemThis System was developed for Accurate Dorwin to replace an existing Excel Application. This system keep track of Quote, Company, Branch and Salesman Data . It allows for one year forcast modeling for Dollar amount, shop hours, field hours and number of boxes. It also includes a Quote/Job Closing and turn around time analysis.Access 2003
2007+Imperial Oil (ESSO)Pipeline and Distribution Document Management SystemThis Pipeline and Distrubution Document Management System was a Redesign of an exiting Application. It is used to manage the location and disposition of domements used by ESSOs Winnipeg Distibution Centre.Access 97
2007+Urban Edge Consulting Inc.Online Survey Management and Analysis SystemThis Online Survey Management and Analysis System was designed to allow the Winnipeg Foundation and Related Organizations to conduct self evaluation surveys for there board of directors. This web based tool allows for the creation and management of Survey Templates, Categories and Questions. A Template Creation Wizard helps Organizations to create the custom survey content that is appropriate for there situation. Once the content is complete the organization creates a survey event. This event tracks the board members and emails out the surveys, sends reminders, etc.. Once all the users have completed there online surveys the System Compiles a Detailed Analysis Report of the survey Results complete with spider chart graphics. It takes minutes instead of days to manage and analyse suvey results. This allows organizations to focus on evalution of the results and implentation of any change strategies necessary.ASP.NET 2.0/MS SQL
2006+Farm Stewardship Association of Manitoba Inc.Environmental Farm Planning Information SystemFarm Stewardship Association of Manitoba Inc. requires a system designed to manage the Environmental Farm Planning Certification Program that meets the Schedule C Data Collection Requirements identified in our meeting.Access 2003
2006+Calm AirCalm Air Flight Logging SystemThis software was developed to replace an existing Flight Logging System. This system is used to track information on Aircraft, Aircraft Types, Routes, Milage, Origin/Destinations, Personnel (Pilots/Attendants) and Air Time Accumulators. Extensive Reporting includes Pilot/Attendant Accumulators, Takeoff/Landings, Air Time Summary/Detail Air Craft Utilization ,and Flights which include Charter Review, Unscheduled Flights, Routings, Tech Record Checks, Depatures.Access 2003
2006+CFBCFSSAT DatabaseThis data was developed for the Canadian Forces School of Survival and Aeromedical Training to manage Hyperbaric Chamber Flight Session Information. This system keeps track of Serials, Flights and Students. The Serial Reports Include Run Sheets, Failed Chambers, Student Certificates, Course Load Sheets and Blank Forms. The Instructor Reports include Annual Summary, Quarterly Stats, Position Counts and (Chamber,Diving,Flight) Allowances.Access 2003
2006+Northern SoulContact Management SystemThis simple Microsoft Access Application was written to keep track of Client Contacts, and Mail Campagnes.Access 2002
2005+Neil Birkett & Sons Inc.Trucking Company Service and Mantenance SystemThis Software was developed to manage Neil Birkett and Sons Inc. Trucking Information. This system includes data Entry for Assets, Service Records, Vendors, Customers, Carriers, Orders, Pending Order Processing and Confirmations. Reporting includes Assets, Service Reports, Fuel Tax Reports, Vendor List, Employee List, Service List.Access 2000
2005+Shippam & AssociatesPromotions Program Management SystemThis system was designed to replace an existing software package. It is used to manage Shipam and Associates Specialty Product Promotion Programs.This includes Companies, Company Catalogues and Customizations, Work Orders, Shipping Lables, Packing Slips, Invoicing and comprehensive reporting.Access 2002
2005+Manitoba Film & SoundInformation Management SystemThis Project Management System was designed to manage MFS Film projects. This system includes Search, Edit and Report interfaces for the following groups of information. Activities (which capture all of the other groups), Project (which includes Dates/Budgets, Company Contacts, Contacts, Cast/Crew, Locations Requests, Filming Locations, Project Scouts, Package Requests and Tracking, Activitis), Contacts (which includes Detail, Projects, Companies, Crew Data, Meetings, Scouts, Locations, Activities), Companies (which includes Contacts, Projects, Meetings, Scouts, Activities), Producer Scouts (which includes Contacts, Expenses, Locations and Activities), Locations (which includes Photos, Scouts, Projects, Scouts, Activities), Meetings (which includes Contacts, Activities, Project).Access 2003
2005+Searcy Trucking Ltd.Trucking Company Fuel/Mileage Tracking SystemThis Sotware was a simple Fuel Tax Management System for Searcy Trucking. It was designed to help manage the Provincial and Federal Tax requirements.Access 2002
2004+Compass FinancialGIC Management SystemThis GIC Management was designed to to track and report on Compass Clients, Agents, Providers, GIC Types and Client Holdings. Processing includes Provider and Agent Commission Processing. Reporting includes GIC Maturing, Commissions Received, Commissions Paid, Holdings Detail.Access 2000
2004+HiQualMicrosoft Access Support ServicesHelped support existing application.Access97
2004+The Burwin InstituteBurwin Online Student Services SystemOnline Student Course Management System - This Software was developed for the Burwin Institute of Diagnostic Medical Ultrasound course management requirements. This system maintains Course, Session, Registration, Student and Inquire information and tracking of enrollment, accounting, assignment, form letter, requests, results and flagging details. The new version of this program include online course assignment for Students. This system was an upgrade from Microsoft Access to ASP.Net and Microsoft SQL Server.ASP.Net 1.0
2004AdvanceCCA Management SoftwareHelped support existing Microsoft Access Tax Management Software. Added Reports and modified tax rate calculations.Access 2000
2003+Canadian Science Centre for Human and Animal HealthCSCFHAAHBio-Safety Cabinet Certification Information Management System The Bio-Safety Cabinet Certification Information Management System was designed to manage Health Canada's Bio-Safety Cabinet Certification Reporting requirements. This system is used for tracking Manufacturers, Instrumentation and Equipment Calibration/Certification report requirements. It is a simple to use point and click interface that eliminates hard copy file lookups and searchs.Access 2000
2003+Udden HoldingsBooking Management SystemReservation Management System.Access 2002
2003+NRCSNRCS System - Analysis PackagePhysical Testing Frequency Analysis Model.Access 2000
2002+Randonee ToursRandonnee Tours - Travel Reservation Information Management SystemThe Travel Reservation Management System was designed to manage the Randonnee's clients, tours and bookings. This system is used for Tours Setup and Pricing, Client Booking information tracking and administration and Booking Costing and tax Information. This system was a complete redesign of an existing Access Database system.Access 2000
2002Kamariss Educational Services Inc.Internet Programming SupportAssisted with CGI Script development for a Online Training Management System.CGI
2001-2007Western Label Co. Ltd.Custom Comtech Image Accounting SystemThis Customized Comtech Image Accounting System is currently used to manage this flexo-label companys Sales and Accounting Information. This system includes GL,AR,AP,SO,PO. The main customization of this system was for a specialized Sales Order Entry System.Access 97
2001+Manitoba Film & SoundFinanacial Management SystemThis Software was developed to manage MFS's Funding for Film and Sound Projects . This system includes the following Information groups: Project , Production Company, Contact, Contracts, Tax Credits. Reporting includes Funding Source Report, Contacts, Tax Credits and Recoupments.Access 2000
2000-2002AgricoreCourse Management SystemEmployee Training and Course Management System.Access 2000
2000The Burwin InstituteCourse Management SystemThis Software was developed for the Burwin Institute of Diagnostic Medical Ultrasound course management requirements. This system maintains Course, Session, Registration, Student and Inquire information and tracking of enrollment, accounting, assignment, form letter, requests, results and flagging details. This system sychronizes data between the Winnipeg and Lunenburg offices via email. This system replaced an existing foxpro/Delphi system.Access 2000/VBA
2000Aboriginal Peoples Television NetworkAPTN Network Information Management SystemThe APTN Network Management System was designed to manage the Networks Information Resources. These included the Organizations, Individuals, Productions, Shot Archives, Acquisitions and Licensing, Scheduling, HTML Generation, Tracking and Reporting.Access 2000/VBA
1999-2000HEPP Manitoba (Health Employees Pension Plan)Payroll Import/Export SystemThis Software was designed to Import information from a mainframe system, process and verify it and create an output file suitable for importing to an accounting system.Access 97/VBA
1999-2000Winkler ConcreteConcrete Batch Invoicing SystemThis software was developed to track customer and sales information for this custom concrete company located in Winkler, MB.Access 2000/VBA
1999-2000ADM Milling Co.Commodity Pricing ModelThis Software was developed for the management and reporting of commodity pricing information for Oats, Durum, Wheat and Corm. This system uses a simple point and click interface to maintain and track daily bank rates, commodity pricing and futures pricing and to generate basis and futures values pricing reports and charts. This model is used to influence the purchasing of commodities and futures for ADM's Canadian mills.Access 97/VBA
1999-2000Tri-Tec Drywall Services Ltd.Sales Order/Quote Management SystemThis Software was developed for the quotation and sales of construction materials and drywall supplies. It features specialized pricing, costing, margin calculations for quotations, sales orders and invoicing. This system was integrated with the existing AR software.Access 97/VBA
1998-1999ADM Milling Co.Plant Position & Grain Contract Management SystemThis Software was developed for the management and reporting of accounting information for ADM's eighteen Canadian mills. This system uses a simple point and click interface to maintain and track the daily business postings of financial positions and contract invoicing for these mills.Access 97/VBA
1997-2000PrimeBoard, Inc.PrimeBoard Information SystemThis dBase IV Database Management System computerizes and integrates this straw board manufacturers raw material sources, production data, quality control data, preventative maintenance and accounting. The SourceMates' Accountmate Accounting Software Modules include GL,AR and AP. Customized Sales Order, Inventory and Preventative Maintenance Modules were integrated into this system.dBase IV
1997-2000Public Service Commission of CanadaCareers in MotionInternet based Database/Web Application. This system was designed to manage employee registrations and skills inventories for a human resources employment opportunity matching system. This system was designed using HTML, JavaScript and Perl CGI scripts.This application is presently used by thirty federal departments in the City of Winnipeg.HTML,JavaScript, Perl
1997-1988Buffalo Credit Union Ltd.Program and Network SupportAssisted with Basis Networking and Support ServicesNovell
1996-1998Edwards Service DivisionWindows/NT SupportProvided Windows Networking SupportWindows NT
1994-2000Red River CollegeThe Hazardous Materials ExpertThis Occupational Safety & Health Information Management and Reporting Software was designed for Canada's Workplace Hazardous Materials Information System (WHMIS) and Manitoba's Workplace Health Hazard Regulation (WHHR). The Hazardous Materials Expert addresses the unique information processing and reporting requirements of the legislation through a series of integrated software modules; WHMIS MSDS, WHMIS Labeling, Worker Training, WHHR Inventory and Material Tracking.Clipper
1993-1997Public Service Commission of CanadaInter-Departmental Mobility SystemThis Network/Dial Up Clipper Database Management System was designed to manage employee registrations and skills inventories for a human resources employment opportunity matching system. This systems was later altered to address the requirements of managing civil servant transitions from Affected to Alternate positions. This application is presently used by thirty federal departments in the City of Winnipeg and Thunder Bay.Clipper V/dBase V
1991-1997Transport CanadaAirport Terminal Building Space Rental Rate SystemThis Network Clipper Database Management and Reporting system is used in airport facilities under Transport Canada Mid-Western Region's jurisdiction. These include airports in Saskatchewan, Manitoba and North Western Ontario (Canada). This system is a complex Capital and Operations and Maintenance cost tracking model designed to accurately determine space rental rates based on the cost recovery criteria defined in Transport Canada policies and procedures guidelines. This system replaced an existing spreadsheet model.Clipper
1990-2000Western Label Co. Ltd.Custom Account Mate Accounting SystemThis Customized Network Clipper AccountMate Accounting System is currently used to manage this flexo-label companys Sales and Accounting Information. This system includes GL,AR,AP,SO,PO. The main customization of this system was for a specialized Sales Order Entry System.Clipper
1989-1997Custom Cheques of CanadaCustom Invoicing SystemThis Clipper Database Management System was designed for the Printing and Reporting of Invoicing InformationClipper
1989-1997Custom Cheques of CanadaDocket Management SystemThis Clipper Database Production Docket management system was designed to create production docket sheets and manage number heads and cheque number sequencing.Clipper
 The Canadian Wheat Board   
 
Expert Systems Inc. 200-32 Balmoral St. Winnipeg, Manitoba, R3C 1X4 Phone: 1-204-786-1069 Email: expert@expertsystems.com