Filemaker can do all of this, but unless you find and purchase a ready made solution from a developer, you'll need to be prepared to invest considerable time in learning how to create filemaker databases. If you haven't created a database before, you'll probably need to acquire a book or tutorials on the subject. You can also post specific questions here for further help.
If you haven't done so already, you can down load a 30 day trial copy from filemaker and try to get it to work for you.
Thanks for the response. I bought filemaker pro already. It seems as thoughthis its much easier then SQL. And also for design purposes seems much more flexible. Thanks for your help their a place that sells templates?@
Filemaker is simpler than SQL--but I always try to warn people that ask "can filemaker do this" that the real question is often "Are you prepared to spend the time and effort learning new skills so that you can do this with filemaker?"
Some templates come with your copy of filemaker, Filemaker inc. offers a business productivity pack and a list of third party solutions under the Solutions drop down on their main page. I'd check those options first, then web search "filemaker solutions" or 'filemaker templates" to see what is out there.