What is Query and its types?

Query is an object of database that is used to view, retrieve, change and analyze records from a table based on specified condition.
  • When a user changes data in the query, the data in the table also changes. It can be used as a source of records for forms and reports.
The types of queries in Ms-Access are:
  • Select query
  • Parameter query
  • Cross tab query
  • Action query
  • Append query
  • Update query
  • Delete query
  • Make-Table query
Query can be created in:
  • Design view
  • Simple query wizard
  • Crosstab query wizard

Share :

Twitter

Random Posts

Back To Top

facebook main

counter

Powered by Blogger.