How to make a File system for reseaching U-boats

Discussions on all (non-biographical) aspects of the submarine forces of the Kriegsmarine.
User avatar
USAUBOATS
Member
Posts: 13
Joined: 20 Nov 2018 00:13
Location: Athens Ga.

How to make a File system for reseaching U-boats

Post by USAUBOATS » 22 Nov 2018 12:31

I through a new topic would be in order for this subject. As I read all the topics here I see "My files show this or that"
My question is how do you all set up your files?
I have a file for my 13 USA U-boats
Then a file for each U-boat
Then in this file I have several files
1) Source
2) Photo
3) History
on and on

The trouble with this sytem is when you want to find something if you dont know the U-Boat your lost

IE. What photos do I have of all type IX boats?

In my system I have to get my list of type IX out and go down each boat and check each U-Boat file
Not good when I have a file for each boat

Hope I have made this so everyone can Understand it and can help me with my system or help you with yours.
Thanks for any help you can give me

Great site and a lot of information Thanks


Bill
Athens Ga

OpanaPointer
Member
Posts: 3773
Joined: 16 May 2010 14:12
Location: United States of America

Re: How to make aFile sustem for reseaching U-boats

Post by OpanaPointer » 22 Nov 2018 15:53

Look for an Open Source (free) database program.
Come visit our sites:
hyperwarHyperwar
World War II Resources

Bellum se ipsum alet, mostly Doritos.

User avatar
USAUBOATS
Member
Posts: 13
Joined: 20 Nov 2018 00:13
Location: Athens Ga.

Re: How to make aFile sustem for reseaching U-boats

Post by USAUBOATS » 22 Nov 2018 16:39

Thanks for the information
I have Microsoft Access and Microsoft Excel
DO you think these two will work?
Bill
Athens Ga

mark harrison
Member
Posts: 264
Joined: 05 Feb 2014 15:59
Location: UK

Re: How to make aFile sustem for reseaching U-boats

Post by mark harrison » 22 Nov 2018 18:54

Hi Try boat, series, commander and patrol.
I have older versions of both those programs the newer version of Access has no pivot chart so if your database is simple, Excel may be your answer.

regards M H.

User avatar
USAUBOATS
Member
Posts: 13
Joined: 20 Nov 2018 00:13
Location: Athens Ga.

Re: How to make aFile sustem for reseaching U-boats

Post by USAUBOATS » 22 Nov 2018 19:58

MH
Thanks I am making up a Excel sheet now for my War Diaries
Bill

OpanaPointer
Member
Posts: 3773
Joined: 16 May 2010 14:12
Location: United States of America

Re: How to make aFile sustem for reseaching U-boats

Post by OpanaPointer » 22 Nov 2018 20:21

USAUBOATS wrote:
22 Nov 2018 19:58
MH
Thanks I am making up a Excel sheet now for my War Diaries
Bill
I would recommend doing a database with a database program. I've had to port more than one spreadsheet over to DB programs. Microsoft call me up once, asking how I had managed something they had no suggestions for.
Come visit our sites:
hyperwarHyperwar
World War II Resources

Bellum se ipsum alet, mostly Doritos.

User avatar
USAUBOATS
Member
Posts: 13
Joined: 20 Nov 2018 00:13
Location: Athens Ga.

Re: How to make aFile sustem for reseaching U-boats

Post by USAUBOATS » 22 Nov 2018 21:13

Thanks I do use my access a lot

The only think I like about the excel is it is very easy to go from U-1 to U-5000 in a few seconds
I have not been able to do that with Access
But will play with it after Diner have a house full of people here now
Thank to both of you for the help
MH
My data base is not that simple I want to put all my U-Boat information for each boat in it, then break it down for what I am looking for.
ie Boat, Type, photos, or Boat Type commanders that kind of thing
Thanks again guys
Bill
Athens Ga

OpanaPointer
Member
Posts: 3773
Joined: 16 May 2010 14:12
Location: United States of America

Re: How to make aFile sustem for reseaching U-boats

Post by OpanaPointer » 22 Nov 2018 22:05

You might recall that they're designed to work together.
Come visit our sites:
hyperwarHyperwar
World War II Resources

Bellum se ipsum alet, mostly Doritos.

User avatar
USAUBOATS
Member
Posts: 13
Joined: 20 Nov 2018 00:13
Location: Athens Ga.

Re: How to make aFile sustem for reseaching U-boats

Post by USAUBOATS » 22 Nov 2018 23:36

Yes thank you very much for your help
Bill
Athens Ga

mark harrison
Member
Posts: 264
Joined: 05 Feb 2014 15:59
Location: UK

Re: How to make a File system for reseaching U-boats

Post by mark harrison » 12 Dec 2018 17:29

Hi I replied to this post on 22nd November stating that Access had removed the pivot charts I meant to say Pivot tables, just to be clear.

I myself use pivot tables a great deal but I am making myself clear as some members do not have english as a first language.

Regards MH.

Return to “U-Boats”