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 ...
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 ...
C Sharp Keywords
keywords, sometimes called reserved words, are predefined words that have special meaning to the compiler. Keywords cannot be used by the programmer as identifiers such as variable, method, or class names. A programmer must use keywords only in designated locations in the code. More ...
Compile C Sharp Without Visual Studio
I have never been very excited about C sharp because you have to use Visual Studio to write programs with it. I don't like to use over-complicated IDEs to write programs because the IDE is often more difficult to figure out than the programming language itself. The fact is you actually can write C sharp programs without Visual Studio. 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 ...
Visual Basic 2005 Express Reserved Words or keywords
Reserved words or keywords are words that are part of the language and therefore have special meaning in Visual Basic. The reserved words cannot be used as names for your programming elements such as variables, functions, subroutines or procedures. 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 ...
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 ...
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 ...
The Components of the Microsoft Access Database Interface
As you open a document window in Microsoft Access, toolbars, menu bars (or Ribbon Bars from version 2007) will change state and can be a little disorientating at first. In some cases, you can only be in one type of window to view a function or feature. More ...
