Can anyone suggest anything
Ummmm...
Give us a few minutes at least.
Perhaps you misunderstand the nature of this group. We're not paid to answer
questions here; we're all volunteers, donating our time. Posting a "hurry up"
like this fifteen minutes after your first post isn't going to get you any
benefit.
Also, we'll be glad to answer specific design questions (in this newsgroup,
about the structure of your Tables and the design of your database; there are
other Access newsgroups for forms, reports, etc.). Just asking "fix my
database" isn't what this group is about!
My guess is that you should find someone to work with you one-on-one, and
investigate the database and find out if your previous consultant has built
anything worth salvaging or if they'll need to start over; or you may want to
learn enough Access to (with help from the volunteers here) do so yourself.
But this isn't a job mart; for that you'll want to look elsewhere.
If you would like to post a description of the nature of the data you're
dealing with, the structure of your current database, and the nature of the
problems you're having we'll be glad to try to assist... with *specific
individual problems*, not with "I don't feel good, Doctor, what should I
take?"