Welcome to the Q&A Forum

My company is in the service industry, in particular we create databases for companies to use in house. Therefore, when I think of what we do, I think "database solutions". We have 3 different types of services/approaches we take which I created keywords for those. Through research I found that people don't look for database solutions, instead they look for the type of database i.e. "inventory database" or "database developer" or the technology used.  I understand 'funneling' of a site from general to specific so I understand how to deal with the first type of keyword. But what about the second. Having my general database page optimized for 'database developer' would be awkward. Specially in the anchor text in my menu link. Any suggestions? Common strategies used for this type of scenario? Is it ok to still have the internal link be 'database solutions' but then optimize the page for 'database developer'? I'm a newbie struggling with keyword research/selection so any insight would be much appreciated!

I am currently trying to plan how to optimize my site based on keywords. I read and I understand site architecture and usability http://www.seomoz.org/blog/site-architecture-for-seo , but I am still somewhat confused about how to target each keyword per page or when http://www.seomoz.org/img/upload/splitting-keyword-targeted-.gif Let me give you an example. We build databases for SME's using 3 different technologies. One of them is MS Access. Based on PPC campaigns and keyword research some of the possible keywords might be ms access programmer ms access consultants access database experts According to the link provided, should these be separate pages? I feel if they were, our site nativigation would be cluttered and clients would not be benefiting from them at all. It might even lead to some redundant data which I believe is bad right? My feeling is to make one page and target one keyword, but I'm not sure. For example, see one of our top ranking competitors http://www.justgetproductive.com/content/access-programmer/index.php Please, look at the footer? Is that actually how I should structure my links? I hope the answer is NO! Then again, if I do just have one page targeting one keyword, what do I do about the others? Do I just try to use blog posts/articles addressing those keywords? Do I not target them at all? Thanks for any advice, please keep in mind I am just getting started. My approach is to create a plan to outline everything before I put a lot of time into it.