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 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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
