Re:Stop Using Excel, Finance Chiefs Tell Staffs
by phkahler on Wednesday November 22, 2017 @10:21AM
(#15757390)
MS access is often a way better tool for what people do. The problem is that it requires a bit more work up front, a little more abstraction, and usually some programming. Having said that, most companies have people in IT that can help out something like that together for people but that's not their job.
[ Parent
| on HN ]
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by toyg on Wednesday November 22, 2017 @10:22AM
(#15757409)
> it requires a bit more work up front
Because of this "bit more work", it's also much less flexible in the long run.
Excel is not a great database, but it's a highly flexible one.
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by fjsolwmv on Wednesday November 22, 2017 @11:19AM
(#15757967)
Does access have a spreadsheet view for bulk editing?
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by tinus_hn on Wednesday November 22, 2017 @11:56AM
(#15758296)
Yes, it’s called the datasheet view.
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by TakerofVita on Wednesday November 22, 2017 @05:24PM
(#15761209)
Access does have a datasheet view, but it is _much_ less powerful than Excel e.g. copy/paste multiple cells, fill down, and it is SLOWER.
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by phkahler on Wednesday November 22, 2017 @06:44PM
(#15761694)
In a database you don't "fill down". You build a query to generate what you want (enter the expressions once) and click on the "data sheet" view for the query. It's different, but the simplicity of referencing $A$5 in excel and using whatever cells you want as inputs is way simpler than any way you might take user inputs in Access.