Organizing 7 Tables--Perhaps I'm Going About This All Wrong...

Hi,

I work in a library, and it's my job to keep track of information on thousands of journals.

I have seven sources of information--some of them were already on my computer in word or excel form and I converted them for access, and some of them I downloaded from various places we have subscriptions.
My approach so far has been to add the necessary fields to my SuperHoldings table and run updates and appends from the other tables to update and append that one SuperHoldings table. I chose the SuperHoldings table because, true to its name, it was the one with the most records. All of the tables can be related using the Title field.

I'm wondering if perhaps my approach is wrong. Making just one table to use seems like a waste of a database, but I'm not sure how to organize it otherwise. What I want is to be able to go to one central place and see all of this information for each record at once. (That makes 19 total unique fields, plus an optional "Subscription Info" link for EBSCO and Direct titles). (The Notes fields I would want to append into one field together, even though they all have different information--I asked how to do this is a previous post, so I can do it now.)

My problem is that often there are titles in one table that aren't in another table. Let's say that I use SuperHoldings as my primary table, and information about each record is filled in from the other six tables--well, the Project Muse table has some records that aren't in the SuperHoldings table--so if SuperHoldings is the control, then the Project Muse records won't come up unless they're in common with the SuperHoldings records.

I've looked at the way to relate tables, and there isn't an option for Show ALL records of BOTH Tables--combining like records when applicable.

So, that's why I've been adding all of the fields to SuperHoldings, appending whatever titles/records aren't in the Superholdings list, and updating information one table and one field at a time from the other six tables.

Actually, all of that work is pretty much done--but information is going to change on those six tables. I can either update my superholdings table from changes each source sends out and just forget about downloading new versions of the other 6 forever, or I can download new versions periodically and have it updated like that.

If you're confused... well, I'm sorry. I'm confused to.

I'm putting a list of my tables at the end of this. If you have suggestions on how I can organize this, please let me know.

I am on the lookout for workshops or training sessions that I can sign up for to be trained in Microsoft Access, but so far I haven't found any. I think I would prefer an actual classroom setting so I can ask these insane questions and use my hands to make gestures.

Thanks,
Siena

My Tables:

SuperHoldings
Title (Primary Key)
ZP#
Former Titles
Title Changes
Paper Holdings
Microform Holdings
Closed (Yes/No Box)

Actives
TITLE (Primary Key)
FUND
NOTES

EBSCO
Title (Primary Key)
ISSN
Notes 1
Notes 2
Notes 3
Vendor
Subscription Info (Group of Fields Only Applicable to EBSCO Titles and not repeated elsewhere.)

Directs
Title (Primary Key)
Fund
Notes
Vendor
Subscription Info (Group of Fields Only Applicable to Direct Titles and not repeated elsewhere.)

JSTOR
Title (Primary Key)
ISSN
JSTOR Holdings
JSTOR URL
Vendor

Project Muse
Title (Primary Key)
ISSN
E-ISSN
Notes
PM Holdings
PM URL
Vendor

EJS
Title (Primary Key)
ISSN
E-ISSN
Notes
EJS Holdings
EJS URL
Vendor