Exceltoaccess

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

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.

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