Simple Access functionality

lexfast 

Short Answer: Yes, Access is a good choice for applications of this sort.

Longer Answer: You can build a rudimentary relational database application with your current knowledge level and experience (apparently very limited). However, it will require a good deal more learning on your part to be able to EFFECTIVELY create such a relational database application. If you value your time at, say £20 an hour, you're talking about 100 hours of your time as the rough cost-based comparison. I think, again, given the question and your apparent level of current experience and knowledge, 100 hours is a conservative estimate of how long it will take you to do this EFFECTIVELY.

Of course, your time may be more or less valuable than the hypothetical number I posed. And you'll have to make the decision accordingly. In the end, though, I think your most profitable approach would be to hire a competent, experienced Access developer to work with you and build it for you, or to pay the license cost for the bespoke application.