Question

Define query. Why do we need a query in MS Access 2010?

Answer 1

HEYA!!

HERE IS YOUR ANSWER,

> Access is database software that allows users to hold a large amount of information.

> The components of a database are tables, queries, forms, reports and macros. Tables allow the user to hold the raw data.

> Queries manipulate data in the tables.

> We need queries in MS Access so that the data of the tables could be manipulated and changed.

HOPE IT HELPS YOU,

THANK YOU.☺️

Answer 2

A query is one of the most important features that MS Access provides. Using a query, you can search or compile data from one or more tables in a database giving specific search conditions so that you can be able to view the exact data that you want. You can then review, add, change or delete data from your database. MS Access allows you to create a build a query and save it in the database, so that you can run it multiple times. The commands to create a query are in the Queries group of buttons on the create tab. You can create a query either using Query Wizard or Query Design option.