Question

Which option is the easiest method for creating a query in Access?

Answer 1

Answer:

The first option is the easiest method for creating a query in Access.

Answer 2

Answer:

Create > Query Design

Explanation:

If you want to create a simple query used to retrieve data from a single table, the easiest way to do it is:

1. go to the Create tab
2. click the Query Design command
3. select the table
4. select the fields and establish the parameters
5. etc.

If you want to work on multiple tables and fields, plus you are going to establish several parameters and you are not sure all about how the information was entered, you should use the Create > Query Wizard.

The steps are fairly simple also, although they are more complex than the previous option:

1. go to the Create tab
2. go to New Query box ⇒ select Query Wizard
3. add or select fields
4. select the fields
5. establish the parameters,
6. etc.