Access Data in a Microsoft Access Database
Say what you will about it, Microsoft Access is still widely used (and abused?)
At any rate, if you work with Microsoft Access, you may want to run a query against it to see what data you will get or to perform a sanity check on your SQL statement. To do so is easy, but not necessarily intuitive.
Just follow these steps:
- Open MSAccess by 2-clicking the appropriate .MDB file (the database you want to query)
- Select the "Create" tab
- Select the "Query Design" icon
- Mash the "Close" button on the "Show Table" dialog
- Right-click in the query window and select SQL View
- Enter your query in the window (overwriting the default "
- Mash the Run button (red exclamation mark) on the Design tab
- Gaze in wonder at the data returned, batting your eyelashes coquettishly if you're a chick or pounding your chest thunderingly if you're a cat.
Note: This works for Access 2007; other versions of Access should work similarly.
Known to some as "el Gonző," I am the Idea Man and elbowGreaser at the Microsoft BizSpark startup "Across Time & Space" and its Bilingual classic book division "Found in the Translation," which produces books such as "Don Quixote" with "Spanish and English side by side," also "Around the World in 80 Days" in French and English, "Alice in Wonderland" in English and German as well as English and Italian, etc.
In the past I have worked extensively with Delphi and InterBase/Firebird, but am currently focusing on C# and web technologies, specifically ASP.NET Web API, jQuery, HTML5, and CSS3, with a special interest in google maps and the gomap jQuery plugin.
Web sites created by Across Time & Space (me) are http://usamaporama.azurewebsites.net and http://www.bigsurgarrapata.com and http://www.awardwinnersonly.com
I have lived in eight states; besides my native California (to which I have finally returned) these, in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.
I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "half cowboy, half Indian") and nonfiction: http://www.lulu.com/spotlight/blackbirdcraven
Sort of a Dr. Doolittle among psychedelic algebraists, I am known as "The Map Whisperer" to wren and crow alike. Occasionally I have guided migratory birds who have lost their way, helping them homeward, and often the rackety times in the bee-loud glades would have been reduced to eerie silence had I not pointed the pathway home to those industrious pollinators.