access.training - Query

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

Resolved · Low Priority · Version Standard

Query

Irene has attended:
Access Introduction course

by - delegate Irene [1 post] (2007 Feb 21 Wed, 09:45) Reply

how do I run a query?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£190	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: query

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 22 Thu, 11:15) Reply

Hi Irene,

To run a query you need to click the red exclamation mark at the top of your screen. There is also a query menu where you can click on it and the first option is "run".

Hope this helps

Tracy

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Reasons to Consider Microsoft Access Training
· Innovation with Microsoft Access
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips