How to create a simple query in MS Access?

Asked 30-Mar-2022
Viewed 382 times

1 Answer


0

  • A query is a request for data results as well as data action. A query can be used to answer a basic question, conduct computations, aggregate data from many databases, or even add, edit, or delete data from a table.
  • Construct a select query.
  • To focus on certain data, use a query.
  • Select Create > Query Wizard from the drop-down menu.
  • Choose Simple Query, then OK.
  • Select the table that contains the field, then select Next after adding the Available Fields you want to Selected Fields.
  • Select Finish after deciding whether you want to open the query in Datasheet view or alter it in Design view.


Read More: Which is better, MySQL or MS Access?