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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
C Sharp Predefined Primitive Data Types
A data type defines how much storage a piece of data will take up, the configuration of that storage, and the meaning of the data. Predefined or primitive data types are those defined by the language. These primitive data types can be used as building blocks for user-defined data types. 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 ...
Working With Variables in C Sharp
Scope defines which parts of the program can access a variable. If a variable is declared inside a method, its scope is local to the method within which it was declared. If a variable is declared inside a class, its scope is local to the class within which it was declared. More ...
