Hi, Im an estate agent looking for some help in creating a database for my clients. I want to be able to add all my clients details into a database and say I am looking for all those interested in 1 bedroom apartments I can search for contacts looking for 1 bedrooms, or 2 bedrooms etc Can I do this with Microsoft access? At the moment I have to go through a long list of every client to find the right peoplre. Help Thanks Foeydo
Yes you can do that in access. Once you have built the database you can start running queries to find the information you like. We have an Access database at work for 4000 items of equipment and we can virtually find anything we like very easily.
Have a look in the Help files it does explain it all in there.
my present details are in outlook express sorted into folders with clients name. i really need some simple step by step help. do i start a blank database and put my own fields in ie name flat or house etc... I have never used access before
I suggest that you read all you can about Access and databases in general. Start with something straightforward, such as a simple address book database. Use this to gain knowledge on database structure, queries and the use of forms. I can send you a basic example of one if you send me your email address (click on yellow envelope).
You will need several tables to achieve what you need. Think about what information you want to store and, more importantly, what questions you will be asking the database.