Technical articles

What are databases and what are their benefits?

Microsoft Access query optimisation

Inner and outer joins in SQL

Self joins in SQL statements

Secure Microsoft Access database development

Case studies

Business Search Wizard Case Study 2007

We have implemented a flexible querying tool for a client to help them search and retrieve their business data. This solution integrates the Microsoft SQL Server Reporting Services Web Service with .NET Windows Forms to provide a flexible and intuitive search, sort and export system for their data.

If your business needs a flexible querying tool, please read our case study for more information.

Microsoft SQL Server Reporting Services Case Study 2006

Advent IT have implemented a reporting solution for Momenta to help them manage the DTI's Knowledge Transfer Partnership (KTP) Programme. This solution integrates Microsoft SQL Server Reporting Services with SoftArtisans OfficeWriter to provide a powerful, centralised reporting and mail merge system.

Please read the case study on the Microsoft site for more information.