SQL

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

21 posts

ReplyMon 20 Jul 2009, 13:53Delegate Vishal said...

Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

SQL

I'm using a database which has a number of queries which have been created using SQL statements rather than using Design view. Please explain how I can understand what it is doing, without learning SQL.

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	6		£475	£480	£495
2003	Tue 14 + Wed 15 Sep 2010	Limehouse	8		£450	£455	£495
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	9		£345	£350	£495
2003	Mon 6 + Tue 7 Dec 2010	Southwark	10		£275	£280	£495
2003	Thu 6 + Fri 7 Jan 2011	Southwark	10		£275	£280	£495
2003	Thu 24 + Fri 25 Feb 2011	Bloomsbury	10		£275	£280	£495
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 13th September 2011.

825 posts

ReplyThu 23 Jul 2009, 14:54Trainer Stephen said...

RE: SQL

Hi Vishal

Thank you for your question

I am assuming that the database you are using is in fact an Access database. If this is the case then you should be able to open the query in design view in the normal way. You will then see the tables and fields that the query is selecting, as well as the relationships between the tables.

Simply go to query view, select the query in question and then click on the design view button on the left hand side of the main tool bar

Regards

Stephen

21 posts

ReplyThu 23 Jul 2009, 15:05Delegate Vishal said...

RE: SQL

Thank you for your response.

Yes, it is an access database.

I have tried to view the query in design view and it doesn't work, hence my question. This query seems to be written using SQL rather than using the design view.

825 posts

ReplyThu 17 Sep 2009, 13:46Trainer Stephen said...

RE: SQL

Hi Vishal

Thanks for your question

Again, apologies for the delay. I have had a number of ongoing health issues recently combined with on site training,and have been away from work.

Can I suggest you copy and paste the SQL into an email and send it to me. I will then have a look at it, annotate it and then send you back an explanation.

My email is stephen

Regards

Stephen

801 posts

ReplyThu 19 Nov 2009, 09:28Trainer Rich said...

RE: SQL

Hi,

This question has now been left unattended for a while.

Vishal, did you e-mail Stephen with the required details?

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 25 Nov 2009: Automatically marked as resolved.

· So You Want To Create Forms In Access 2007?
· Microsoft Access Mistakes to Avoid
· Easy Updating With Microsoft Access
· Take an Access Course to Learn About Relational Databases
· Access VBA Training Adds Power to your Databases

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips