Click here to Skip to main content
12,403,391 members (69,530 online)
Click here to Skip to main content
Add your own
alternative version

Stats

5.8K views
4 bookmarked
Posted

Quick-and-Dirty Testing of Microsoft Access Queries

, 28 Jan 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
How to query Microsoft Access tables

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:

  1. Open MSAccess by 2-clicking the appropriate .MDB file (the database you want to query)
  2. Select the "Create" tab
  3. Select the "Query Design" icon
  4. Mash the "Close" button on the "Show Table" dialog
  5. Right-click in the query window and select SQL View
  6. Enter your query in the window (overwriting the default "SELECT;")
  7. Mash the Run button (red exclamation mark) on the Design tab
  8. 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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

B. Clay Shannon
Founder "Across Time & Space"
United States United States
Ideaman and Coder at Across Time & Space, creator of "Mark Twain Central" at http://twaincentral.azurewebsites.net/

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) 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 "½ Cowboy, ½ Indian") and nonfiction: http://www.lulu.com/spotlight/blackbirdcraven

You may also be interested in...

Comments and Discussions

 
QuestionMy vote of 1 Pin
GuyThiebaut29-Jan-14 2:02
memberGuyThiebaut29-Jan-14 2:02 
GeneralRe: My vote of 1 Pin
B. Clay Shannon29-Jan-14 3:38
professionalB. Clay Shannon29-Jan-14 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160721.1 | Last Updated 29 Jan 2014
Article Copyright 2014 by B. Clay Shannon
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid