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.

Comments

Post a Comment

Popular posts from this blog

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...
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...
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