How to make a database with different access rights?

Question

excel

Hello. Need help choosing tools to create a database. The database will store information about people (full name, address, some contacts, etc., depending on the profession, the number of columns may vary).
There are several necessary conditions for its existence:
- work on the network 30+ users;
- convenient and quick sorting with a large amount of information (100,000 contacts), creating a selection like in Excel using filters;
- differentiation of access rights (reading, reading + writing, ideally - forming a sample for specific users);
I tried to consider the excel + access option on my own, but I didn’t have enough technical knowledge. What other options can you think of?
PS search as in Excel, for example, is more than satisfactory, but excel is very dull when working with a large amount of data and a large number of users.

Answer 1

Yes, the ideal will be the way you tried. If, for example, there is a ready-made database in excel, with the help of import it is easily driven into the process, and then in the process, connect everything with forms, without studying something, nothing will come out of the fact that there is something to have. As for the search, you can also take a selection in the same way as in Excel, by setting filters in the form beforehand.