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 » Filtering records

	98.1 % recommend us
	More live stats...

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

Training information:

Filtering records

Resolved · Low Priority · Version 2007

Reply Mon 23 Mar 2009, 16:28Delegate Nicola said...

Nicola has attended:
Access Introduction course

Filtering records

Where do I find the Filter option on the toolbar when I'm in forms and want to filter records?

For upcoming training course dates see: Pricing & availability

Reply Sun 5 Apr 2009, 09:03Trainer Rajeev said...

RE: filtering records

Dear Nicola

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

In 2007 version of Access once you open the form you have to click on the Home tab on the Ribbon.

In the Sort and Filter group click the Filter button that is represent by a big Funnel.

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

Access articles

· How To Make One Combo Show Values Determined By Another Combo In Access
· What You Need To Know About New Security Features In Access 2007
· Use Split Form View In Access For Simultaneous Views
· User-Level Security In Access
· Microsoft Access Flaws and Ways to Overcome Them

Please browse our web site to find out more about
microsoft-access-courses 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