Using Access ????

  • Thread starter Thread starter L.
  • Start date Start date
L

L.

Have little knowledge of Access so before I go through a learning curve have
a comment on what we are trying to do and a couple of questions.

Our Historical Society has started a project of clipping old newspaper
articles(~1200) and will be running hard copies along with scanning(.pdf)
the articles into a data base of some kind.
The result we're looking for is each scanned article we can give it a few
key search words so we can find article and e-mail, copy, etc. and send out
requests.

We also have several hundred photos(.jpg) we'd like to do the same with.

Before I/we go too far, can Access do this?
Is there something else that may work better and/or easier?

suggestion's' please,

thanks
 
L,

In a nutshell...

L. said:
Before I/we go too far, can Access do this?
Yes.

Is there something else that may work better and/or easier?
Click to expand...

Not that I know of.
 
Access certainly could do this; however, there will be a learning curve.

Have you looked into relevant publications; talked to libraries, or
discussed this with other historical societies? There may well already be a
commercial or even shareware program out there which would meet your needs.
 
We have sent e-mails to several Historical Societies and the state of
Missouri's Historical Society asking that ???
Awaiting answers. Will check with our local libary also, thanks.

If we stay with Access, any good book's' you can recommend? I have Office
2k for Dummies.
Also notice Access has a few templates.

Thanks for your input.
 
I live just across the Mississippi River form STL.

I highly recommend reading "Database Design for Mere Mortals" by Hernandez
before proceeding any further on this database. It's not an "Access" book.
Rather it's a database fundamentals book written for beginners.
 
Thanks.
We're out in O'Fallon, MO
Just visited O'Fallon, IL HS last week.

Been looking through the help menu for Access. Sure is different than Word,
Excel.... :)
 
Thanks.
We're out in O'Fallon, MO
Just visited O'Fallon, IL HS last week.

Been looking through the help menu for Access. Sure is different than Word,
Excel.... :)
Click to expand...

VERY VERY different, and probably a steeper learning curve.

Hernandez' book is excellent; there are many others, some more specific to
Access development. Check out the resources at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]
 
There are 2 sample databases on my website that might solve about 75% of you
requirements:

http://www.datastrat.com/Download/DocMgr_2K.zip

will build and store the paths to any document written in Word, Excel, or a
text file in a table that it creates. It would take only an hours or so to
change and test that to include PDFs or replace those filetypes.

http://www.datastrat.com/Download/Picture2K.zip

will build and store the paths to any photo in a table that it creates.
 
again, thanks.

John W. Vinson said:
VERY VERY different, and probably a steeper learning curve.

Hernandez' book is excellent; there are many others, some more specific to
Access development. Check out the resources at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]
Click to expand...
 
L,

Yep, it's different from Word and Excel. And then Word and Excel
themselves are pretty different from each other.

And then, Access 2007 is pretty different from earlier versions. Given
what you want, and some of the newly introduced functionality for images
and attachments, I would say there would be a good case for Access 2007.
Bear this in mind when looking at books and other Access resources.
 
Back
Top