Advise to NOT use spaces, special characters in object names (save for perhaps underscore _ ). NAME is a reserved word, as is DATE. Also, I'm not seeing any means of linking client ID (ID makes a poor name for a field if you end up with more than one) to anything else, but the other details might just be missing from your post and not your db.
Maybe check out
http://access.mvps.org/access/general/gen0012.htm
https://access-programmers.co.uk/for...d.php?t=225837
What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.