ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to Create Queries Using Microsoft Access 2003

Updated on August 2, 2018
Patkay profile image

Patrick, a Computer Technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Creating Queries in Access

How to Create Queries Using Access

We have already tackled the introduction to Microsoft Office Access and also seen how to create a database. We are now going to learn how to create queries using Microsoft Access 2003. This tutorial will also help those who are working with Access 2007 or even higher versions, there is no much difference in the principles applied.

Creating Queries in Access

Queries are like questions. We use them to query the database for the information we want. In this way, you are able to display the information you want and in an efficient way. This is the process to follow to create a query.

  • Under the objects, select queries.
  • Click on new.
  • Select the design view method, though you can create queries using simple query wizard, crosstab query wizard, find duplicates and find unmatched query wizard. Then click okay to proceed.
  • On the show table dialog box, select the tables, queries, or both option to define what you want to use to make your query. For instance, if you want to use a table to make a query, select the table name and click on add, then click on close.

Creating Queries in Access 2003

Procedure of creating a query
Procedure of creating a query | Source

Creating Queries in Access Database Program

  • The select query dialog box appears. Now, here there are two ways of coming up with a query, you can add the fields you want by double-clicking on them, or you can create a query with all the fields. The easiest way to add all the fields is to double click on the blue area to select all of them, then dragging and dropping them on where it is written 'field'.
  • After dragging the fields you want, click on query menu and click on run. This option allows you to display what you wanted to see from your database.
  • To revert to design view of your query, simply go to view and select design view. In the design view, you can modify the query the way you want.

To save your query, you can use the options file save as and then give the query a name, or click on close and the computer will prompt you to save your query.

Defining the Source of Your Query Data

Defining what you are going to use to create a query
Defining what you are going to use to create a query | Source

Turning Your Data into Meaningful Information

Using your query, you can be able to manipulate your data the way you want:

  • You can drag only specific fields you want to the design grid leaving out the ones you do not want.
  • Using the sort option you can be able to sort different fields of your data either in ascending or descending order.
  • Using the show button, you can opt not to show some of the fields by deselecting the show button.
  • You can use the criteria option which allows you to limit or specify the records which are included in the results of a query.

Select Query in Access 2003

Setting the fields you are going to use in your query
Setting the fields you are going to use in your query | Source

Using Criteria in Access 2003

You can use the criteria, for instance, to display names starting with a certain character. So on the criteria under the names;

  • Type J* - this will display all names starting with letter J
  • Type *A* - this will display any name with character A anywhere
  • Type *Y – this will display any name ending with character Y

If you want to display a specific country, on the criteria under country type for instance Kenya. Once you run your query, this will display only patients from Kenya.

Running a Query

Running a Query
Running a Query | Source

Types of Queries You Can Create

To come up with these types of queries you create a normal select query and then in design view you go to query menu and select the query type you want.

  1. Select query – this type of query allows you to select the information you want. Any new query you create is a select query.
  2. Crosstab query – this a query that can be used to calculate a sum, average, count, or other type of total on records.
  3. Make table query – this type of query helps you to create a new table out of your query.
  4. Update query – this query type updates records in the object used to create the query.
  5. Append query – this query type appends or adds records to specified table.
  6. Delete query – as you can guess, this type of query will delete specified records from one or more tables.

Your views

Was this tutorial helpful

See results

© 2012 Patrick Kamau

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)