Tim Anderson's ITWriting [Valid RSS]

Tech writing blog

Blog Home RSS Archives ITWriting.com
Add to Feedburner Add to Bloglines Add to Newsgator Add to My Yahoo

December 4, 2004

Microsoft Access: my number one wish

Posted 3428 days ago on December 4, 2004

The JET database may be rather aged, but Access has a great UI for browsing and managing databases as well as a decent report writer. But here's my number one wish. I often use the query designer, but I usually want to write my own SQL. However, when you choose New Query, it comes up with the visual designer. So first I have to cancel the "Show Table" dialog; then I have to go to View and choose SQL. Tedious. Access 2003 gave us the ability to change the font in this designer, but why can't I set it to come up with the SQL view by default? I guess I should do a macro.

As an aside, I spent 5 minutes looking for an office feedback form on Microsoft's site. I can find one for documentation, but not for product feedback. Developers get the wonderful Product Feedback Center - I love it because it has voting, and because the team is good at responding, even if the response is often "won't fix". It's all about communication. So if someone from the Office team reads this - how about it?



Re: Microsoft Access: my number one wish

Posted 3403 days ago by ben • • • Reply

What I want to know is why the hell they don't add the Access UI to SQL Server? Not macho enough for big DBAs? :) No - if you want a quickie form for data entry or a simple report you're just going to have to link tables in Access... sigh...


Comments are closed

Recent posts

Users plead with Borland to give up .NET
IE7 to be released 18th October,...
If Microsoft doesn't use UAC, why...
Google's unsettling lack of direction
Vista security: now prove it


Powered by bBlog