As you learn programming you will find that repetitive code is both annoying and unsightly. Although in terms of writing the code, a simple copy-paste action will satisfy the requirement, it is still a bad way to do things. It can cause your code to become long and the chances of making a mistake in [...]
When writing a program, there are many occasions where an action needs to take place due to the triggering of an event. This requires the programming language to possess the ability to evaluate situations and take action. In programming terms, this ability is described as
Condition Testing.
Condition Testing exists in all programming, but in different forms. [...]
Loops are a common occurrence in any programming language. They are used to perform repetitive tasks to achieve an objective. Usually there are three types of loops to be found in programming languages.
Condition tested - Loops of this type repeat their task until a specified condition returns the desired result. The condition can be specified [...]
Databases are applications that are able to rapidly store and retrieve data. A relational database is a reference to how storage and organization takes place within a particular type of database. The term relational database is actually a shortened version of Relational Database Management System (RDBMS).
All data is stored in structured tables and have more [...]
Structured Query Language, known more popularly as SQL is an extremely popular non-procedural language that allows you to manipulate a relational database. In this regard, SQL can be categorized under two classes.
Firstly, it falls under the Data Manipulation Language (DML) class as it is used for retrieving and storing data. Secondly, it falls under the [...]
Knowledge of Visual Basic Application (VBA) programming can be very useful when dealing with Microsoft Access. You should keep in mind that VBA is event-driven and very good when dealing with customized user forms and dialog boxes. Do not worry if you have no experience with VBA, as it is easy to learn and perhaps [...]
JavaScript (JS) is primarily targeted at relieving the “boredom” caused by static HTML pages. JS is a dynamic language which can respond to user actions. Therefore clicking actions and placing the mouse on top of an object can be made to cause reactions.
A “behavior” is the title given to how an object will react. Behaviors [...]
Variables can are found in all programming languages. These are designed to be used to store values which can then be manipulated by the program. In a very basic way, variables can be thought of as containers of differing types. The differentiation comes with the fact that each variable has to be associated with a [...]
Getting into programming is a very interesting experience. This is because writing computer programs require you to alter the way you would normally think. Programming is all about breaking down a problem into smaller pieces and sticking to the rules. The former helps you solve the task you have at hand and the latter will [...]
Programming involves a very methodical approach to problem solving. In this process, there are rules that help maintain the order and legibility of the code. Some of these rules involve Data Types.
These data types help to segregate and limit the type of data that is held or processed by the code. For example, if you [...]
