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 Your Own VBScript HTA Text Editor
Because this application is designed for instructional purposes, I didn't design it with the conventional File drop-down menu. In order to show how menu items link to the code that performs each function, I just placed all the menu selections in the main menu. 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 ...
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 ...
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 ...
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 ...
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 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 ...
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 ...
Compile C Sharp Without Visual Studio
I have never been very excited about C sharp because you have to use Visual Studio to write programs with it. I don't like to use over-complicated IDEs to write programs because the IDE is often more difficult to figure out than the programming language itself. The fact is you actually can write C sharp programs without Visual Studio. More ...
