How to Insert a Query in MS Access 2007

Database software allows you to create tables and queries for dynamic desktop and web applications. Microsoft Access provides a user-friendly interface for small- to medium-sized businesses. The interface has a wizard that guides you through the process of inserting a new query into the Access 2007 database. The query retrieves data from the Access tables and displays it to the user. Access queries are used for reporting, online shopping carts and dynamic content.
  
Instructions  

1. Open Microsoft Access and click the tab labeled "Create" at the top of your window. These tabs are called "ribbons" in Microsoft 2007 Office software. The ribbon displays a list of options. On the far right, click the button labeled "Query Wizard." This opens the query creation wizard.

2. Select "Simple Query" from the list of options and click "OK" to move to the next wizard window. The first drop-down box labeled "Tables/Queries" lists the tables programmed for the Access database. Choose a table from the list. The wizard automatically displays a list of fields underneath the drop-down. 

Sponsored Links

 Bulk Email--Free Trial 

Award-Winning Email Marketing. 1,000,000+ Happy Users. Free trial! 

www.iContact.com

3. Select each column from the table that you want included in the query. With the column selected, click the ">" button to add it to the query. The columns selected are displayed each time the user executes this query. Click the "Next" button to move to the next screen.

4. Enter a name for the new query. Make sure you have "Open the query in view information" selected and click the "Finish" button. This option executes the query immediately after its creation, so you can view the final product.

5. Click the "Queries" button on the main menu to view a list of programmed queries for your Access database. This new query is now listed and available for use.

Sponsored Links

• Commercial Asia Listings
  Find Commercial Property Listings For Sale/Lease. Visit Us Today!
  www.commercialasia.com
• Bulk Email--Free Trial
  Email marketing to fit your needs. Start a Free 30-Day Trial Today.
  www.iContact.com
• Data Entry Software
  Powerful Data Entry software. Speed up your business processes!
  www.ABBYY.com
• 100% Free DataSheet (PDF)
  Over 20000000 DataSheet. It's Free. Multi Fast Search System.
  www.AllDataSheet.com