Understanding Ms excel and Ms Access

MS Excel
We all know a lot about MS Excel. But still I prefer to brief about this spread sheet program named Excel.

  • Its a powerful application used for making reports or carry out data analysis using using various tools such as Pivot tables and pivot charts. 
  • It mostly needs processed data for making effective reports or charts. 
  • It has the capability to process raw Data into meaningful data using inbuilt tools and functions. 
  • Data is either (Mostly) copy pasted or typed  in a fresh sheet for further analysis or reporting purpose. 
  • It has limited data Validations rules. 
  • Data can be filtered and sorted using inbuilt functions for a given set of conditions that are available in the data. 

Ms Access
What is MS Access?

Many of you have either heard or read about MS access as a powerful application or database tool which is more efficient and better way to manage large of amount data. 

MS Access is a Relational Database Management System (RDBMS) that is part of MS office. 
It is very much powerful as oracle and MS-Sql and open source RDBMS like MySQL, Firebird, CUBRID,MARIADB etc which are used by organizations of all sizes to develop and manage their organizational process and systems as their Back end for storing data (either raw or processed). 


Comments

Post a Comment

Popular posts from this blog

Understanding Data Types

Image
What do we mean by data type? Wikipedia defines data type as " In  computer science  and  computer programming , a  data type  or simply  type  is a classification of  data  which tells the  compiler   or  interpreter  how the programmer intends to use the data." In short data types are nothing but information that are easy to  identify either as text (words or sentence) or numbers or any other type such as boolean (Binary 0 or 1), Date/Time, Currency etc.  By segregating or classifying the data or information in one of the types we help the software or the computer/system to help us process the information efficiently and help us to achieve our desired results on the information that we have. Pasted below is the standard data types that are available in excel or any standard spreadsheet applications.  Summarized below are some of the commonly used data types in excel and access: Hope y...
Read more

Hello and Welcome to excel to access

Hello and greetings for the day. Interaction with many of my friends and personal experiences pushed me start this blog to teach data crunchers, students and many MIS generators to move them from using excel to a better and powerful tool named Ms access, which helps to automate redundant tasks and produce error free reports, data reports in an efficient way. I myself have used ms access to automate some of tasks for data analysis, report generation and to solve problems pertaining to huge data files. Through this blog I would like to teach the basics of Ms access which can be used day in day out to solve reporting, MIS reporting and data analysis. Happy reading and learning.
Read more