I have just started scratching the surface of Access, and before I get into it and start learning how to use the program, I want to check with you if Access is a good option for the project I'm doing.
So I'm creating a database where there are profiles with certain information. There should be some categories with just one or two words and some with several sentences and paragraphs of text. And most importantly: there will be several photos for each profile, that n.B. vary in resolution.
When profiles are made, I want to be make a selection of them (based on certain criteria in different categories) or all of them, and gather them in one single document, that shows name and some text of each profile, and most importantly photos. The important thing here is that the document will look good. Every profile should be inside a square where every profile has the same size, and automatically fit so that for example it exactly fits X times Y number of profiles per page, and the photos shown for each profile in this document must also be the same size - even when the image files have different resolutions.
So my question is, for the description above of what I am creating - is Access a program that is good for me to use for this?
And if so, will everything I described be easy and straightforward to do in it?