Database for my articles

[Paula TENG]

I have some 140 MB's worth of journal articles. I need a searchable database
that shows the author, journal name, date, a brief summary, key words, as
well as the file name on my computer. I've never used access, but i'm a quick
study.

 

[Douglas J. Steele]

Arvin Meyer has a Document Management System example at
http://www.datastrat.com/DataStrat2.html that might be applicable.

 

[Paula TENG]

Thank you for the quick response. It says create tables, design tables etc.
and i guess i'm too ignorant to do that. i'd better buy an access book and
try learning it, can't run from technology any more eh?
Paula

"Douglas J. Steele":

 

[Steve]

I'll create the database for you for a small fee. Contact me if you are
interested.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Marshall, MVP]

Repeat after me; "These news groups are for FREE help, not a source of
victims"

John... Visio MVP

 

[Paula TENG]

Thank you Steve,
But if i wanted to pay for it, i wouldn't have posted a message here in the
first place.
thanks anyway
Paula

"Steve":

 

[John W. Vinson]

On Sat, 2 Jun 2007 04:07:01 -0700, Paula TENG <Paula

I have some 140 MB's worth of journal articles. I need a searchable database
that shows the author, journal name, date, a brief summary, key words, as
well as the file name on my computer. I've never used access, but i'm a quick
study.

You may want to consider OneNote - it's a very capable literature-reference
application. To reproduce its capabilities in Access would be an enormous
amount of work!

That said... you can certainly do this in Access; I'd suggest keeping the
computer-readable articles external to Access, and just have tables for
Authors, Journals, Keywords, and Articles, with additional tables for
Authorship (joined one to many to Authors and Articles) and KeywordsUsed
(joined one to many to Keywords and Articles).

John W. Vinson [MVP]