Access SQL View: An Alternative View For Your Microsoft Access Database Query

Access SQL View: An Alternative View For Your Microsoft Access Database Query

We all know that Access queries is the heart of how to drive your database and in some cases using the Access SQL view to create such queries gives you better control and a clearer understanding of the Simple Query Language (S.Q.L.).

Take a look at how to gain access to the SQL view and the visual relationship between the gird and SQL view.

Access SQL View: An Alternative View For Your Microsoft Access Database Query

Where do you need to use the Access SQL view? Well, there are a handful of more specialised queries that the QBE grid will not be available for and that means having to use this view.

access sql viewFor example, the UINION query is such an instance and this query can start life by using the grid interface as shown in the video tutorial and then switching to the SQL view to continue and complete the query definition. I’m not going to explain what this query is about here but you may want to consider my More Advanced Queries eBook to find out.

In the meantime, If you want to start to master the Access SQL view and write in SQL (which is pronounced ‘sequel’), You can download my FREE SQL Reference Guide which will give some pointers into writing SQL in Access.

3 Replies to “Access SQL View: An Alternative View For Your Microsoft Access Database Query”

  1. I actually had a question regarding how would I automate a function such as automatically translating phrases in Microsoft access 2010 if you have already gone over this topic could you please send me the link regarding this. Thank you for your time.

    1. Two parts to clarify here:1. A function – creating a VBA function to translate what type of phrases? Are these simple, or few or a pattern of references for a function to work out? If so, then a VBA function will do the job and be stored in a module for global use. If not, then all phrases and their translated narratives will need to store in a table making this dynamic for lookup elsewhere.2. When you refer to automate, how do you want to trigger this action? Automation can be called from any event in Access which is what automation is really all about. It can even be when Access first starts up. Otherwise, like with any function it can be called in a table, query, form, report, macro or even another VBA procedure.Do you need help in building such a function? I could help you!
      Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *