Expert Systems Inc. Expert Systems Inc.
Database Technologies
Client Project History
Skip Navigation Links.
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
2009+ADM Milling CoPlant Blending and Pricing SystemThis software was developed to replace and existing spreadsheet system that was becoming unmanagable. This system is used to create blending cost and pricing targets through a series of data input forms and reporting sections.Access 2003
2009+Aboriginal Peoples Television NetworkAPTN Mail / Invoice Tracking SystemThis Web Based Mail and Invoice Tracking System was designed to manage all incoming and Outgoing Mail Item. The Invoice Tracking is used to track AP Accruals for multiple GL Acounts. The reporting is used to balance with the main Accounting System.ASP.NET MSSQL
2009+RS Distribution Services Ltd.RS Live Web SiteThe RS Live site is integrated with then Access Order Entry System. It provides Online Order Entry, Reporting and more.ASP.NET MSSQL
2009+San GoldGeological Database This system was a rewrite of an existing Monthend Production Management Access Database.Access 2007
2009+San GoldProduction DatabaseThis system was a rewrite of an exitsting Production management Access Database.Access 2007
2009+Western TurboWestern Turbo System SupportSupport for Ingrated Accounting/Inventory Management SystemAccess 2003
2009 +RS Distribution Services Ltd.Order Entry / Inventory Management SytemsThis software was a replacement for an existing Order Entry/Inventory Management System.Access 2003
2008+MGEAMGEA - Online Membership and Permitting System MGEA - Online Membership and Permitting System ASP.Net MS SQL
2008+THEXTERIORGROUPJob/Workorder Management SystemThis system was designed to manage THEXTERIORGROUP Job Costing/WorkOrder Information. This includes Jobs, Materials,Labor,Work Orders, Purchase Orders, SubContractors, Vendors, Customers and comprehensive reporting.Access 2003
2008+Harmony SystemsGC Logger - Core Sample Logging ProgramProvided support for transition of existing Core Sampling Application from MS Access backend database to MS SQL Server. This application is designed to keep data relevant to core sampling, lithologies, assays, sample data, etc.Microsoft Access 2000 MS SQL Server 2005
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+Child and Family all Nations Coordinated Reponse NetworkANCR File ManagerThis Access Software was designed to track people and case files.Microsoft Access 2003
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
2007+Pyrene Fire Security Man.Fire Testing and Inspection Access Reporting SystemHelped support existing Microsoft Access Fire Alarm Testing and Inspection Reporting Software. Added Reports and modified exiting reports.Access 2003
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+CFSSATCFSSAT 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+The Manitoba Habitat Heritage CorporationMHCC - Information Management SystemThis Internet Application is an Upgrade from a Microsoft Acccess Application. This system is used for tracking Employees, Employee Timesheets, Employee Vehicle and Expense Claims. It includes Comprehensive Reporting that sorts groups and queries in variety of ways..ASP.Net/MS SQL
2006+Northern SoulContact Management SystemThis simple Microsoft Access Application was written to keep track of Client Contacts, and Mail Campagnes.Access 2002
2006+HEPP Manitoba (Health Employees Pension Plan)HEBP LOA Cheque ProcessingThis LOA (leave of absense) Cheque Processing System was designed to help HEBP manage the large volumes cheque information that were being tracked on excel spreadsheets. This system included Records Search, Sick LOA Payment Processing, Payment Processing, Deposits and NSF Cheque processing. Reports include LOA Payment, Cheque Payment, Cheque Deposit, NSF Cheque Detail, Personal Data.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
2005+Prophet Business GroupTime Tracking Work Order ProcessingThis Software was Developed for Prophet (a Great Plains Software Dealer) to manage the work orders related to customer support. This system includes Work Orders, Work Order Items, Customers and Consultants and Reporting. Access XP
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+National Screen InstituteNSI Information Management SystemThis Program Management System was designed to help NSI manage and track contact and project information.Access 2002
2003+Udden HoldingsBooking Management SystemReservation Management System.Access 2002
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+The Manitoba Habitat Heritage CorporationMHHC - Information Management SystemThis Information Management System was designed to manage MHHC information tracking and processing requirements. This system is used for tracking Land Owners, Files, Conservation Agreements, Riparian Stewardship Agreements, Acquired Lands and Leases, Leased Lands. Nest Structures, Locations, etc. This system includes integration functions for Great Plains Accounting Software. This System was a complete redesign of an existing Access Database.Access 2000
2003+NRCSNRCS System - Analysis PackagePhysical Testing Frequency Analysis Model.Access 2000
2002-2008Randonee 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
2002+The Manitoba Habitat Heritage CorporationMHHC - Timesheet Management SystemThis Information Management System was designed to manage MHHC Timesheet information tracking and processing requirements. This system is used for tracking Employees and Employee Timesheets and Reporting.Access 2000
2002+Mission Terminal Inc.Mission Terminal - Administered Car Information Management SystemThe Administered Car Management System was designed to manage the Missions administered Grain Cars. This system imports Grain Car Unload and Shipment/Adjustment information from the Canadian Grain Commissions GIS (Grain Information System). This system administers Car Releases and Grain Receipts and grain inventory by providing automatic commodity pricing, rail/station rates, freight adjustment factors, premiums, cleaning, admin, etc. , several CWB required reports, Inventory Management, several customized information management reports.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-2004HEPP Manitoba (Health Employees Pension Plan)HEPP T4AP Electronic FilingImported files from several sources, processed and cleaned information and creates export files for T4AP Electronic Filing.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-2008ADM Milling CoCommodity 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-2000Schweitzer-Mauduit Canada, Inc.Straw Production SystemThis Software was developed for Swietzer Mauduit's NT/WIN 95 network to track and report on Flax Straw Production, Inventory and Shipping information. This system is integrated with the Straw Payable System and Straw Purchasing system.Access 97/VBA
1999-2000Schweitzer-Mauduit Canada, Inc.Fuel Management SystemThis Software was designed to manage, track and report on SM's Bulk Fuel, Credit Fuel, and Key Lock Fuel information. This system was an upgrade to an existing dBase IV system.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
1999-2000United Food and Commercial Workers UnionFile Management SystemThis Software was developed to track and cross-reference On Site and Off Site Files, Grievances, Arbitrations and Supplies. It is a complete search and reporting system. This system replaced an existing Clipper database system.Access 97/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
1998-2008ADM Milling CoPlant 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
1998-1999Schweitzer-Mauduit Canada, Inc.Straw Purchase StatisticsThis Software was developed for Swietzer Mauduit's NT/WIN 95 network to track Flax Straw field bookings, supervisor and buyer quantities and quotas, vendors, field purchases, straw purchases and loss reporting. This system was an upgrade to an existing dBase V system.Access 97/VBA
1998-1999Schweitzer-Mauduit Canada, Inc.Straw Accounts Management SystemThis Software was developed for Swietzer Mauduit's NT/WIN 95 network to manage the Accounts Receivable and Accounts Payable information for this company's flax straw processing activities. This system was an upgrade to an existing dBase V system.Access 97/VBA
1998+Interprovincial Co-Operative Ltd.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/DOS
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
1992-2000James Richardson And Sons, LimitedEmployee Benefit Statement Reporting SystemThis Clipper Database Benefit Statement Reporting System imports HR data from three different information systems, processes it, cleans it and generates the Employee Benefit Statements on pre-printed forms in French and English.Clipper
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
1989-1993James Richardson And Sons, LimitedCheque Imaging SystemThis Clipper Network Database Cheque Image Archive and Reporting System was used to view archived text images of employee payroll cheques on the Local Area Network.Clipper
1988-1996Manitoba Telephone SystemAutoquoteThis Network Clipper Database Application was designed for Manitoba Telephone Systems Head Office and Regional Offices to price all non-engineered business telephone systems. This Business Phone System Quotation System simplified the creation of management of quotations by integrating several line and service rate tables, multi-tiered product and component pricing tables, system configuration data and other setup parameters into a series of point and shoot data entry screens. This program underwent several upgrades and modifications to optimize it for the WAN and integrate it with their main pricing system.Clipper
 
Expert Systems Inc. 200-32 Balmoral St. Winnipeg, Manitoba, R3C 1X4 Phone: 1-204-786-1069 Email: expert@expertsystems.com