How to create a query in Microsoft Access?
#1


Create a query in Microsoft Access:
A "query" refers to the action of instructing the database to return some (or all) of the data in your database. In other words, you are "querying" the database for some data that matches a given criteria. For example, you might like to see a list of all individuals whose first name is "Homer". Or you might like to see a list of all users who have registered with your database over a given time period. To do this, you need to do a query.
Here's how to create a query in Microsoft Access:
1. Ensuring you have the "Query" tab open, click "New"
2. Select "Simple Query Wizard" and click "OK":
3. Choose the fields you'd like to be presented in the results of your query. To choose 1 field at a time, select it and click the ">" arrow. To choose all fields click the ">>" arrows. For now, just select the "First Name" and "Last Name" fields, then click "Next":
4. Choose a name for your query and click "Finish":
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: air line microsoft access, query optimization access, create student marklist in ms access to connect in vb, how to create a seminar workbook, how to create a vb program for rail recervation, how to create a gis data, how to create a web application,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to create a report in Microsoft Access? smart paper boy 0 1,164 29-07-2011, 12:16 PM
Last Post: smart paper boy
  What are steps involved in creating a form in Access? smart paper boy 0 1,239 29-07-2011, 12:15 PM
Last Post: smart paper boy
  How to create tables in MS ACCESS ? smart paper boy 0 1,234 29-07-2011, 12:14 PM
Last Post: smart paper boy
  Define MS-Access? smart paper boy 0 1,186 29-07-2011, 12:13 PM
Last Post: smart paper boy
  To create a Java Bean to draw various graphical shapes and display it using smart paper boy 0 1,966 21-07-2011, 09:40 AM
Last Post: smart paper boy
  To create a distributed application to download various files from various servers us smart paper boy 0 2,501 19-07-2011, 04:59 PM
Last Post: smart paper boy
  Write a query that will accept an account no smart paper boy 0 1,086 09-07-2011, 10:50 AM
Last Post: smart paper boy
  Write a query for creating an Updateable view. smart paper boy 0 993 09-07-2011, 10:49 AM
Last Post: smart paper boy
  Create a view on the Client_master table for administration department. smart paper boy 0 1,187 09-07-2011, 10:43 AM
Last Post: smart paper boy
  PROGRAM TO CREATE MULTITHREAD BY USING VARIOUS METHODS project topics 0 1,092 06-04-2011, 01:21 PM
Last Post: project topics

Forum Jump: