Business Challenge: MAC Cosmetics needed modifications and improvements to their existing Microsoft Access database that tracked their make-up artists' skill certifications. The system needed revisions across ten regional databases.

Simetra's MS Access experts conducted a thorough assessment and were able to revise their Skill Certification reports. The solution was implemented in a cost-effective and timely manner.

Key Feature & Outcome: We optimized the main form and revamped the layout formats and report parameters to correctly calculate and track the correct dates for their make-up artists' certifications. Simetra devised a cost-effective system that is now easy to maintain and update.

Business Challenge: The real estate investment firm was using Microsoft Excel to manage its entire property life cycle (Purchase, Eviction, Rehab, to Sale). After significant growth (85 active properties), the spreadsheet solution became a major roadblock due to limited single-user access and the inability to generate metrics reporting.

Solution & Technology: Simetra developed a secure SQL Server database with a Microsoft Access front-end. The system manages all investment processes, including Rehab, Listing, and Escrow. Data was successfully imported from the legacy spreadsheets.

Key Feature & Outcome: The new solution enables multiple users to access and query the portfolio simultaneously. Furthermore, Simetra used the QuickBooks SDK to link financial data directly with the Access database, allowing seamless financial data updates for each property.

Business Challenge: After successfully implementing the core SQL/Access system, the client needed to ensure their project managers could continue to input database information while offline or when experiencing connectivity interruptions at remote property sites.

Solution & Technology: Simetra developed a separate standalone rehab application and interface specifically for use in the field.

Key Feature: The solution leveraged MS SQL Merge Replication subscriptions of the Phase I database, which were published to each property manager’s mobile device. This allowed users to add property scopes and other data while offline.

Outcome: Offline changes automatically synchronize with the active database once the internet connection is reestablished. This provides guaranteed data input, stability, and ensures the central active database remains current.