What is Access?

Microsoft Access is a relational database management system with an integrated development environment and supports (with limitations) the SQL standard. The database software uses a user interface similar to Excel Spreadsheet, but stores data in a relational database.

 

What does soXes offer with Access?

soXes has a wealth of experience in the creation, development and/or re-engineering of Microsoft Access databases. Among other things, soXes specialises in re-engineering and replacement with modern alternative Access solutions. In most cases, the existing solution is replaced by a .NET-based web application with SQL server database. The modern alternative offers a higher performance potential compared to Access and can be used in a wider range of applications.

 

Why soXes?

With soXes you gain a partner with competence and reliability. For 20 years, our company has stood for the best quality in the development, programming and outsourcing of software. With its services, soXes covers the entire life cycle of an IT development (conception, consulting, development and support). Take the first step towards the successful implementation of your project and contact us for more information.

Your direct contact:

Rolf Borkowski

Rolf Borkowski
CVO

Reference Projects Access
Sulzer
Kunde: Sulzer AG
Applikation: Sulzer
Technologie: Access, VBA, Excel

Sulzer AG is a globally active Swiss industrial group with headquarters in Winterthur. The company was founded in 1834 by Johann Jacob Sulzer as a foundry and produced cast iron, fire tips, pumps and apparatus for the textile industry. Today, the Sulzer Corporation employs around 15,000 people and generates sales of over 3 billion Swiss francs. Sulzer now consists of the core operating divisions Pumps, Rotating Machinery Services (such as generators and motors) and the Chemical Division.

To improve the project process at Sulzer Pumps, Sulzer Pumps Ltd. has commissioned soXes GmbH to create a software solution based on Access and Excel. Sulzer Pumps is the world's leading pump manufacturer with more than 20 production sites.  The most complex pipeline system in the world is based on Sulzer Pumps and transports two million barrels of crude oil daily from Canada over 13 500 km to North America.

Today, all projects at Sulzer Pumps are coordinated via the Order Progress Room, a new service developed by soXes. The Access-based application clearly displays all orders, including order number, customer name, project name, project manager and project name, thanks to filter functions. Orders can be sorted by calculated or agreed delivery date. The core function provides a list of the order and production stages, whereby it can be defined for each order whether or not the respective stage can be kept to the planned deadline and whether or not there are any delays in delivery. Based on this order status overview, reports of up to a display size of DIN A0 can be generated and thus even printed as posters. There is also an import/export interface via Excel to the Sulzer ERP systems.

Thanks to the Order Progress Room, the project process at Sulzer Pumps was made clearer and its handling optimized. The solution is used worldwide (multi-user capable). 

Hypothekenzentrum
Kunde: Hypothekenzentrum AG
Applikation: Hypothekenzentrum
Technologie: VBA, ASP.NET, SQL

HypothekenZentrum AG is an operationally independent company of the VZ Group. It specialises in the management of mortgages for private and institutional clients. Its organisation and work processes are lean and computer-supported, which minimises administrative costs and enables it to offer cost-effective financing for mortgage borrowers.

HypothekenZentrum AG is supported in handling of their core processes by a modular application. This is based on an SQL database and is a further development of an old MS Access solution. soXes ensures the maintenance and support of the complex application environment. On the other hand, soXes supports HypothekenZentrum AG in reacting to changing customer requirements by developing extensions or new modules.

Thanks to its specialist knowledge in a wide range of development environments from VBA to SQL and ASP.NET, soXes can not only guarantee the smooth operation of the existing application modules, but also provide individual further development based on the latest technologies.

Inrate SA
Kunde: Inrate SA
Applikation: Inrate SA
Technologie: ASP.NET, MS SQL, Angular, KendoUI

Inrate is an independent rating company and evaluates the environmental and social sustainability of companies, institutions and countries worldwide. These ratings are used to create investment universes and theme indices or baskets that provide asset managers and financial service providers with a basis for making decisions on how to create sustainable and financially attractive portfolios and investment products.  

