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 ...
Three Main Principles of OOP (Object Oriented Programming)
Object Oriented Programming (OOP) is actually classified by three main principles: Encapsulation, Inheritance, and Polymorphism. These appear to be frightening terms but are actually fairly easy principles to grasp. More ...
Programming in Visual Basic 2010: The Very Beginner's Guide
This book is an introduction to programming using Microsoft's Visual Basic.NET 2010. It is intended for novice programmers with little or no programming experience or no experience with Visual Basic. The text emphasizes programming logic and good programming techniques with generous explanations of programming concepts written from a non-technical point of view. More ...
The Benefits of Microsoft Access Forms to Create a User Friendlier Database
Microsoft Access forms allows the use of data to be presented, managed and controlled in a user-friendly environment making Access more intuitive to use. Designing forms is critical for other users who will be responsible for the day-to-day running of a database and have very little knowledge of the structure of an Access database or its background processes. More ...
Visual Basic 2010 Textbox Based Simple Edit Program
In this example, you'll create a very simple text editor that uses the Textbox control. This example is for beginners so I'll go step-by-step through the process of developing the program. 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 ...
Easy Visual Basic Image Viewer
The easiest way to display images in Visual Basic is to use a PictureBox control. In this example, we'll use a PictureBox control to create a simple image viewer application, and we'll use an OpenFileDialog control to load an image file from disk. 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 ...
Write Your Own VBScript HTA Text Editor
Because this application is designed for instructional purposes, I didn't design it with the conventional File drop-down menu. In order to show how menu items link to the code that performs each function, I just placed all the menu selections in the main menu. More ...
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 ...
