Hey theory, not sure what package this is but i am quite familar with ms access as i did a course on it.
From what i can see you don't have any relationship in your tables (anything linking projects and clients) You are currently using client name, which isn't a unique identifer...what if several clients share the same name?
The solution is to create a unique key for both tables and this will be the primary key and thus create the relationship, something like "Client ID".
Hope that works