Access Database Sort/Query...Please Answer?
-
Can you give me a reason for each of the following please?:) 1) Why is is a good idea to perform a 'sort'? 2) Why is it a good idea to perform a 'query'? Thanks x
-
Answer:
sort is used for sorting the data in ascending or descending order. if a customer is using your website to browse for some products and he wants to see the latest products first from a list this feature is very helpful. any database query is a must. query uses standard sql statements to fetch the data from the access database. this is a good programming practice to use parametrized queries so that you user choices can be taken as input. no program wille expose the entire database. nobody wants to see the entire data they want only what they need. for that query is a must. if you are into ms access programming then you may need to design forms ( presentation tier), format parametrized queries and write business logic ( business process) and then get the data from the third tier ( database )...
Lala Lottexx at Yahoo! Answers Visit the source
Related Q & A:
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- SOCIAL studies!!! Please answer this question?Best solution by Yahoo! Answers
- IF U ARE A DENTIST please answer?Best solution by Yahoo! Answers
- How to create a Database in FoxPro and how to retrieve and sort it out?Best solution by Yahoo! Answers
- Can you please answer this physics question?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.