1. Microsoft Excel :
Microsoft Excel is used to displays the data in horizontal and vertical rows. The data are usually stored in the cells. We have an option of formulas in the Excel that can be used for data and its place of storage.
- You can even add any charts, graphics, etc. to make it more presentable.
- Excel locks the whole spreadsheet once it is accessed.
- Making other people unable to edit other entries or even to add new ones.
- An Excel document is referred to as a workbook and each of these workbooks must contain atleast one worksheet.
2. Microsoft Access :
Microsoft Access is a database program, it uses unique ID numbers and an editable list of data to store details on a large amount of items, i.e. you could use this program to store.
- Access is designed to have multiple users working in the same DB files along with the various safety precautions items to help protect the data such as record level locking.
- The database created in Access is saved with a .mdb extension.
- Data is stored in the tables.
- Each field of a table can be associated with certain constraints like only allowing an alphanumeric value.
- Like any other relational database, it works on the principles of tables, fields and relationships. It supports different kinds of numbers, dates, texts, etc.
Difference between Excel and Access :
