*Note: This post is culled from an earlier post at one of my other blogs. Also note that this is targeted towards people with at ...

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),...

Views are like snapshots of queries. You can save any query as a view, even complex queries with joins and subqueries, and MySQL will save the results of that query in a format that can be search...

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...

MySQL has become one of the most popular databases for Web applications. The database is well suited for common Web-related tasks like content management, and for implementing Web features like dis...