I have about 800 old vinyl records that I have collected from neighbors who no longer want them and plan to distribute them to other neighbors who do. Partly as an excuse to get up to speed on database design, I want to create a database for these records with fields for who donated them and those who want them. Then I'll write an algorithm to allocate them as fairly as possible.

I would iike to create a "data-entry" form that I can upload to a OneDrive folder. Each neighbor who wants some records can download and run it to indicate their preferences. It would create a data file with their preferences that they can send to me. I can then "upload" thaty into the database and run my algorithm against it.

Can I do that with Access? I have Office 365.

If not with Access, is there another database that I can do that with?

Is there a better way than my plan?

Thanks for any help.