Office Development
and Expert Services
Excel
Access
Security
Life Cycle Services
Projects
Contact Us
Employment
Customers |
Customer examples....
Raytheon, Aurora, CO
�
Supported
Raytheon GPS/OCX Satellite contract; providing VBA and Excel
development.
Developed several expert Excel tools which
included VBA coding, advanced Excel features, and advanced functions.
Examples: An Excel tool which extracted
data from Eroom, modified the data, extracted multiple metrics outputs
for personnel resources, and provided decision flags.
An automation from within MS Project (Excel
VBA in Project VBA) outputting a formatted Excel report, providing task
information for all workers.
An Excel Peer Review tool modification
which expanded functionality and corrected current development issues.
Two tools which combined accounting and
project data sources for managerial comparison; one in Excel and the
other in Access; both utilizing advanced features and VBA.
Prototype work on a dashboard system with
multi-layer metrics outputs derived from a variety of data sources
utilizing Excel/VBA.
Kiewitt
�
Apps7 was selected
to support
an SAP conversion for a large construction firm. Developments
included a data validation tool utilizing Microsoft Access, as well as
several conversion tools using Microsoft Excel and VBA.
Apps7 also administered a multi-user Task
Database developed in Access and delivered via virtual machine.
State of Colorado, Alcohol and Drug Abuse Division (ADAD) Denver, CO
�
Apps7 developed the primary searchable direcory for ADAD agencies which
replaced
a 100+ page paper-based directory
of
HDH Consulting � Apps7 developed data gathering forms via the Web using .Net and utilizing a Microsoft Access database, for a political candidate campaign. The technologies were successfully developed and implemented in a highly-iterative change environment.
NSO
Press Inc. ,
�
Apps7 was brought in to get a Microsoft
Access (ver. 2003, 2007) tool working that was highly code dependant,
appropriately replaced code with queries and new code (VBA).
The tool collects data from an Excel order sheet on a daily
basis, and also collects information from PDF files for order reports.
The tool has been modified into another product for a similar
customer.
�
Apps7 also developed an alternate companion to the tool is a developed
Excel Add-in which conditions the data prior to importing to Access. Headington Oil Co., Lakewood, CO
�
Apps7 developed
two tools from ground up
for this oil company. One tool was for well production measurements of over 100 wells,
replacing three manual systems.
The other tool was a prototype for rig management.
Both tools involved highly-efficient entry and reporting using
Microsoft Access
(ver. 2003, 2007),
with in-program VBA outputs to PDF, and formatted Excel
(ver. 2003, 2007)
reports,
including graphs.
Synergistic Software Solutions
,
Remote contract.
�
Apps7 developed the
Access portion of the
Telecommunications and Conferencing Company, Thornton, CO
�
Re-developing a configurator tool built in Excel for the company�s
worldwide sales force.
The tool utilizes Excel user forms in place
of spreadsheet operations and provides a user friendly interface,
replacing the need for engineering involvement for sales quoting for the
company�s primary product line. Online Commodity Company, Amarillo, TX
Remote contract.
�
Developed a
tool from ground up which converts major organization operations
formerly handled by a large Excel workbook, into Access.
Providing documentation, training and other
implementation services.
Majority of work is performed offsite using
email, cloud and collaboration software. Land Company, Daytona Beach, FL
Remote contract.
�
Re-created
legacy tool originally built in Paradox, using Access 2013.
The tool was built to record two major sets
of data and several minor sets.
Specific automations, reports and forms
were re-created.
Modern conveniences were added, including
�click-out� to Web County and Google maps.
Documentation is being provided in a
40-page document covering user and developer needs, as well as an
operational video.
Majority of work is performed offsite using
email, cloud and collaboration software. Travel Agency, Denver Area, CO
�
Repaired
Sales Management tool (previously developed) issue; protecting critical
data and restoring tool to normal operation.
Consulted on potential move tool into cloud
environment. Majority
of work was performed offsite using email, cloud and collaboration
software. Major Colorado Healthcare Conglomerate, Denver Area, CO
�
Administered
and maintained 17 business critical automations built in VB.Net, Excel
and Access including T-SQL interface for the accounts receivable
division of Finance.
Provided development modifications and
upgrades as needed.
Evaluated and provided recommendation for
reverse engineering VB.Net into Excel/VBA, and built prototype.
Also, consulted on utilizing other
technologies to manage data and reporting requirements.
|
Registered Member, Microsoft Partner
� Apps7 Corporation
Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,
Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,Excel Developer, Access Developer, Excel Programmer, Access Programmer, Excel Consultant, Access Consultant, Excel Programming, Access Programming, Excel Lakewood CO, Access Lakewood CO, Excel Denver CO, Access Denver CO,