Learning Outcomes
- Define queries in Microsoft Access
- Create a query
Having a database full of information is great, but it does not do the business any good if it cannot be used to make decisions. The ability to extract information from a database so that it is useful for decision-making starts with the “query.” Simply speaking, a query is a question being asked of the data to inform the business.
A query of a database like Access gives you the ability to bring data together in a coherent manner, whether it resides in one or multiple tables. The query is the heart of “Business Intelligence” (BI) and the foundation of the Search. For example, a business may wish to know where the sales of its new product are occurring by zip code; or, who the top 5 suppliers to the business are.
Practice Question
Create a Query
Access provides query capability in the form of wizards to help create the query. To create a query, select “Create” from the tool bar and then “Query Wizard.” This will open the “New Query” window where you can choose among 4 wizards.
In our example, choose “Simple Query Wizard.” This wizard gives the option of choosing the table and the field for the query.
Let’s say that we are interested in knowing the status of Purchase Orders. Since this data is distributed across 2 tables, a query is the ideal way to gather this information. For this query we will need to select the “Purchase Order” table and several fields contained there as the example below.
We then need to add data from the “Purchase Orders Status” table, so we select that and the “Status” field as in the example below.
The completed query brings together the information we requested in datasheet format and from here can be sorted, edited, resized or otherwise revised.
PRactice Question