Algis started working with Microsoft SQL Server when it was launched onto the PC platform in 1988, and began to learn Microsoft Access even before it was released, towards the end of 1992. Since then he’s delivered hundreds of solutions using these two Microsoft Database products and many others.
Here is a quick summary of the typical kinds of help he’s been able to provide to his customers in the UK and Ireland before 2003 and in Australia since.
In a nutshell, the service Algis offers is to build any new database solution for you from scratch, improve any existing database application you have, fix any problems it may experience and/or teach you or your staff to do some of these things for yourselves.
Algis is a very experience database developer who has applied database technology to scores of problem categories from simple tracking of contacts to storing 3D morphometric data from Computer Tomography scans of skeletal images. Whether you have no current data at all, or have some, for example in Microsoft Excel, that you want to use to build a database from, Algis can design a properly normalised database for it and then, on top of those tables, build a database solution with queries, data entry screens, reports and VBA code to maintain and process the data.
The simplest solution is a standalone Microsoft Access database. If you are a one-man band, a small business or have a very small IT department, this might be all you need or want. Even a single file Access database is multi-user but works best for single user systems. The next step up from here is a split Access database solution which is ideal for multi-user systems where new versions can be worked on whilst users currently use the previous version.
If you need your database to be secure, have on-line back-up capabilities or need it to be very scalable, perhaps across the internet, then the best option is to use Microsoft SQL Server as the database storage engine. Developing the database in Microsoft Access allows an easily scalable progression, from the simplest solution, through to the most complex and Algis has experience moving to/from each of these levels.
Improve or Fix
Nothing is perfect and every database system can be improved. If you have an Access or SQL Server database, Algis offers a free, no obligation, audit to see how it might be improved. Whether it is improving end-user efficiency by making the system more user-friendly, improving query performance, or enhancing the database through structural changes, Algis has found that every database has scope for improvement somewhere.
Algis is happy to work with databases that have been built previously by other developers and will always attempt to modify what is already there rather than start from scratch. Access and SQL Server together can pretty much solve any database problem and so Algis is confident he can solve any such existing problems you might have.
Even if you are happy with your current database, there are likely to be improvements that can be made such as these common ones…
- Improving usability and efficiency of data entry. Most forms can be tweaked to make data entry easier. Shortcuts can be built in to save the user time whilst typing and code snippets can be built in with Access’ rich form event model to make data entry smarter.
- Backup-Up Frequency. How much data are you prepared to lose if your computer dies or gets stolen one day? If you store your data in Access you could lose a day’s work even if you back up religiously every night. Upsizing to SQL Server provides several options for far safer backup strategies, of which surprisingly few companies that use SQL Server seem to take advantage of.
- Security. If you have an Access 2007+ database you are running with very little (if any) security. Switching the data to SQL Server provides the opportunity to lock down your data at a high level of granularity. Even the most sophisticated SQL Server security models can usually be improved.
- Performance. Almost every database can be speeded up. To find a record to edit should never take more than a second and even the largest, most complex reports can be optimised using Microsoft SQL Server’s impressively designed database ecosystem, such as Analysis Services together with Integration Services.
All of Algis’ solutions are open to modification by you or your staff. He never locks down his code to force you to return to him for changes. His view is that every company or organisation should employ smart people who “own” their data and applications and are capable, at least to some degree, to make decisions to support it. Many companies are moving down the path of buying “off-the-shelves” solutions to cut costs and take away the burden of application maintenance from their staff but, although there are some advantages to this approach, the down-side is that it takes database decision-making away from the company and towards 3rd party companies whose interests might not be the same as yours. If you do not even have full control of your database, it begs the question: what intellectual property do you own?
To help you and your staff leverage the best value out of any solutions developed, Algis can put together bespoke informal, or formal training solutions, either for one-on-one situations or large classrooms. He is a qualified teacher and has taught thousands of delegates database skills over the past 30 years or so.
To get a free, no-obligation quote, call 0420-312102 or email algis@Kuliukas.com .