Queries are one of the most powerful and important parts of database. You create databases to store data and retrieve information from them. Queries are the main way of retrieving information. You can show particular data or data that meets certain criteria. They can also do other things, like manipulate or delete data. There is a huge amount of things that can be done with queries. With practice and expertise they can be put to great use. Without queries databases would be practically useless. You would be able to store data, but not do much with it.
create tab
no
by using the query wizard or design view
Go to the options bar and click add. then type in your query. it is pretty simple!
There are several types that can do it. A Delete Query, an Update Query and an Append Query can. You can also create and delete entire tables with queries.
If its 2007, Go to the "Create" tab, then "Query design" drag all the fields into the table at the bottom, Presto.
To create a query that will display the top five orders in descending order by order total create a select query object. Open the query design table and select the top five orders, then choose to display them in descending order.
create table vino(char name(6));
i dont know The term 'query' means to search, to question, or to find
data source and the field name
You can use the Create Table Wizard, a Make Table Query or a Data Definition Query as ways that are built into Access to create tables.
query language