Queries For MS Access 2007The Access query builder is a powerful tool across all versions of MS ACCESS. With it you build a query visually and run it. In Access 2007 there are some differences, mainly creating an empty Query. This tutorial will be dealing with MS Access 2007. We will now build a Query using MS Access 2007. Once you open a database in MS Access 2007 you are presented the following view in the "Home" Tab and should see whatever tables that are available. Right Click the "Tables" Bar and select "Show All groups" to view all Tables and Queries. This Menu will be grayed out if you have already done so. 
Next to begin the Query design process click the "Create" Tab and then "Query Design" on the far right. 
Once you have clicked "Query Design" you will be prompted with a "Show Table" window over a new empty query window. Select your Table and then Click "Add" and then "Close". 
|
|
Starting simple drag the * from the table in the top section to the bottom section. The * represents a wild card to get all fields. Click the Red "!" on the top left tool bar to run the Query. The "All Fields Wild Card" or * will show data from all fields when you run the query. This is the simplest access query to build.
For further help or suggestions go here: MS Access tutorials, Tables, Queries and later: Forms
You may post this tutorial on your website or in a forum. If you do please maintain a Link to Eraseve AP.
For further MS Access tutorials go here: MS Access tutorials
| Did you find what you were looking for? What would you suggest? mail@eraserve.com |
