Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

best free database for mac

I have used MS access some, but I could use a free basic database program for a mac. We coach and have a locker room. We place at random padlocks on lockers and assigned players. Once season is over we reshuffle padlocks and start over. I would like a database with padlock serial number and associated combinations, a database with athlete names ( this will change with season) then a basic interface to assign a padlock to the lockers based in serial numbers. Then of course be able to print off reports.


Thank you.

MacBook Air

Posted on Mar 9, 2016 9:44 AM

Reply
2 replies
Sort By: 

Mar 10, 2016 9:03 AM in response to griff75

griff,


I think Numbers (the spreadsheet part of the iWork suite) can do this.


Post you question in that forum if you are interested in pursuing that path.


the forum is here:

Numbers for Mac


In addition, you can use Libre Office (a free office clone) which includes a database tool.


There are also several database programs listed in the App Store which you can access using the menu item " > App Store…"

Reply

Mar 11, 2016 8:14 AM in response to Wayne Contello

Here is one way you could solve with Numbers:

User uploaded file


The table on the left is where you enter the details about the locks


the table on the right you enter the lock S/N in column A and the students name in column B. the table looks up the combination automatically.


For the next year, you duplicate the Assignments table, select the content in columns A and B and re-enter the information as you pull locks out


the formula in column C is:

C2=IF(A2≠"",IFERROR(VLOOKUP(A2, Lock List::B:C, 2, 0), "Not found"), "")


this is shorthand for... select cell C2, then type (or copy and paste from here) the formula:

=IF(A2≠"",IFERROR(VLOOKUP(A2, Lock List::B:C, 2, 0), "Not found"), "")


select cell C2, copy

select cells C2 thru the end end of column C, paste

Reply

best free database for mac

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.