What is a Query. and its various types found in Microsoft Access?
Answers
Answer:
Queries help you find and work with your data
A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
Major query types Use
Select To retrieve data from a table or make calculations.
Action Add, change, or delete data. Each task has a specific type of action query. Action queries are not available in Access web apps.
Answer:
Queries are very useful tools when it comes to databases and they are often called by the user through a form. They can be used to search for and grab data from one or more of your tables, perform certain actions on the database and even carryout a variety of calculations depending on your needs.
Four kinds of action queries are:
•Append Query – takes the set results of a query and "appends" (or adds) them to an existing table.
•Delete Query – deletes all records in an underlying table from the set results of a query.
•Make Table Query – as the name suggests, it creates a table based on the set results of a query.
•Update Query – allows for one or more field in your table to be updated.
hope u liked it...