Five Reasons Why You Should Consider Splitting a Microsoft Access Database
In the development and design mode, your Access database runs perfectly. But when you deploy the database, end-users complain that it's slow or it fails to respond. When you have concurrent users accessing your database, you may need to split an Access database and the following five reasons explain why. 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 ...
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 ...
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 ...
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 ...
Getting Started With Microsoft Access 2019
Microsoft Access database application has always been a powerful program and the latest version, Access 2019, no different. But all that power makes Access a difficult application to learn on your own. 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 ...
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 ...
Reading and Writing Files with the VBScript FileSystemObject
The example code in this article uses the VBScript FileSystemObject and TextStream Object to read a text file and write a new text file, reformatting the text into lines a maximum of 90 characters long, except when that would break a word, then it extends the line length to include the entire word. 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 ...