In close cooperation with Inrate, soXes has designed and implemented a new web solution to create the sustainability ratings and make them available to clients for online download via web account. An MS Access database was replaced by an MS SQL database with web front-end (Angular/KendoUI). The ratings are based on a complex versioned rating model that is scalable through Inrate. The rated investment universe is regularly updated via interfaces to MSCI and Thomson Reuters. For individual clients, data feeds for their core banking system (Avaloq) can be retrieved.

Since the application went live, soXes has been providing maintenance, support and individual development within the framework of a maintenance contract.

One of the main objectives of the new application was to enable analysts to further develop the rating model without IT support. This was achieved through an administration front-end that allows the analysts to adjust the several hundred rating criteria at any time.

Furthermore, completed ratings were to be available for publication in real time.

The ratings are worked on decentrally at several locations in Switzerland and abroad in parallel, which is ideally supported by the web technology.

 

Novelis
Kunde: Novelis
Applikation: Novelis
Technologie: SQL Server with ASP.NET MVC 5, Angular JS Framework

 

Novelis is the global market leader in the field of machining aluminium into customer-specific materials. For the production of aluminium in the automotive sector, Novelis has developed an individual solution by soXes specifically for production planning, price calculation and forecasting of the aluminium volume with interface to SAP.

 

Functions:

  • Management of projects and aluminium parts
  • Forecasting of aluminium volume, unit and project price
  • Excel interface to SAP for import of effective bookings at project level, export of forecast at project level for subsequent re-import into SAP
  • CRM for recording customer contacts with Outlook connection
Relevant Topics
cloud button Cloud View
list button List View

Testimonials

 
Our dedicated soXes team helps us to successfully develop Prisma World further. A big thank you to the IT professionals. Dr. J. P. Pflüger, CEO Prisma World AG
soXes convinces us with its agility paired with broad and deep know-how for complex software developments. Markus Wiegand, CEO Wiegand AG
soXes has always managed our projects to our satisfaction. CorXL Ltd. JPD Dr. med. Jan Steffel, Senior Physician Cardiology / Rhythmology at the University Hospital Zurich
With soXes we know that we are in very good hands. Belinda Stublia, Lucullus SA
The soXes team convinces with its incredible commitment and passion. Argjent Ukshini, IT Project Manager Customer Service Electrolux Schweiz AG
soXes has shown to be a very professional partner and we value their responsiveness, quick turnarounds and enthusiastic work ethics. Patrick Brigger, Co-founder & Chairman, getAbstract
We have been working successfully with soXes for over 10 years. The professionalism and flexibility of soXes continues to convince us. Mark Rüegg, CEO CelsiusPro AG
With competence, commitment and energy, soXes opens the way to success. Cornelia Nestic, Associate Director, HypothekenZentrum AG
The cooperation with the soXes project managers of my project is markedly cooperative and open. soXes shows the flexibility and agility required for such projects. For me, this is a decisive factor for the success of the project. Dan Keller, Manager Major Projects, TUS Telekommunikation und Sicherheit
With soXes at our side, we have succeeded in breaking new ground in software technology, Bruno Schmed, Member of the Executive Board, T&N Telekom und Netzwerk AG
At soXes we get competence and professional results - at any time in a completely uncomplicated way, Simon Keel, Chief Technology Officer, Tolomeo Capital AG
soXes convinces in projects with experienced solutions and close customer contact. Roman Aebi, CEO Cenprom AG
soxes has implemented our ideas into an overall solution: professional, timely and at a fair price. Andreas Lehmann, CEO, PortaNet AG
soXes has demonstrated great expertise and commitment to the complex overall IoT solution with LoRaWAN and NFC. This, and the well structured cooperation were the basis for the simplicity that distinguishes MyPortaNet. Christoph Röthlisberger, IoT/Industry 4.0, PortaNet AG

 

Are you looking for a company that offers you effective support and consulting in the implementation and support of your software projects?


Our services cover the entire life cycle of an IT solution as well as the entire spectrum of modern software development.


From business and process analysis, IT architecture to implementation. From commissioning to support. You benefit from our specialist knowledge and our experts.

With over 150 successful development projects and more than 80 active customers, we have the experience and you have the idea.

Notice

Our website uses cookies to ensure the best possible service. By using the site, you agree to the use of cookies. You can change this in your browser settings. Privacy Policy.