Databases can be talked to with "Structured Query Language" (SQL). It's a language made up specifically for asking questions of databases, and it's very effective for finding things out quickly. Any application we write will use SQL to access the database behind the scenes.

Sometimes, though, you need an answer immediately, and SQL can come to the rescue. For example- you want to know how many yellow widgets you made last year, you could ask a simple SQL question and get the answer.

There are lots of references to how to use SQL- if you look at some you'll see how flexible and powerful it is.

We provide a form, the Ad-Hoc Query Tool, that allows you to use multiple queries to get all sorts of data, if you want to. Some queries you'll only ever use once, some you might use regularly, it's down to how you use the system.

The Kernel includes the ability to save all the database information to an external file for those with security permissions. That file can be saved as a backup, or transmitted by File Transfer Protocol (FTP) to allow the development team to add new features to your system.

We don't normally allow clients to re-import their own data for security reasons.

A "Skin" is a purely visual effect that can be applied to make your forms look different. In an age of uniform and drab applications, skinning has proven very popular with users!

 

The Kernel comes with a menu system that is configured to show all the forms that are part of your application. When a new form is added, if it needed to be on a menu, it gets added to that menu at startup, subject to the user having the necessary security permissions to see it!

We default to providing Maintenance Forms for all the different database tables in your system.

We will also normally provide a bunch of Reports for systems so that you can  see and work with your data.