Share via

Microsoft Access 2016 Template

Anonymous
2019-06-25T01:48:52+00:00

Looking for a templet for storing photographs.  Need 4-5 columns of data that can be searched.  The database contains a link to the photo file that meets the search criteria and the photo is displayed.

Anybody know of such a template?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-06-25T23:54:30+00:00

    I agree with what Scott said, "this shouldn't be a difficult app to create".  As for me personally, if I needed that, I would just make my own MS Access database.  However, if you were still wanting to look at an existing template, I found one that seems to have some of the features you requested.  Here is how I found this template:

    [1]  I opened my MS Access software (I am using Office 365, version 1808).

    [2]  In the "Search for online templates" window, I typed "photo", and clicked the search button.

    [3]  A Home Inventory database was returned from my search.  This database contains a link for photos, has columns that can be searched, and it also displays the photos (on the Asset Details form).

    [4]  I was also able to do the above in MS Access, Office 365, version 1905).

    If you cannot get to the Home Inventory database, I put a copy of it in my OneDrive account, at this link:

    https://1drv.ms/u/s!Aho2xuhOHKVvj79rocS1Zh1_x7fSxw?e=RAcMmg

    Here is a screen-print of the Asset Details form, with one of my sample pictures in it:

    Here is a screen-print, of the left side of the table (I cropped off the right-most fields):

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2019-06-25T21:28:11+00:00

    If such a template existed it probably would. But it should not be difficult to create those using the Form wizard.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-06-25T21:06:56+00:00

    I assumed the template would also include the date entry form and the search and display form.

    Was this answer helpful?

    0 comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2019-06-25T01:57:42+00:00

    Hi TLB, I'm an independent adviser and will try to help.

    I don't know if there is a specific template for photo catalogs, its easy to check the template lit .

    But this shouldn't be a difficult app to create.

    A single table with 4-5 fields and a text field for the link should be sufficient. You may want to create some lookup tables to standardize the data entry for the search fields.

    I would give it a try and if you need some specific help feel free to ask.

    Was this answer helpful?

    0 comments