I suppose it could be done if searches proved too costly but I'm not convinced there would be a need.

On my PC, of my experiments in different searches, "boolean" searches based on a "fulltext" index are typically executing in 100th-1000th of a second. The slower searches wich do search the song text itself are taking 1-2th's of a second.

I don't know how Access might cope though - it's a nice desktop app but not a high performance database.

BTW, structure, I only split "song" into SongID, Title, Song and Filename but it would have been useful to "split" further. I've 4 more tables, tune which currently holds the tune in Songwrite format, keyword, songtune and songkeyword.