The power of MS access query

MS access queryThe real power of a relational access database is its ability to swiftly retrieve and analyse any data by running it as a query.

Queries have the ability to pull information from tables based on a set of search conditions that is being defined. Queries are ways of searching and compiling data from tables. MS access queries are more powerful than simple searches or filters used to find data in a table. When you build a MS access query in an access database, it means you are defining specific search conditions to find exactly the data you need.

In an instance where you want to search for example in the ‘customers’ table to find the name of one of your recent customer’s in your business or a filter on the ‘orders’ table to view orders placed within the past few months, it would be nearly impossible to view both customers and order tables at once, instead you could easily run a query to search the name and phone number of every customer who made a purchase in the past few months. Knowing fully well that a well-designed query will give information you might not be able to find out just by examining the data direct within the table. Note also that when you run a Microsoft access query, the results are shown to you in a table view, but when you design one you use a different view called query design view, this lets you see how your query is being put together.

How to create MS access query

Before creating a MS access query you have to navigate to the query tab in your access database. Then select Queries from object wizard, this method will be helpful for beginners, so that they don’t get confused when they need to do something via the wizard tool, restricting them to the basic operations.

  • Double click on “create query in design tab”
  • Then add table or tables
  • Your query window should have a table you just added to it

This are just the basic setup process for making a query, you have to first choose which table you want to select data from every time you try to create MS access query.

Leave a Reply

Your email address will not be published. Required fields are marked *