Apps7
 Office Development and Expert Services           Excel       Access
 
                          
Security Life Cycle Services Projects Contact Us Employment


Customers





Customer examples....                                                                                          Pricing

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 Colorado treatment providers and institution  -- developed using MS Front Page, linked to a full MS Excel (ver. 2000) automation of listings, using expert design, and VBA/macros.  Work included Front Page customization using JavaScript and HTML coding. Tool operations were variously designed for multi-browser use.  We also developed, normalized and converted two MS Access  (ver. 2000)  databases into fully-developed tools utilizing ADO, and ADOX commands for transfer and management of SQL Server tables. Apps7 implemented full database security for HIPAA standards, utilizing a 100-step process for MS Access data protection.  We provided daily deployment of security and user interface utilizing VB6.

 

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. , Denver, CO                                                  

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  , Minneapolis, MN 

Remote contract.  Apps7 developed the Access portion of the MAS 500 Production Management Extensions for Light Manufacturing tool, utilizing an Microsoft Access adp database front end to MAS500 (Sage MAS 500 ERP system based on Microsoft SQL Server, Visual Basic and Microsoft Office) .  This tool allows production managers to perform various automation tasks; among them to drill down to SQL records, release production line items and run MRP updates.  A work center screen provides production stage coding and time sequence automations for line items, brings up a standard MAS 500 entry form from within Access, in addition to other automation visual conveniences.   

 

Other project examples:

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,