If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Starting Point

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-11-12, 15:58
evanolynuk evanolynuk is offline
Registered User
 
Join Date: Jan 2012
Posts: 3
Lightbulb Starting Point

Hi all! I come to this forum looking for some suggestion as to where to begin learning how to create a very specific database. I am a business student undertaking a sideline project with a very limited background in computer science.

I have tried using open office's database software but either it cannot do what I am looking for, or I simply just cannot grasp how to do it. I would be willing to purchase the right program for me as long as the cost is somewhat reasonable (i.e. advanced commercial software is out of the question).

What I'm looking to do is something like a contact list. It would include the individual's name, contact info, and two very important things:
1. Property they are looking to purchase
2. Property they own, and/or are looking to sell.

Now, each of those two need to be broken down, for example, a dropdown menu. For 1. (looking for), the things needed would be type of property (residential, farm, commercial, or acerage), then each type of property would have its own set of specifics. So if you chose residential, the types of things needed would be approximate price, square footage, location, address, number of garages, number of bed, bath... etc. The same goes for 2. (property owned).

All of that information then needs to be searchable. So, lets say I had a client that was looking for a commercial property in town X for around 300,000... I would need some sort of way to querry the database based on all of those dimensions (type, price, location, size, bed, bath, zoning, etc).

Okay guys, I know I sound very dumb here, but this isnt my area of expertise. If you could, please give me a place to start; which software to use, and maybe some tutorials that will give me the background to begin designing this.

Thanks so much!!!
Reply With Quote
  #2 (permalink)  
Old 01-12-12, 16:03
Brett Kaiser Brett Kaiser is offline
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
Do you have Microsoft Access?
__________________
Brett
8-)

It's a Great Day for America everybody!

dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was

The physical order of data in a database has no meaning.
Reply With Quote
  #3 (permalink)  
Old 01-12-12, 16:07
evanolynuk evanolynuk is offline
Registered User
 
Join Date: Jan 2012
Posts: 3
Quote:
Originally Posted by Brett Kaiser View Post
Do you have Microsoft Access?
No but if access will do it I'd be more than willing to pick it up.
Reply With Quote
  #4 (permalink)  
Old 01-13-12, 13:58
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
Who are the users of this system?
If they are all in the same office, or all work for the same company, and there will likely be no more than five to ten simultaneous users, then Access will suffice.
If you are planning to make this available for a broader audience then you will need database server software such as MSSQL, MySQL, Oracle.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #5 (permalink)  
Old 01-13-12, 14:24
evanolynuk evanolynuk is offline
Registered User
 
Join Date: Jan 2012
Posts: 3
Quote:
Originally Posted by blindman View Post
Who are the users of this system?
If they are all in the same office, or all work for the same company, and there will likely be no more than five to ten simultaneous users, then Access will suffice.
If you are planning to make this available for a broader audience then you will need database server software such as MSSQL, MySQL, Oracle.
There will be at most 2 simultaneous users; both of the same organization. Sounds like Access is my go-to guy. Thanks guys! I may return with questions if I get stuck.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On