Select Input -- Step by Step

1. Add Query. Click on Add Query to open Query Design View for a new query. Save a select query with the same name as the data source plus __Select with 2 underscores (e.g., Crash__Select).
2. Import Query. Click on Import Query. Provide information about an existing query from an earlier project.
3. Delete Old Query. Select row for query to delete. Click on Delete Query.
4. View Query. Select row for query to view. Click on View Query to display datasheet view of query results.
5. Edit Query. Select row for query to edit. Click on Edit Query to open the query in design view.
6. Import Data. Click on Import Data to read the __Select query to create a __In table (e.g., Crash__Select is used to create Crash__In).
7. Auto Run. If you have already completed all of the steps once then you can click on Auto Run the repeat Import Data and Standardize