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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 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 ...
How to Navigate the Access 2019 Opening Workspace
If you're upgrading to Access (or Office) 2019 from the 2013 or 2016 interface, you'll find it looks very familiar ? and you'll find much of it to be the same as what you're accustomed to. More ...
Write Visual Basic Programs Without Visual Studio
It was a pleasure to develop Windows Applications with Visual Basic 6. But Microsoft has abandoned Visual Basic 6 for the bloated, over-complicated Visual Studio. But you can still put your knowledge to work and develop VBScript applications with the method described in this article. More ...
