Posts

Data Normalisation, Primary Key and Foreign Key

Image
What is Data Normalization? Wikipedia defines data normalization as " T he process of restructuring a  relational database  in accordance with a series of so-called  normal forms  in order to reduce  data redundancy  and improve  data integrity " Normalization is nothing but a process of identifying and arranging data which will help to avoid storing duplicate data and at the same time not missing any data that is needed for processing or analysis. Too difficult to understand by just reading the above statements. Lets understand the meaning and process of normalization by looking at some examples from various fields. Data Normalization process of a book Library:  Every Library has a list of books and a list of its members who borrow a single book or multiple books at any given point of time or no book has been borrowed by the member from the library. Unfortunately, this library cannot afford to buy any library software for management. Cur...
Post a Comment
Read more

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...
Post a Comment
Read more

Understanding the basics of RDBMS/MS Access

RDBMS stands for Relational Database Management System where in data is stored in various tables and one or more tables are related to each other using a common field. In excel or spreadsheet no two tables can be related logically either in the same sheet or in multiple sheets. In RDBMS data is stored structurally which means the columns are defined the respective data pertaining to that column is stored in the defined column. The columns are defined and do not change. There is no limitation on the number of tables that can  be created and each table has infinite rows that can store data (excel has a limitation of rows). Data is populated in the table by using a GUI (Graphical User Interface) or by importing from other database or a spreadsheet (Excel) or a text file which has structured data or a  Csv (Comma separated values) file.
Post a Comment
Read more

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 Manage...
Post a Comment
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.
Post a Comment
Read more