Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Criteria

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Criteria

Resolved · Low Priority · Version 2003

Reply Mon 24 Nov 2008, 16:39Delegate Alan said...

Alan has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course

Criteria

Please could I have a list of all the valid criteria that can be used in the query design section?

For upcoming training course dates see: Pricing & availability

Reply Fri 9 Jan 2009, 15:40Trainer Rajeev said...

RE: Criteria

Dear Alan

Thank you for attending Access Introduction and Intermediate courses!! I hope you enjoyed the courses and benefited from them.

I am not sure exactly what your question means. As the criteria can be different from one query to another depending on what records you are expecting to extract.

If your question is more geared towards what the different operators that you need to enter to get your result then I believe that the below mentioned link will help you to achieve this:

http://office.microsoft.com/en-gb/access/HA100666111033.aspx?pid=CH100645771033

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

Fri 16 Jan 2009: Automatically marked as resolved.

Access articles

· MS Access can promote teamwork
· Access Corruption Avoidance Tip #1: Split Your Database
· Repetitive Tasks? Let Access Do The Hard Work For You
· Tips for designing databases in Microsoft Access
· Convert a Paper Trail to a DBMS

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

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips