Teju has attended:
MOS Exam course
MOS Exam course
MOS Exam course
Excel Intermediate course
Excel Advanced course
Excel as a database
Hello
1. In a situation where Excel is being used as a database, is it possible for different users to be able to enter data into the same spreadsheet at the same time. How can this be achieved?
2. At what point would you recommend moving to a database system like Access instead?
Thank you.
RE: Excel as a database
Hi Teju,
It is possible for different users to enter data into Excel 2007 using Workbook Sharing.
Select the Review tab along the Ribbon
Choose the Shareworkbook option.
In the dialogue box that will appear, under the Editing tab, tick the box “Allow changes by more than one user at the same time”.
You can then adjust the Advanced tab for Sharing a Workbook.
When you click OK, it will prompt you to save a copy of the workbook. This would need to be on a drive accessible by all of those intending to edit the document.
Access Database is automatically editable by multiple users.
The point at which you switch is determined by a number of factors.
Access is better for storage, Excel for analysing data
Access can handle larger volumes of data than Excel
Access has a better data entry setup than Excel
Access is designed for sharing data
Excel can visualise data
Access requires a different skill set to operate
If you are considering the move to Access, we would be happy to discuss this with you. We can provide tailored/on-site Access training to make your migration as easy as possible. Training will also help your company to utilise the data effectively, providing you with a better return on invest
Kind regards
Richard Bailey
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
