السلام علیکم
Access is a database management program, while Excel is a spreadsheet application. Someone can use these programs simultaneously to track business productivity and other factors.
Excel allows users to crunch numbers, maintain lists and share data. It also allows users to export and import various types of data for manipulation and analysis.
Access has more functions, making it a more powerful and complex program. Users can manage more data, and several users can work in an Access database simultaneously. Access is ideal for managing business contacts, tracking customer orders, organizing staff jobs, managing tasks and maintaining product inventories.
Summary:
1.Excel is a spreadsheet application while Access is an RDBMS
2.Excel is usually used for paperwork while Access is used in storing information that can be accessed by a lot of people
3.Access locks data at the record level while Excel locks the entire spreadsheet
4.Most users of excel do not really know any programming while you need that to take full advantage of Access
Bookmarks