databases on mac

Joined
Dec 23, 2009
Messages
1
Reaction score
0
Points
1
Been a reader of the forum for a while but dont really post much.

i have recently been given a admin role at a local volunteer group so i need some way of keeping record all the information that i will have.

i will have approx 400peoples records with all kinds of information but i just dont now what software i can use?

any ideas

webbie
 
Joined
Mar 9, 2004
Messages
9,065
Reaction score
331
Points
83
Location
Munich
Your Mac's Specs
Aluminium Macbook 2.4 Ghz 4GB RAM, SSD 24" Samsung Display, iPhone 4, iPad 2
Filemaker (more flexible) or Bento (easier, but not quite as powerful) are worth a look.
 
Joined
Nov 19, 2006
Messages
1,774
Reaction score
81
Points
48
Location
York, UK
Your Mac's Specs
iMac: 5K 27” (2020), 3.3 GHz, 32Gb RAM. iPad2, iPad mini4, iPhone 13 Mini, Apple Watch SE
For just 400 records I'd use a spreadsheet. Hardly any learning curve; name and address fields can be used directly by your wordprocessor for mailmerge/labels; it, or portions of it; can be readily exported and read by others; sorting and tabular reports are a doddle and it could be free - see NeoOffice or Open Office if you don't already have Numbers.

One tip - just make sure that every item of data (First name, Last name, Address line 1, Address Line 2, Town, Postcode..) are in their own column. Oh, (OK second tip) and save regularly during data entry and manipulation, particularly before sorting.
 
Joined
Jul 30, 2009
Messages
7,294
Reaction score
301
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
Excel has a List Manger feature that functions like a basic database program. You can sort by the various categories you create.
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,248
Reaction score
1,833
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
Agree with toMACsh, Excel is the way to go. Templates available from MS for free download.

Regards.
 
Joined
Mar 27, 2009
Messages
2,132
Reaction score
63
Points
48
Location
Lincoln Nebraska
Your Mac's Specs
late 08 macbook 2.0 4gig 320hdd10.7.3 32 gig iPhone 4s
And depending on what type of info you will have on said 400 people this might be a good time to look at security....just sayin:D
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
And depending on what type of info you will have on said 400 people this might be a good time to look at security....just sayin:D
You're on to something that I wanted to ask: what information are you storing? It's likely that Excel will work if it's simple but there may be something better depending on what you need to store and whether or not you need to edit it from elsewhere. Do you need a web based solution?
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top