1 / 10

Microsoft Access Query: Extract and Process Data Efficiently

Learn how to create and customize queries in Microsoft Access to extract and manipulate data from databases effectively. Understand the different query tools available and how to use criteria, wildcards, and logical operators for refined results.

duncanson
Download Presentation

Microsoft Access Query: Extract and Process Data Efficiently

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Query One of the objects in Microsoft Access It can help users extract data, which meets the criteria defined by them, from a database file. It must be written in a specific format. Microsoft Access provides different tools to help users compose a query. After a query is submitted, Microsoft Access looks up the database and displays the requested data. 11.1 Queries The idea of a query

  2. 11.1 Queries • Although a filter can help us find records that meet certain criteria, we can only obtain one set of filtered records from a table at a time. • The result cannot be further processed. • If we want to store and process the results after execution, queries should be used. The results of filtering cannot be stored for further processing.

  3. 11.1 Queries • Although a filter can help us find records that meet certain criteria, we can only obtain one set of filtered records from a table at a time. • The result cannot be further processed. • If we want to store and process the results after execution, queries should be used. The results of filtering cannot be stored for further processing.

  4. 11.2 Creating Queries • Ways to create a query in Microsoft Access: • Using Design View • Simple Query Wizard • Crosstab Query Wizard

  5. 11.2 Creating Queries • Using Design View to Create Queries • In the Design View, users can define queries with selection criteria and sorting method to retrieve and arrange the required data from more than one table. Extracting data with a query

  6. 11.2 Creating Queries • Criteria of a Query • In a query, criteria can be treated as the rule of retrieving data from a table. • The following table shows the usage of wildcard * and some logical operators which can be used for setting criteria in a query.

  7. 11.2 Creating Queries • Criteria of a Query Wildcard and logical operators used for setting criteria in a query

  8. 11.2 Creating Queries • Creating Queries with Simple Query Wizard • The Simple Query Wizard is another tool for creating queries in Microsoft Access. • In the process of generating a query, the Simple Query Wizard prompts users with a series of questions and then generates the required queries based on the responses of users. • The Simple Query Wizard does not allow users to define their own criteria.

  9. 11.2 Creating Queries • Creating Queries with Simple Query Wizard • The generated queries can be further modified in the Design View. • The Simple Query Wizard can also create a summary query. • A summary query is useful when we want to obtain statistical information such as the total sales amount and the average salary.

  10. 11.2 Creating Queries • Creating Queries with Simple Query Wizard • The generated queries can be further modified in the Design View. • The Simple Query Wizard can also create a summary query. • A summary query is useful when we want to obtain statistical information such as the total sales amount and the average salary.

More Related