Help with Open Source DesignAuthor-Usable Database Table and FieldDesign for Glossary, Index, Spell Check, Persons, Bibliogrpahy, etc.

Access Database Design for a book’s master special word database…

Say an author has a book with “special words” identified for use in a
glossary, index, spell check adder, persons, authors, book titles,
quoted ironic words, possessive words, etc

Since every author needs this; I hope it can be a free collaborative
open source web project to build a freeware database with minimal
features first so everybody can deal with their books professionally;
indeed; I am surprised Microsoft didn’t add one…

The advantage of normal form of course is that one only need enter the
database; indeed the above “mess” was MADE FOR DATABASE NORMAL FORM.

My book is 2600 pages so this could be useful.

So let’s get started and focus on the general one that everybody will
and can use…

What is the correct design for an Access Database (in 6’Th order
normal form) for handling the entire situation?

Right now, I have a MS Excel Spreadsheet with the following columns:
WORD
Multiple Words spelled the same i.e. "read" and "read"
TYPE OF WORD which may be of many types; don’t worry about the full
details just uses the top dozen (NUMERIC, symbol,, DATE RANGE, UNKNOWN
EXACT DATE TO FIX, DATE, Regular, CHEMISTRY, ABBREVIATION OR ACRONYM,
ABBREVIATION, New, , FIRST NAME, LAST NAME, LATIN, LEGAL, NAME
FRAGMENT, NAME (SINGLE ), GEOGRAPHY, SLANG, CONTRACTION, Brand Name,
Weird failure of spell checker requires adding this, RELIGION,
Fragment of word , SCIENCE, ACRONYM, Book title ( from), FIRST
INITIALS, , Computer , Spanish , Trademark, Title of Journal, First
Name Nick Name, from book, from a , Title of Book, , Medical , Title
of Song, Title of Movie, FRENCH, Music , Title of Play, , Product
Name, SPECIES, (for indexing), Title of Book ( from), philosophy ,
Title of Television Series, biblical name of some sort, Title of Play/
Movie, book section , Physics , Book Title, Title ( from), Title of
Movie from, Book, Title of Movie and Book ( from), from a book,
Trademark of Toy, Trademark),
Is word, person, concept FICTIONAL? Yes or Not
Is it in primary form; i.e. plurals are not; possessives are not
The Primary Form of this word which is not the see instead cause of
names:
Spelled OK? Or should be added to spell Checker?
If word is a new word, who invented it
Should this book be in glossary of book "A"
DEFINITION of word
Should this be indexed?
How should it be indexed; i.e. perhaps a word "Paris" should appear
as "Paris (City)"
AE or MW?
Last Name if it is a Person
First Name if it is a person
FULL NAME
ADDITIONAL CAPITALIZATION FORM
ADDITIONAL POSSESSIVE FORM
ADDITIONAL PLURAL FORM?
TITLE of Person
SUBJECT of Person's interest
LOCATION of person i.e. US, Antarctica

Obviously, this is a non-normal “super messed up” join of what should
be several titles

And I have another table for all the quotations in the book, like said
by somebody or titles, words used in meaning, ironic words
With the following types
UNKNOWN
TITLE OF BOOK, MAGINE
EMPHASIS
IRONY
WORD QUA WORD
SPEECH by person


Furthermore, I want a table of persons cited
Which I have not built…It should handle single word persons like
Aristotle and also First and Last Name Persons…

And a table of works citied not yet made
Author(s)
Publishers
Edition
Title
Date Published
Type (book, movie, magazine article, etc…)


I just learned about the normal forms and want to convert everything
to Access; right now, though I am content just with the relationship
design of the database.

So the problem is to design an access database with the specific
TABLES, and ATTRIBUTES within in as normal form as possible; I
realized that everybody might want this database in general since it
would make like for authors easier.

Then this master database will be used to construct the following sub
databases:
Glossary (or multiple glossaries)
List of words to add to spell checker via custom dictionary
Bibliography
What to Index (or perhaps for multiple indices of words, authors,
works citied, etc…who knows…); by constructing the auto mark index
file
Table of Persons