pop Posted February 25, 2014 Share #21 Posted February 25, 2014 Advertisement (gone after registration) Pick lists, aka drop down menus, are useful to limit data entry to prescribed options, in Access they are done using a form for data entry, and the option for a field is limited to a list in a separate table. I haven't tried such a thing with Open office yet! Gerry In Access, you also can provide a list of values which are to appear in the drop down list. I think you can even declare the query or the list of values in the properties of the database field, so that the drop down is shown in the table views as well. Sorry if I'm a bit vague on details as it's been a few years since I last did anything of that sort. The implementation of "Combination Fields" (?) in OpenOffice appears to be broken if it's not just outright poorly designed. In any event, I have not been able to have it do anything useful at all. That's where Access really shines, I think. It's the only software by Microsoft I've ever bought in all my life, with the exception of the software embedded in the PCs I've bought, of course. Link to post Share on other sites More sharing options...
Advertisement Posted February 25, 2014 Posted February 25, 2014 Hi pop, Take a look here 35mm slide database software?. I'm sure you'll find what you were looking for!
thebarnman Posted February 27, 2014 Author Share #22 Posted February 27, 2014 Here, at least to me is the quick and easy way to do it. This is what sold me to Access. Link to post Share on other sites More sharing options...
rolfe_tessem Posted March 6, 2014 Share #23 Posted March 6, 2014 I believe this is what Agave was designed for, although it can also be used with digital images. Agave Stock Photography Solution Link to post Share on other sites More sharing options...
thebarnman Posted March 7, 2014 Author Share #24 Posted March 7, 2014 I believe this is what Agave was designed for, although it can also be used with digital images. Agave Stock Photography Solution That's not bad at all. I like the look of the layout and there seems to be plenty of space for all the information and/or notes. And, it's about the same price I spent on Access 2013. I could put attachments within Access, but it does not work in the same way (probably not as well) as Agave for the purposes of a image database. I guess it doesn't matter since I don't have thumbnails of all those transparencies and negatives. Moving on, I've already made a choice of Access for transparencies, negatives and photos. However if and when I start with digital photography, now I'm starting to think either Agave or Lightroom would be the one to use since there would be thumbnails associated with each digital image. Now my question is changing a little bit. For a digital photography database, what would be better Lightroom or Agave? Link to post Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.