Programming language like C,C++, Java or script like PHP, JavaScript help us to accomplish the repetitive or complex works . By this languages you can develop user friendly applications or solve some complex mathematical problems .
But you can build the application or solve the complex problems without knowing any programming languages ?! .
Each application or a complex problems is based on data .Data is stored in a database . The programming language take the data as required and with the data it perform the job it was instructed to do .
So every application has a database and programming language to solve the problem . It also have an interface that help an user to give the input of the problem and also to see the output of the same .
Now with MS Excel and MS Access you can build a complete user friendly application .MS Excel will do the problem solving and MS Access will act as the database as well as the user interface .
Everyone using a computer need to know MS Access as well as MS Excel . MS Excel is a simple application which help an user to perform various calculation and store data in a table like interface . MS Access is a database with various option to retrieve data as ‘report’, web page or table . MS Access can work simultaneously with MS Excel and can also import data from an Excel spread sheet . With MS Access you can create a complete user friendly application .
Both MS Excel and MS Access can be used to create a stand alone application without knowing much about programming language .
But you have to know to use the functions available in MS Excel , various options of MS Access like reporting, searching, pivot table etc.
If you know them well then consider :
Application database = MS Access
Application Program = MS Excel
Application Interface = MS Access Forms and Reports
Actually MS Excel will calculate the input datas and give the output . Then as MS Access can work simultaneously with Excel the data will be stored in the database . When someone want to retrieve data he can retrieve the data from the database with the help of a form, He/She can see the output as MS Access report .
Overall or in short you can develop an user friendly applications with ease . The only requirement is to know your Excel and Access well .
Mrinmoy Majumder
www.baipatra.vze.com
http://techchips.50webs.com/
