Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Creating a Single Table Select Query

Shiver CartoonThe Single Table Select Query is arguably the simplest of all database queries. You specify the table you want to recover data from and the fields whose data you want to see. Keep in mind that while we frequently talk about a table as a query’s data source, a query can also use another query as its data source.

In this article we will look first at creating a basic query and then at setting some criteria to limit the records that the query displays. To help you follow along with the examples, you can download from here an example database with sample data to work with. The download file includes the sample database in Access 2000 and 2007/2010 formats

The basics of creating a query are pretty much the same whether you are using Access 2000 or Access 2010 or any version in between. Getting to the design window of course is a bit different depending on whether you are using the traditional or ribbon interface.

Access 2003 and Earlier

A2003 DatabaseWindow

Access 2003 Database Window

A2003 New Query

New Query Dialogue

In versions 2000, 2002 (XP), and 2003, the Access interface is pretty much the same. The database is represented by the database window. Down the left side of the database window is the list of database ‘objects, Tables, Queries, Forms, Reports, Pages, Macros, and Modules.

To create a new query in design view, you select the Queries object and either click the New Button or click Create query in Design view. If you click the New button, the New Query Dialogue opens. In the New Query Dialogue, select Design View and click OK. The Query Designer will open.

 

Access 2007 and 2010

Microsoft introduced the Fluent User Interface or Ribbon with Office 2007. The general structure of the Ribbon is similar in Access 2007 but the layout on the individual tabs is somewhat different.

RibbonCreateTab

Access 2007 Create Tab

RibbonCreateTab

Access 2010 Create Tab

In either case, you need the Query Design shortcut in the Queries (2010) or Other (2007) group. Click that shortcut to open the Query Designer

The Query Designer

 

QueryDesignViewShowTable

Query Designer with Show Table Dialogue

When the Query Designer first opens, the Show Table dialogue opens with it. You can use the dialogue to select the table(s) and/or query or queries that you want to include in the query. You can either double click a table or query name or click the table or query name can click Add. When you have chosen then close the Show Table dialogue.

All that is required now is to select the field(s) you want to include in the query.

You can view the video tutorial demonstrating the creation of a simple select query

 

or download it from here.

Comments are closed.