In all the 4 previous posts on operators, you have seen some specific operators that can be used to perform certain specific actions. In addition to this, there are still a few additional operators provided by MS Access to assist you in your data analysis.
In this post, you’ll learn about these additional operators….
In the previous post, you have seen that if one of the value is NULL, then the output of the + operator is also NULL.
Lets consider the following example:
O = A + B
If B=NULL, then the expression “O = A + Null” will be equal to Null. But in real life, when you are adding two values and if you encounter NULL, then you want MS Access to ignore NULL value and perform the addition operation as normal i.e. you want the final output to be displayed as :
O = A + 0 i.e. O = A
Let us see how this function can be used to achieve the desired result…
Posted in Basics
Today, you’ll learn to use two very useful concatenation operators in MS Access. By definition, ‘Concatenation’ means linking of two things as in a series or chain. From MS Access standpoint, concatenation means joining/linking two strings together.
So, let’s see how you can use these operators to your benefit….
In simple English, NULL means nothing – absolutely nothing. In MS Access too, NULL means the same….no Value. NULL means absence of any value whatsoever. NULL is different from a zero Value. In fact, NULL is also different from a Zero length String (ZLS), though they appear the same visually.
The presence of NULL value indicates that maybe you have no value to add in the table, or simply the value is unknown. Furthermore, you cannot compare NULL value i.e. Comparing two NULL value will give you NULL, since by definition you have no value to compare with.
While doing any data analysis, you often encounter situations wherein you need to make use of Boolean logic. Now, Boolean logic involves operations on Truth values TRUE (1) and FALSE values (0) .
In simple words, you would be interested, at times, in knowing the output when one expression is true and(/or) second expression is also true. You can think of Boolean logic as a simple way of comparing individual inputs and expressions. In order to make those comparisons, it uses what are called as operators aka “Logical Operators”. Note that Boolean logic is a form of logic that reduces all values to either TRUE or FALSE.
In this post, you are going to learn about Logical Operators in MS Access. You will make use of logical operators to combine two expressions and return a value of “TRUE”, “FALSE”, or “NULL” depending on the Boolean value of the expression on which logical operation is being done.
In this post you’ll learn how and when to use the comparison Operator. As the name suggests, comparison operator allows you to perform comparison between two operands.
As discussed in the earlier post ‘Applying Criteria in MS Access’, you will now be using and analyzing in details the various operators that are available in MS Access. In this post you will learn the basics of arithmetic operator.