Db template that can handle making book indices?

[StargateFan]

Does anyone know if there is a template that can be used to create
printed book indices? The indices are those pages usually found at
the back of books that allow you to find information in any book
quickly and easily.

The difficulty is that some books, as an example even cookbooks, don't
have a comprehensive enough index so it would be nice to create one's
own esp. for books we use quite frequently where we'd like to create a
booklet we tuck into the book so that when we go to do research, we
can find anything.

As an example, I'd like to use a cookbook because it's easy to
illustrate.

You find that the index might list all the recipes, say, but if you're
looking for all the recipes that use lamb, for example, you're out of
luck.

It would be nice to enter an index title and a page number but also to
list all relevant keywords and to have the database then print out a
report that not only lists the data by title but then sorts the
keywords into an alpha list separated also into an index but that
includes the recipe name and page number.

Any book can also be required to have some sort of sub-sorting system
incorporated in with the titles.

Anyone know of a good template the already does this or one that at
least can be very easily converted into such a format? thx.

 

[Steve]

Hello,

I provide help with Access, Excel and Word applications. I can create a
template for you for a nominal fee. You can keep the cost at a minimum by
doing all the cosmetics yourself. If you are interested, contact me.

Steve
(e-mail address removed)

 

[Gina Whipp]

StargateFan,

I do not know of a database that does this BUT here is site that has alot of
FREE sample databases. You may be able to find something there that can be
easily modified to do what you want...

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=3

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Does anyone know if there is a template that can be used to create
printed book indices? The indices are those pages usually found at
the back of books that allow you to find information in any book
quickly and easily.

The difficulty is that some books, as an example even cookbooks, don't
have a comprehensive enough index so it would be nice to create one's
own esp. for books we use quite frequently where we'd like to create a
booklet we tuck into the book so that when we go to do research, we
can find anything.

As an example, I'd like to use a cookbook because it's easy to
illustrate.

You find that the index might list all the recipes, say, but if you're
looking for all the recipes that use lamb, for example, you're out of
luck.

It would be nice to enter an index title and a page number but also to
list all relevant keywords and to have the database then print out a
report that not only lists the data by title but then sorts the
keywords into an alpha list separated also into an index but that
includes the recipe name and page number.

Any book can also be required to have some sort of sub-sorting system
incorporated in with the titles.

Anyone know of a good template the already does this or one that at
least can be very easily converted into such a format? thx.

 

[John... Visio MVP]

I provide help with Access, Excel and Word applications. I can create a
template for you for a nominal fee. You can keep the cost at a minimum by
doing all the cosmetics yourself. If you are interested, contact me.

Steve

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[StargateFan]

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

Thank you for this. I was a bit nonplussed at the message so glad to
know my instincts were right on track! D

 

[StargateFan]

StargateFan,

I do not know of a database that does this BUT here is site that has alot of
FREE sample databases. You may be able to find something there that can be
easily modified to do what you want...

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=3

Thank you for this link. I will look to see what is available.

I guess the only thing that I don't know of really is if there is a
feature in Access that can take a a record with its box of keywords
and create a complete index of all the terms in the record itself
including those keywords.

Here's an example of this difficult chore - I'd enter these two
records with their keywords, as an example of the simplicity of the
entry:

Big Bang Nucleosynthesis - pg. 5
Keywords: baryogenesis, hydrogen, primordial nucleosynthesis

Planetary Nebula - pg. 1
Keywords: Milky Way Galaxy, nucleosynthesis

----------------------------------------
A miniminal fictional index as I see in some of my books would look
something like this:

B
Big Bang Nucleosynthesis, 5

P
Planetary Nebula, 1

----------------------------------------
This is what I'm trying to achieve, example only:

B
baryogenesis (Big Bang Nucleosynthesis), 5
Big Bang Nucleosynthesis, 5

H
hydrogen (Big Bang Nucleosynthesis), 5

M
Milky Way Galaxy (Planetary Nebula), 1

N
nucleosynthesis (Planetary Nebula), 1

P
Planetary Nebula, 1
primordial nucleosynthesis (Big Bang Nucleosynthesis), 5

----------------------------------------
I have large tomes of research (and hope to one day have of astronomy,
too <g>) which have really inadequate indices in the back. I'd like
to be able to have a database where I'd put in the article title and
page number, yes, but whenever I find a search term I'll need to use
in future, I'd go in and put it in simply as a keyword. Then
hopefully Access would be able to create the second type of output
above. I'd then print it out and staple the sheets and tuck them into
the front of the book. 9 years ago I manually created this type of
thing as an RTF file and it took me _weeks_ to create! I need to
index all my books at this time but can't afford the time.

Does Access even such a feature, though, incorporating words into a
report in such a manner as in the example above? One that that a
still rather beginner Access developer might be able incorporate into
a solution?

Thanks. D






p.s., Just noticed that going through an actual example that I ended
up with a page range. To get the actual page numbers to be correct
for each keyword and so reduce flipping pages, that the keywords
themselves might include their actual page number for each entry.
That would reduce the complexity and keep it as simple as the above
would have been. So the entries might look something like this with a
simple addition of " - 7" in the example "baryogenesis" example above
and reformatting the output:

baryogenesis - 7 (Big Bang Nucleosynthesis, 5)

That would work just fine and would reduce complexity of the db
solution yet still get correct page numbering on all keywords.

 

[StargateFan]

StargateFan,

I do not know of a database that does this BUT here is site that has alot of
FREE sample databases. You may be able to find something there that can be
easily modified to do what you want...

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=3

Gina, thank you! These are databases that seem to show code snippets
more than actual databases, no? Then one would incorporate that into
one's own solution. <sigh> I'm sorry to say that I haven't had much
luck doing that type of thing and I honestly wouldn't know where to
begin to find a particular sample database to do the record+keyword
thing <g>.

Thanks for this, though. Good for future reference. D

 

[Gina Whipp]

StargateFan,

That's why we are here... to help you incorporate! Unfortunately, your
request is so specific I could not think of anything that would fit your
needs. I was hoping that by browsing thru the many samples you might
something we could help you modify.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

StargateFan,

I do not know of a database that does this BUT here is site that has alot
of
FREE sample databases. You may be able to find something there that can be
easily modified to do what you want...

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=3

Gina, thank you! These are databases that seem to show code snippets
more than actual databases, no? Then one would incorporate that into
one's own solution. <sigh> I'm sorry to say that I haven't had much
luck doing that type of thing and I honestly wouldn't know where to
begin to find a particular sample database to do the record+keyword
thing <g>.

Thanks for this, though. Good for future reference. D

 

[StargateFan]

StargateFan,

That's why we are here... to help you incorporate! Unfortunately, your
request is so specific I could not think of anything that would fit your
needs. I was hoping that by browsing thru the many samples you might
something we could help you modify.

Thanks, Gina. I guess my skills aren't up to the task. But thanks
anyway.

At least, is there any feature that could do this potentially in
Access, so that I have something to look for at least? Thanks.