Examine all data in the table. Use the
Simple Query wizard and select all columns. After you execute the
query and see all the data in the Data Sheet, you can decide which
rows you want to display in your layout and how you want to narrow
your queries.
If your table is too large to view in the Data Sheet
view, you might want to increase the number of rows in the World
Settings dialog box, Data Control page (click Tools --> World Settings).
Use logical names for aliases.
You must specify aliases for calculated values, such as column values
you used to determine an average or a function result. Because you
are likely to display these values in your QMF Visionary layouts,
it is helpful to give them a logical name.
Name your query. The default name for
queries is Queryn. It is helpful to give
the query a meaningful name so you can identify its purpose. For example,
a query that returns all profits from all stores in a retail chain
might be named Profits_All_Stores.
Write filter expressions. You can restrict
the data returned from the database by writing filter expressions.