OK, I've been looking at the Excel spreadsheets for a while.
What I remember from school:
This is a dandelion, it is a weed, kill it.
This is grass (not pot!), mow it.
This is a tree, leave it alone.
Now you know my level of expertise about Taxonomy.
In Post #11, I attached a spreadsheet and asked how you would split the plant names, but since you didn't show me the correct splits of the plant names, I did it myself.
(which may not be correct)
Here is the problem I am having: all of your examples are designed in a spreadsheet,
AS a spreadsheet.
Access and Excel are two extremely different object models. How you set up a spreadsheet is very different than designing a database.
BTW, thanks for the links to the 'tree' web sites. They allowed me to make a "cheat sheet" - see the tab "X-Ref".
The dB is my attempt to create a dB. Next would be junction tables for the categories that can have multiple entries.
For example 'Bomen' - in your spreadsheets "Abies koreana" can be 1 of 3 trees: Beveerd, Hoogstam or Naaldhoutgewassen
There are 9 of these multiple option categories.
Take a look and see if any of this helps you........