Queries

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

Resolved · Low Priority · Version 2003

21 posts

ReplyTue 2 Jun 2009, 14:21Delegate Vishal said...

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

Queries

Test question: when you open a complicated database in access, what is the best way to quickly review the database architecture?

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

870 posts

ReplyWed 3 Jun 2009, 16:45Trainer Rajeev said...

RE: Queries

Dear Vishal

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

If I remember correctly you asked me this question after the training.

In a query you can see the design view and if you have knowledge and experience of that specific type of query then it is that much easier to modify or understand the result that it derives.

Query also has a sql view which a user having sufficient knowledge can interpret or modify accordingly.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Wed 10 Jun 2009: Automatically marked as resolved.

· A Quick Intro On How Access Uses SQL
· Three Myths About Microsoft Access
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Want to Become the Office Hero? MS Project Training Could be the Answer

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