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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
C Sharp Keywords
keywords, sometimes called reserved words, are predefined words that have special meaning to the compiler. Keywords cannot be used by the programmer as identifiers such as variable, method, or class names. A programmer must use keywords only in designated locations in the code. More ...
