Five Common Mistakes Affecting Access Database Optimisation and Performance
Building an Access database requires some time, effort and ideally a good level of database knowledge. The assist tools Microsoft Access provides do not control some of the pitfalls most developers brush aside leading to a slow database. Here are the five common mistakes developers need to be aware of and handle accordingly. More ...
Introduction to Visual Basic
Visual Basic has been the most popular programming environment for more than twelve years. If you want to learn how to program, Visual Basic is the language for you. It is very easy to use, yet very powerful in the Windows Environment. More ...
How to Design an Access Relational Database Management System (RDBMS)
A Relational Database stores data as relations (a collection of tables with each table consisting of a set of rows and columns. A Relational Database Management System provides relational operators to manipulate the data in tabular form. This article explains step-by-step how to design an Access Relational Database Management System (RDBMS). More ...
How to Learn to Program
If you want to learn to program will be happy to know that programming is not a hard thing to start learning and will not require you to pay out huge sums of money. The only way to become an expert is much like learning the violin; the answer is practice, practice and practice some more. More ...
List Drives and Folders with the VBScript FileSystemObject
This article show you how to write a VBScript that uses the FileSystemObject to list the drives and folders on your computer. More ...
Visual Basic 2005 Express: Now Playing
Visual Basic 2005 Express is designed to make Windows programming easy for everyone. Some people want to write programs for a career. Others want to create a new product. Still others want to learn for the sheer mental exhilaration. More ...
Introduction to Visual Basic 2005 Express
Because the Visual Basic Express IDE does so much "hand holding", within minutes of installing Visual Basic Express you where able to create a real, although tiny, Windows application. Building bigger more complex applications is just more of the same. More ...
Visual Basic File Reading and Writing
The biggest problem with administering the list myself is adding and deleting email addresses from the list. Before you add an address to the list you have to make sure it's not already on the list. More ...
Six Important Points When Importing Data Into An Access Database
Asking general users to import data into an Access database without knowing too muchabout how Microsoft Access works and they will become frustrated within minutes. The most desirable way of using external data is by importing or linking data to an Access table object. Once the data has been imported or linked, you treat it like any other data table and build your queries, forms and reports. More ...
How to Utilise and Apply Access Database Normalisation Techniques
In the design of an Access database, the process of organizing data to minimize redundancy is called normalization. Normalization usually involves dividing large, badly-formed tables into smaller, well-formed tables and defining relationships between them. More ...
