User friendly databases for Mac

FileMaker Pro is an industry standard, and so not likely to disappear: it's extremely powerful and flexible (it's what I use), but also expensive. The following alternatives are taken from one of my web pages: I haven't actually tried any of them and I can't promise that all prices and details are up to date: so please treat what follows as a starting point.

Provue have updated their older Panorama and Panorama Sheets databases to a new version, Panorama X. It runs on OSX 10.9 and higher and has a wide range of facilities. Pricing is based on usage, ranging from zero if you don't use it to $15 per month.

iData3 and its update iData Pro 4 is a basic but reasonably flexible database: v3 will run on 10.5 up, v4 requires 10.7 up; it's $69.95 and there is a version for iOS. There is a simplified 'Lite' version for $29.95. Both can be used in a trial version for 30 days of actual use.

Tap Forms ($49.95) is a multi-featured database, though apparently with some limitations according to user reviews. It is available from their website or the Mac App Store (OSX 10.12 required): the website offers a free trial. An earlier version compatible with OSX 10.9 is still in the Mac App Store at the time of writing.

FileMaker's simple database, Bento, has now been withdrawn from sale. Records, from Push Popcorn, has some similarities with Bento, but is more powerful and flexible (though with nowhere near the power of Filemaker Pro, of course). However it cannot import records from Bento or other programs. It requires OSX 10.11 and is available from the Mac App Store at $14.99; there is a 30-day free trial from their website.

File Maker Pro is a long standing Mac alternative to MS Access and by Apple subsidiary company Claris

https://www.claris.com/filemaker/pro/

Not cheap as a one off purchase ,however monthly Subscription available.

LibreOffice requires you to install the current Java SDK in order to use its database features. You don't need that additional headache.

The macOS operating system ships with sqlite3 database, but it requires a command-line knowledge of sqlite3. There is a free user interface (DB Browser for SQLite) that can help you visually build a new sqlite3 database, define tables, load external data, and query that new database content.

LibreOffice is Mac compatible and is equal to MS Office except for some limitations - it is free to use or donations . It includes a Data Base Application as per of the Suite.