Share via


Working with Queries

When your application includes tables, you can select and display data from those tables using queries. You can use queries for various tasks:

  • Answering a question quickly. For example, you can find out information such as:
    • Customer name and address associated with a particular ID number
    • Number of outstanding orders
    • Number of customers with overdue balances
    • Region or salesperson with the best sales record
  • Viewing a relevant subset of your data
  • Organizing and generating data for a report. You can also run reports separately without using a query.

You can create queries from tables, define and organize query results, collect user input using queries, and customize queries. You can also direct queries to different destinations so that you can use them in other parts of your application.

In This Section

  • Working with Data
    Provides information to help you create effective applications by analyzing data requirements and designing your application components to meet those needs.
  • Working with Tables
    Discusses how to make sure your tables have the structure that your application requires. Data type and index choices are essential to the success of your application.
  • Working with Records
    Explains how to store data in the table by adding new records and how to change and delete existing records through the interface or by using commands.