but ms-access is more power ful than ms-excel
Both are for different purposes
1)MS-Access has rdbms concept but ms-excel doesn't.
2)Ms-excel is used for calculation and making graphs etc but in access we don't have such a facility;
3)We have a table in access but in excel we have sheets
however it is possible to transfer data between excel and access .
Moreover ms-access has a relational concept for making relationship between tables.
Access is mainly for handling databases not for calculation.
MS Access, in fact is a database that is used to store data in the form of tables, here the data inside the table is stored in the form of columns and rows and one complete set of data is called a record. In Ms Access you can query the database and can see only your required data in the form of Reports (A printable format containing the result of query).
Now looking at MS excel, it not a database but it is something more technically known as a spreadsheet, it is a perfect software for maintaining the data on a limited scale, it should be used for small organization salary calculations, and for some research analysis comparison Ms Excel is the right software. MS Excel contains rows as columns, and the area where every row and column intersects is known as "cell". Ms Excel also provides the solution for automatic formula calculation and has features like sorting, data forms, formatting and many useful features for home and commercial inventory and accounts management.
One important different is that a well established Access program allows user to enter the same piece of data only once, and reuse the data elsewhere. Although you can use VBA and some automation features in Excel, for most users, they are doing copy and paste everywhere in order to cruch the data into the expected formats for different purposes.
Nevertheless, people choose to use Excel because it's easy and they seems that they can control everything in a spreadsheet. In view of this, Bau DB is a true database tool that's as easy to use as a spreadsheet. It bridges Access and Excel together to provide both ease and power at the same time. It's baudb.com.
Microsoft Excel and Access are Microsoft's two different application software. Both of them handle table data, but there are still many differences. Excel is a spreadsheet application program, but Access is a database program. Both are configured differently and therefore serve different purposes.
know more about advance excel click this link- Advance excel training in Chandigarh