Affiliate Marketing Secrets

I am new to MS Access and I was told by many that Access would be the program to use for keeping a strong database. I want to create a database where I can enter in each client and there personal information (ex: name, address, phone number, etc), and also create a file that is affiliated with each client that stores the questions & answers to the survey they each received after using our services.
Is something like this possible with MS Access?
Each client will have there own account number that can be accessed at anytime using that specific account number. The survey that each client receives has about 15 questions with 5 options to choose for an answer (ex: Strongly agree, Strongly disagree, etc). I want to be able to create this Survey file so when I receive the survey from my clients I can enter in there answers and save it according to each clients account number. The survey will be the same for all clients, but the answers will be different of course, so I want to create the survey file so all I have to do is go into the file, enter in the answers the client chose and save it according to the clients account number.
Is all this possible with MS Access or should I be using some other program?
Please help out as much as you can, I have limited time and limited resources, If I need to invest in MS Access I need to put in the request ASAP for the funding. This database will be very helpful when helping out families with children who have a disability.
I look forward to your help and advice, Thanks.