x
Toggle Content Register or Login  -  October 23, 2017, 1:14 pm
Toggle Content User Info

Welcome Anonymous

Nickname
Password

Membership:
Latest: rictallarico
New Today: 0
New Yesterday: 0
Overall: 1874

People Online:
Members: 0
Visitors: 24
Total: 24
Who Is Where:
 Visitors:
01: Community Forums
02: Community Forums
03: Community Forums
04: Community Forums
05: Community Forums
06: Community Forums
07: Statistics
08: My Account
09: Community Forums
10: Community Forums
11: Statistics
12: Community Forums
13: Community Forums
14: Community Forums
15: Community Forums
16: Community Forums
17: Community Forums
18: Community Forums
19: Community Forums
20: Community Forums
21: Community Forums
22: Community Forums
23: Community Forums
24: Community Forums

Staff Online:

No staff members are online!
Toggle Content Main Menu
Toggle Content Last Posts
Last 10 Forum Messages

Request for extracts ignored by L'ufficio di Stato Civile
Last post by charliemis in Southern Italy on Oct 23, 2017 at 11:38:43

Ambrogio Bianchi Birth Certificate - Rome/Ferentino
Last post by debbiemfit in Where do I begin? on Oct 14, 2017 at 15:28:01

Cardano al Campo, Italy
Last post by Seabreezes1 in Northern Italy on Oct 13, 2017 at 21:58:14

Muscatello
Last post by Biff83 in Southern Italy on Oct 11, 2017 at 15:22:57

Motta San Giovanni / Valanidi questions: please help!
Last post by PrimoMattino in Southern Italy on Oct 03, 2017 at 17:32:46

Motta San Giovanni / Valanidi questions: please help!
Last post by Italysearcher in Where do I begin? on Sep 24, 2017 at 18:25:31

Bastianelli Sant Elia Fiumerapido or Altina
Last post by Italysearcher in Central Italy on Sep 23, 2017 at 18:29:38

RESEACHING LUCIA NAPOLI DELIANOUVA
Last post by nuccia in Where do I begin? on Sep 22, 2017 at 06:13:48

Surname Serafini from Barga
Last post by Libby in Northern Italy on Sep 04, 2017 at 03:47:22

Sant'Elia Fiumerapido - De Filippis
Last post by Marchpatty in Central Italy on Aug 24, 2017 at 23:45:06

Toggle Content Help Support this Site
Please support GentediMareGenealogy
Help us by supporting the future development of this site, or simply to say thank you.
Toggle Content EStore
Community Forums › Memories and Guides › PC Info and Guides › database?

     Forum FAQ   Search   Log in to check your private messages   Login  
database?
For help with tech support and programs
Go to page 1, 2  Next

Post new topic   Reply to topic    Forum Index PC Info and Guides Printer Friendly Page

View previous topic :: View next topic  
Author Message
Emmy
V.I.P.
V.I.P.


Joined: Jul 11, 2007
Posts: 1000
Location: Scotland

PostPosted: Wed Sep 05, 2007 1:12 pm    Post subject: database? Reply with quote

Just curious I've got widows XP what programme would I need to set up a database. I was thinking about recording information from the LDS films I have of Sant'Elia.
Am I right in thinking that if you set up a database you can access information by a date, a name or a year.

Once it was complete if You typed in a year all the people born in that year that you had recorded would come up on screen?

I know it worked like that on the old BBC computers Loooong ago! Confused
Emmy
Back to top
View user's profile
Cathy
V.I.P.
V.I.P.


Joined: Jul 10, 2007
Posts: 2681

PostPosted: Wed Sep 05, 2007 2:35 pm    Post subject: Re: database? Reply with quote

Emmy,
I love Excel to use for this purpose. I use Excel to keep track of all my town records. You can search for anything you are looking for with Excel's search feature and I can even keep track of how many records I have by year by using Excel's sort feature. Check out my spreadsheet of pubblicazione's for Montalto Uffugo for the year 1876: www.calabriangenealogy...e1876b.xls
You can alreadys save this spreadshet to your hard drive remove all my data and use it for your own. I believe Jim Bianco uses Excel too.
Let me know if I can help.

