It's all doable, but it can be a pain.
the difficulty with this sort of stuff, is that you have to include some appropriate data in the table (or query) enteredby, amendedby, or similar - and then you have to write an interface to select and manage the data selections.
It's the same if you want a system where different users see information for selected depots, say.
You therefore have to build this selection functionality into every form/report where it is needed. It doesn't come with databases by default.