
Bruce U. answered 07/15/19
Microsoft Access - 25 years of corporate world experience
Yes! Often times small companies begin storing information in Excel spreadsheets. When they make changes to their data, they may create a new Excel copy. After dozens of changes, this can create confusion as to which spreadsheet contains the latest data. Microsoft Access can eliminate this confusion by storing the database in one central location that users can share. The data can be exported to Excel instantly by clicking a button. Having a plan to backup the database often is another step to insure the safety of the data and to have the ability to restore a database from a previous day if needed.