_________________
Cathy
My Websites
Back to top
View user's profile Visit poster's website Photo Gallery
Emmy
V.I.P.
V.I.P.


Joined: Jul 11, 2007
Posts: 1000
Location: Scotland

PostPosted: Wed Sep 05, 2007 3:02 pm    Post subject: Re: database? Reply with quote

Thanks Cathy
I have used spread sheets but what I was thinking about was slightly different you had to fill in different 'fields' if I remember correctly.
With spreadsheets I know you have to type in a 'formula?' but I just get all mixed up with that when I did 'Balance Sheets' with excel I wouldnt even trust the computer to add it up for me.
Putting the information like you have done in a spreadsheet say eg you wanted tp find all the people born in a certain year how would you access this information.?
Cathy thanks a lot for offering to let me use your spreadsheet if I decide to do this, its much appreciated.
Emmy
Back to top
View user's profile
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Wed Sep 05, 2007 4:28 pm    Post subject: Re: database? Reply with quote

Emmy,

A spreadsheet (Excel) can function the way you want ... formulas and searches are optional portions. The nice thing about a spreadsheet is you have basically unlimited columns and rows with no need to structure what is underneath. The sorting or filtering is just a matter of configuring things properly.

The other side, if you want to put some more effort into it would be a database (Access) ... there are several pre-designed templates that can be used ...

If you need more assistance, please let me know.

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
Cathy
V.I.P.
V.I.P.


Joined: Jul 10, 2007
Posts: 2681

PostPosted: Wed Sep 05, 2007 5:03 pm    Post subject: Re: database? Reply with quote

Emmy, if you need help, why not talk to me on Skype about it? I can walk you through as you do it too. That way, if you have questions, you can get an immediate answer. If you want, I can email you a blank spreadsheet with just the columns set up. Let me know. It really is very easy!

_________________
Cathy
My Websites
Back to top
View user's profile Visit poster's website Photo Gallery
Emmy
V.I.P.
V.I.P.


Joined: Jul 11, 2007
Posts: 1000
Location: Scotland

PostPosted: Thu Sep 06, 2007 6:53 pm    Post subject: Re: database? Reply with quote

Thanks Bob and Cathy
I just couldnt think of another name for a database and Bob when you mentioned Access it fianally 'rang a bell' with me, I'd forgotten that I was given a book 'Office Windows XP for Dummies' and I've found a section in it giving instructions how to use Access but its advising to use the 'wizard' to set it up. I've checked the list of prog. I have on my computer and I do have Access Very Happy
My daughter's really keen for me to try this as she thinks it will keep me 'out of mischief'! Shocked - and I'll be so busy I wont have time to nibble at biscuits etc more likely I'll be doing this neclord neclord and posting here for help Smile
Emmy
Back to top
View user's profile
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Thu Sep 06, 2007 9:52 pm    Post subject: Re: database? Reply with quote

As I am very experienced with Access, I will assist in any way that I can ... the wizards shoudl give you a reasonable start ...

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
nuccia
Admin
Admin


Joined: Jul 10, 2007
Posts: 4364
Location: Toronto, Ontario, Canada

PostPosted: Thu Sep 06, 2007 10:14 pm    Post subject: Re: database? Reply with quote

Access? Now there is a program I have never used but I would love to learn. I stink at excel too so this might be better. I love using notepad now..I learned a lot from your tutorials on working with it and html and even when I go to my brothers house now (he has no Internet) I use it to create pages.

If you say access is good then I want to try it..Are you going to put anything on the Wiki about it?

_________________
nuccia
Italian Surname Database

Calabria Exchange
Back to top
View user's profile Visit poster's website
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Fri Sep 07, 2007 11:06 am    Post subject: Re: database? Reply with quote

