I get some of it, but not all of it. I still get hung up on the image files.

"Don't let them promote you, don't let them transfer you, don't let them do anything that takes you off the bridge of that ship, because while you're there, you can make a difference".

James T. Kirk, Star Trek Generations

David, that mockup is a reasonable goal for an Access form. You already have the basic image database working, so I would build on that rather than start over. Separate getting the photos to display reliably from making the form look like the mockup.

Start with just a few photos. Keep the image files in a stable folder outside the database, store each full path and filename in a Short Text field, and set an image control's Control Source to that field. My Images video demonstrates that part. The free video covers displaying the image; the Extended Cut adds a browse button for choosing the file.

For albums, if each photo belongs to one album, use an AlbumT and put its AlbumID in PhotoT. If a photo can belong to several albums, that needs a junction table instead. Once the photo display works, add the album selector, then the search options and buttons. Leave the colors and layout until last. One working piece at a time.