Access

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

Resolved · Low Priority · Version 2003

21 posts

ReplyMon 1 Jun 2009, 16:38Delegate Vishal said...

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

Access

Test question: what is the easiest way of reviewing complicated queries on a database?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

648 posts

ReplyTue 2 Jun 2009, 13:48Trainer Simon said...

RE: Access

Hi Vishal,

Thank you for your question.

Open the query and change the view to SQL view and you can then view the code for the whole query.

I hope this answers your question.

Regards

Simon

Mon 8 Jun 2009: Automatically marked as resolved.

· Use Microsoft Access to manage your work/life balance
· Bring Access Up To Speed
· Microsoft Access and Customer Surveys
· Access Corruption Avoidance Tip #3: Stay Connected
· Some Simple Database Questions Answered

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

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Access

Access

RE: Access

Related articles

Access tip:

Choosing data types in Access