I have a dataset that contains more than 10,000 polygon features. I also have a point layer with 300 points, some of which intersect the polygon features. I want to make a query and create a dataset of those polygons which contain at least one point. How can I do this?
You can accomplish this using the 'Select by Location' tool, in the selection menu.
Just set the polygons as the target layer, the points as the collection layer. There are a variety of options that would probably work for you for the'Spatial selection method'. 'Intersect' is the default and will work but it will also return points that occur on the border of the polygon.
If you only want points that are fully contained by the polygon then choose 'Completely Contain the Source Layer Feature'
That's it, quick and easy, no programming necessary!
To build on the great answer by @KevinV, the attached image shows the result of Select Layer by Location in ArcGIS 10.1. The polygons that intersect the points are highlighted in blue. To create a new feature class from the selected polygons, right click on the polygon layer in the table of contents: Data -> Export Data (Selected Features).