0
What are the advantages of using SQL rather than the Query Wizard?
Wiki User
∙ 10y ago
The query wizard can only do a limited set of types of queries. There are some kinds of queries that it cannot create. Some kinds of queries can only be done in SQL. Union queries and data definition queries for example. It is more complicated to do queries in SQL, but you can do more powerful ones. The query wizard is just for simple queries or for getting a basic query which you can then enhance using the design grid or SQL.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What are two ways to create a query?
by using the query wizard or design view
In order to create a query using the Simple Query Wizard you choose the?
data source and the field name
How do you create query using wizard?
i dont know The term 'query' means to search, to question, or to find
How do you create a query using the simple query wizard?
Go to the options bar and click add. then type in your query. it is pretty simple!
What are ways to create a queries?
by using the query wizard or design view
How do you create a query without using a wizard in access?
Use the Design method. You can then select the fields you want and the criteria you want and whatever other details you need. Once you learn to use it, using Design rather than the wizard will enable you to create better queries.
What are the advantages of using a telephone rather than using sound through the air?
hey paiges lol hailee -xx-
How do you retrieve an image from a database using PHP?
It depends what Database you are using. I personally use MySQL so will explain how you would do it using MySQL. You would have to create the MySQL database. I would store the image URL rather than the actual image. Then call it using PHP and a MySQL query. For Example: $sql = "SELECT * FROM Images WHERE Img_Name = 'img1'"; $query = mysql_query($sql); $array = mysql_fetch_array(query); then you would call it into HTML like so:
What might be the advantages of using scent rather than sight to attract a mate?
There are many possible advantages of using scent to attract a mate. One advantage is that you know they're compatible.
Two advantages of using CD-ROM encyclopedia rather than the Internet to get this information?
Africa
What advantages are there in using such a flight simulator rather than using a real aircraft?
It is less expensive and safer ,particularly for early trainig
Two advantages of using CD-ROM encyclopedia rather than the Internet tp get this information?
advantage and disadvantage of using cd-rom to get information about encyclopedia rather than internet
