Recently, I had requested a big size of sales/inventory data from one of our internal team. While the data was available at a reasonable level of detail, it was too big to come in one spreadsheet. So, the concerned data operator gave me the data in multiple spreadsheets (MS Excel) with each spreadsheet of significant file size running into 100s of MBs. When I went through the data, I realised I might have to add some helper columns to add some more details – but doing so in each and every spreadsheet was going to be too time consuming. So, I started thinking of importing these multiple files into a single table of MS Access, then run queries as per my needs.
In this post, you’ll learn about this in-built Macro function in MS Access to import data known as “ImportExportSpreadsheet”.
In this post, you’ll learn to solve a specific query raised by one of our reader. The query is as follows:
Lets see how to solve this..
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….
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….
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.