4 ms·
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 p
by phkahler 9y ago
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.
- toyg 9y ago> 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.
- deleted 9y ago[deleted]
- fjsolwmv 9y agoDoes access have a spreadsheet view for bulk editing?
- tinus_hn 9y agoYes, it’s called the datasheet view.
- TakerofVita 9y agoAccess 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.
- phkahler 9y agoIn 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.