How to Remove Duplicates From Access Query

1. Open an Access 2007 database on your computer. Make sure it has a table that contains duplicate data. Select the 'Office' button and select 'Open.' Search your computer and locate the database. Click on the database and select 'Open.'
2. View the tables in your database in the Navigation Pane. Open one of the tables and visually note the duplicates and note the total number of records. Select the 'Create' tab on the ribbon. Click on the 'Query Design' button. Add the table you have just viewed by clicking on the table and selecting 'Add.' Select 'Close.' Add some fields to the query by double clicking on the fields.
3. Select the 'Properties' option by right clicking in the gray area of your query design field. This will display the Properties Sheet dialog box. Locate the 'Unique Values' field. Change the field to 'Yes.'
4. Run the query by clicking on the 'Run' button. The query will return the distinct values from the table. This is due to the Unique Values field being changed to Yes. Save the results by clicking on the 'Save' icon on the Quick Access Toolbar.