Hmmm ... you could talk me into it. I would need some basic information ... what information do you want to track (ie. firstname, middle, last, etc ...).

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
nuccia
Admin
Admin


Joined: Jul 10, 2007
Posts: 4364
Location: Toronto, Ontario, Canada

PostPosted: Fri Sep 07, 2007 11:23 am    Post subject: Re: database? Reply with quote

rfornal wrote:
Hmmm ... you could talk me into it. I would need some basic information ... what information do you want to track (ie. firstname, middle, last, etc ...).

Uhmmm.... Confused YES Shocked hide hide

How hard do I have to twist your arm??? lol I love your lessons..look want I have done, all with notepad with the help of your lessons..(and don't laugh because I still used tables..but they work)...

www.gentedimaregenealo...irths.html

www.gentedimaregenealo...lties.html

and I'm still working on this one..

www.gentedimaregenealo...fests.html

This one I used a template for and am hoping to make it the front page but I changed the colors from the original. I'm also still working on it though. Mostly in test stages right now.

www.gentedimareitalian...temap.html

What do you think?

_________________
nuccia
Italian Surname Database

Calabria Exchange
Back to top
View user's profile Visit poster's website
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Fri Sep 07, 2007 1:54 pm    Post subject: Re: database? Reply with quote

Awesome ... wonderful work, the tables are great!

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Fri Sep 07, 2007 1:55 pm    Post subject: Re: database? Reply with quote

On the sub-pages, you might put a link back to the main family page ... small detail, but makes things consistent.

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
nuccia
Admin
Admin


Joined: Jul 10, 2007
Posts: 4364
Location: Toronto, Ontario, Canada

PostPosted: Fri Sep 07, 2007 2:07 pm    Post subject: Re: database? Reply with quote

Yes..I will do that..I didn't really know what I wanted when I started..I jsut knew I would like it when I saw it so now, after nearly XXXX months I have figured it out..lol.

But I want to learn more..i want to learn access. Can I use that instead of tables? I hear tables are not really "the thing" of the internet future..learning all about css and xhtml now.

Other suggestions? Thoughts???

_________________
nuccia
Italian Surname Database

Calabria Exchange
Back to top
View user's profile Visit poster's website
rfornal
Mod
Mod


Joined: Jul 09, 2007
Posts: 138
Location: Columbus, Ohio

PostPosted: Fri Sep 07, 2007 4:21 pm    Post subject: Re: database? Reply with quote

Tables on web pages are OK to organize information. Tables are not OK when they are used to organize the entire page.

MS Access is used for tracking data, not for designing or managing web pages ... although you could design a series of reports to generate HTML pages from a database.

CSS is definitely something to dig into, but xhtml is not really necessary.

_________________
Bob Fornal
www.podcastgenealogy.com
Back to top
View user's profile Visit poster's website
Emmy
V.I.P.
V.I.P.


Joined: Jul 11, 2007
Posts: 1000
Location: Scotland

PostPosted: Sat Sep 08, 2007 6:49 pm    Post subject: Re: database? Reply with quote

Surprised Just to let you know I've managed to set up my database using the wizard it was soooo easy but I've still to work out a few things yet
eg I thought I would have been able to type in a surname (that's one of the 'fields') and all the records with that surname would come up but when I used 'querie' format and typed in the surname all the records showed up but in a different format. So I guess it will have to be 'trial and error' for a while but so far I'm NOT doing this neclord Very Happy Very Happy
Emmy
Back to top
View user's profile
  Page 1 of 2All times are GMT - 4 Hours

Post new topic   Reply to topic    Forum Index PC Info and Guides Printer Friendly Page

  
 
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum



Hosted By Site5.com
The logos and trademarks used on this site are the property of Gente di Mare Genealogy.
We are not responsible for comments posted by our users, as they are the opinions of the poster.
Interactive software released under GNU GPL, Code Credits, Privacy Policy
TCD_ItalianGene © Gente di Mare Genealogy