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 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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Video - Visual Basic Express 2010 - Getting Started and the First Program
This video by SchoolFreeware shows you how to create your very first Visual Basic Express 2010 program. 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 ...
List Files and Subfolders With the VBScript FileSystemObject
This article shows you how to write a VBScript that uses the FileSystemObject to list the files and subfolders in a folder on your computer. More ...
