Creation of query based on tables using wizard

Asked By 0 points N/A Posted on -

I would like to create a query based on tables with the use of a wizard. When doing this, it asks more details like record source, layout, format and fields, as to what you want. Accordingly, it creates a form based upon the answers. What should I do? 

Answered By 0 points N/A #108720

Creation of query based on tables using wizard


Creating queries using wizards will really ask you what to display, it is a must because it is asking you what you want to see in your query. Now if you don't understand this query wizard, I suggest that you learn how to use the SQL, I am suggesting this because I think you are using a query wizard using Access. Look for the SQL button once you have click the create query in Design View.

Below is the basic syntax.

Select [column 1], [column 2]

From [table source]

Where [condition 1] <<< Optional Line

You can learn more by searching it in the internet. Just look for SQL tutorial from the internet so don't worry, it is pretty easy to use.

SQL tutorial from the internet

Related Questions