Working with Queries/text/shared/guide/data_queries.xhpWorking with QueriesYJ: checkeddatabases;creating queriesfiltering;data in databasesqueries;defining (Base)defining;queries (Base)wizards;database queriesQuery Wizard (Base)MW added (Base) to 3 entriesWorking with Queries
If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined.Creating a New Query With the Query WizardIn %PRODUCTNAME you can create a new query using the Query Wizard:Open the database file where you want to create the new query.In the left pane of the database window, click the Queries icon.Click Use Wizard to Create Query.Creating a New Query With the Design ViewOpen the database file where you want to create the new query.In the left pane of the database window, click the Queries icon.Click Create Query in Design View.You see the Query Design window.