MS Access capabilities

I am trying to make an application that will allow 4 people to update and share data in around 100 fields. Is access the best and easiest DB application to do this? Currently we are using one MS Excell file but run into a sharing issue when two or more people try to open the file on the server.

If I setup a master table in Access could I have individual users only be able to edit certain fields in the file?

Thanks and realize this is my first time using access.