152k views
0 votes
Which option is the easiest method for creating a query in Access?

Create > Query Design
Create > Query Wizard
Design > Query Wizard
Design > Query Design

User Amit Anand
by
5.1k points

2 Answers

5 votes

Answer: Create > Query Wizard

Step-by-step explanation:

CORRECT ON EDGE

User Jim Wright
by
5.0k points
4 votes

Answer:

Create > Query Design

Step-by-step 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.

User Eleanora
by
4.7k points