With more than 7 years of Fortune 500 database application development experience, Gjenvick Microsoft Access Developers undertakes projects from the initial concept all the way through to the implementation and support of the finished product. Offering services that include Analysis, Design, Programming and Testing, Gjenvick additionally develops individual modules and brings to a close partially completed database systems.
Focusing their efforts on providing smaller-scale custom database applications development, Gjenvick primarily uses Microsoft Access in providing extraordinary client support. Although Gjenvick clients are typically Fortune 500 companies as well as their divisions and affiliates, Gjenvick welcomes the opportunity to work with other smaller companies.
Client: Verizon Business / Georgia's Clean Air Force
Project: Emission Stations Application
Description: Microsoft Access application developed to create a daily randomized list of Emission Stations and provide a query tool to query the Emission Stations Database.
Database: Front and Back end Microsoft Access 2000
Role: Full Life-Cycle Development
Client: D. S. Waters of America, LP
Project: Product Sales Remapping System
Description: Microsoft Access application developed to pre-process periodic sales data file extracts from the four systems that were in use at DS Waters. They were Oracle, RIM, and SACS databases. Each of the systems were structured differently. This Microsoft Access based system imported the raw data, scrubbed and standardized the data and provided and output file uploaded to an Hyperion Essbase financial system.
Database: Front and Back end Microsoft Access 2000 plus Hyperion Essbase
Role: Full Life-Cycle Development
Client: Worldspan
Project: Event Tracking System -
Description: Trouble Ticket Tracking System for:
Front-End: Microsoft Access 95 and VBA
Back-End: SQL Server
Role: Programming enhancements, Maintenance
Client: Delta Air Lines, Inc.
Project: Calling Cards Tracking and Billing System
Description: Converted an Enable database to Access 2.0 with further revisions and upgrades. Later converted to Access 95. System tracks assignments of corporate calling cards; processes vendor invoices for long-distance calls made via calling card issued to employees worldwide.
Database: Front and Back end: Access 2.0/95
Role: Full Life-Cycle Development
Client: Delta Air Lines, Inc.
Project: Cellular Phone Tracking and Billing System
Description: System tracks assignments of cellular phones; processes vendor invoices for Cellular Phone service as well as long-distance calls, and provides extensive reporting options for employee assignment and usage data.
Database: Front and Back end: Access 2.0/95
Role: Full Life-Cycle Development
Client: Delta Air Lines, Inc.
Project: ACP Toll Calls Tracking and Reporting System
Description: Legacy application developed by third party in Microsoft Access 2.0. System process ACP toll call information for long-distance calls using corporate HQ phones, and provides extensive reporting capabilities for long-distance usage data.
Database: Front and Back end: Access 2.0/95
Role: Maintenance of Legacy System. Conversion and enhancements made with upgrade to Access 95
Client: Delta Air Lines, Inc.
Project: Phone Line Tracking System (ESSX)
Description: Microsoft Access 2.0 Legacy Application. Pro typed replacement system designed to track assignment of phone lines; automate verification of phone lines available; provide additional reporting capabilities one system was integrated with the communications cost control system. Prototype was not placed into production due to other priorities including Y2K remediation projects.
Database: Front and Back end: Access 2.0
Role: Developer of Prototype
Client: Delta Air Lines, Inc.
Project: Common Tables Administration and Reporting System
Description: Backbone of entire communications cost control system. Allows common table administration and additional reporting capabilities.
Database: Front and Back end: Access 2.0/95
Role: Full Life-Cycle Development
Client: Delta Air Lines, Inc.
Project: Cost Tracking System
Description: Legacy Application developed by third party consisting of Access 2.0 back end and Visual Basic front end. Reports created via Crystal Reports 4.5 and Access 2.0
Database: Microsoft Access 2.0 Back end; VB and Crystal Reports Front end / Reporting
Role: Maintenance of Legacy Application, Ad hoc Queries
Client: Delta Air Lines, Inc.
Project: Communications Vendor Invoice Payment Tracking and Reporting System
Description: System tracked invoicing and payments for communication services and provided extensive querying and reporting options.
Database: Front and Back end: Access 2.0/95
Role: Full Life-Cycle Development
Client: Delta Air Lines, Inc.
Project: Pager Tracking and Reporting System
Description: System tracks assignments of pagers, processes vendor invoices for pager services; provide extensive querying and reporting capabilities for pager assignment and usage data.
Database: Front and Back end: Access 2.0/95
Role: Full Life-Cycle Development. Scrubbing of original data
Client: Delta Air Lines, Inc.
Project: Infrastructure AFE Tracking and Reporting System
Description: System for tracking expenditures for infrastructure that provided comparison to original project cost.
Database: Front and Back end: Access 2.0
Role: Full Life-Cycle Development
Client: U. S. Nuclear Regulatory Commission
Project: Management Information and Reporting System
Description: Prototype for a comprehensive Administrative Information and Tracking System incorporating elements of human resources / security, procurement, property asset tracking, computer and peripherals inventory, software programs and inventory and phones.
Database: Front and Back end: Access 2.0
Role: Design and Prototype of comprehensive MIS
Client: Georgia-Pacific Corporation
Project: Environmental AFE Tracking and Reporting System
Description: System designed to track expenditures for environmental projects providing extensive querying and reporting options.
Database: Front and Back end: Access 2.0
Role: Full Life-Cycle Development
Client: Georgia-Pacific Corporation
Project: Solid Waste Survey Reporting System
Description: System designed to track survey results for environmental projects and provide extensive querying and reporting options.
Database: Front and Back end: Access 2.0
Role: Full Life-Cycle Development
Client: Georgia-Pacific Corporation
Project: Governmental Environmental Survey Information System
Description: System designed to track survey results for environmental projects including governmental reporting requirements.
Database: Front and Back end: Access 2.0
Role: Full Life-Cycle Development
Client: Georgia-Pacific Corporation
Project: Environmental Vendor Accounts Payable Tracking System
Description: Designed to track invoices and payments for an environmental services vendor including related project information.
Database: Front and Back end: Access 2.0
Role: Full Life-Cycle Development
Client: Georgia-Pacific Corporation
Project: Facility Information Management System
Description: Designed to integrate information on environmental facilities using OLE technology to present documents in Microsoft Project and Word.
Database and Software: Access 2.0 / Project 4.0 / Word 6.0+
Role: Full Life-Cycle Development
