easy CRM System

[cath123456]

Hello!
I want to create kind of a CRM for ca. 200 contacts.
It should work as followed: I have a form, where I fill in "Name","ID","Project",.. .
By clicking on a button, I want the information to be saved in a database, where I can filtre any project, name... to find the correct contact.
The form should empty itself by clicking the button (or another one) so that I can use it again for the next contact.
Can I use macros for this? Or do I have to use VBA code?
Am I right with access or is it also possible in excel?
I'm thankful for any hint
Regards

 

[alansidman]

This can be done in Access. Here is a link to db schemas

http://www.databaseanswers.org/data_models/