IntroductionJoins, in SQL, are a way of linking Recordsets together.Usually, they involve restricting which data is returned in the output Recordset, although this is...

Many Access Users fail to realize that it has a built-in Progress Meter that can display the relative completion percentage of various processes. It is fairly limited, but nonetheless, does provi...

This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one determines the available optio...

BackgroundWhenever code is used there must be a way to differentiate the actual code (which should be interpreted directly) with literal strings which ...

To use a subquery (SQ) in SQL there are two ways :Treating the SQ as a record source (like a table). Treating the SQ as a single value....

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form),...

Stored procedures are intensively used in SQL Server-based development today. The Perl language is the most useful administration language on the Unix/Linux environment. Since Web techn...