Use the Wizard to Create a Find Duplicates Query
Use a Find Duplicates query to discover whether your tables contain duplicate records. With the wizard, creating the query is just a matter of answering some questions. These instructions apply to Access 97.

---

MS-Access Find Duplicate Query Wizard
As the administrator of a Microsoft Access database, one of the jobs that you may need to do is the keep the database working as efficiently as possible. A major cause of performance issues and database slowdown is erroneous or duplicated data contained in a table. We can keep these problems to a minimum by validating data entry and preventing duplicate information from being entered. We may have inherited a database that already contains duplicate information, and in the case we can use the Find Duplicates Query Wizard to search out this data. Using this wizard we can create a query that reports which record(s) in a table are duplicated using some field or fields in this table as a basis for the query. Microsoft Access asks which fields that you want to use for checking duplication and also which other fields you would like to appear in the query results. We can also use the Find Duplicates Query Wizard to help find possible duplicate key violations; a valuable trick when you want to take an existing table of data and make a unique field with one of the existing data fields.

---

Delete Duplicate Records From Access Tables
Yes, deleting duplicates should be easy, but it's not. A Google search for newsgroup posts about deleting duplicates scored over 2500 hits. Clearly, this is a common problem. The confusion is compounded, no doubt, by the existence of the built-in Find Duplicates query wizard. While this wizard does a great job of helping you identify duplicates, it does not provide a way to delete them. Many posts at the newsgroup included frustrated comments like this: "I can see them, but I can't delete them!"

---

Creating Microsoft Access Queries using the Query Wizards
In Access there are two other query wizards that are available to (1)maintain the database, and these are: Find Duplicate Query Wizard. This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table.(2)Find Unmatched Query Wizard. Using this query we can show all records that do not have a corresponding record in another database table (for example, a Product with no associated Supplier, or an Employee with no associated Department) The Find Duplicates Query Wizard works on a single table, whereas the Find Unmatched Query Wizard compares records in one table with records in another.

---

Queries
Queries select records from one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet. Toc: Introduction to queries, Create a query in design view, Query wizard, Find duplicates query, Delete a query

---

Compare two tables and find records without matches
Sometimes you may want to compare two tables and identify records in one of the tables that have no corresponding records in the other table. The easiest way to identify these records is by using the Find Unmatched Query Wizard. After the wizard builds your query, you can modify the query's design to add or remove fields, or to add joins between the two tables (to indicate fields whose values should match). You can also create your own query to find unmatched records, without using the wizard. This article shows you how to start and run the Find Unmatched Query Wizard, how to modify the wizard output, and how to create your own query to find unmatched records.

---

Use a query to find duplicates
I want to use a query to find duplicates in a table. How do I do this?

---

Use the Access 2007 Query Wizard
The Access 2007 query wizard allows you to create queries without using Structured Query Language (SQL), the language normally used to retrieve data from a database. You may specify fields from more than one data source and the query wizard also is able to calculate averages, counts, maximums, minimums and sums. The following steps will show how to use the Access 2007 query wizard.

---

Use the Wizard to Create a Find Unmatched Query in Microsoft Access
A Find Unmatched query will locate records in one table that do not have related records in another table. For example, you could find customers that do not have orders pending. These instructions apply to Access 97.

---

Find Duplicates
Find out A Clever "Find Duplicates" Trick.

---

Find Duplicates Easily
After creating a database in Access, typically several people enter information. Over time, you need to clean up the database to remove duplicate records. While Access provides a query for just such a process, you can quickly find duplicate data within the database itself.

---

Introduction to Data Sheets
Many techniques allow you to create a database, the fastest of which consists of using one of the provided examples. The databases that ship with Microsoft Access can help you in two main ways: they provide a fast means of creating a database and you can learn from their structure. TOC: The Database Wizard, Database Properties, The Table Wizard, Data Entry on Tables, Table Printing, The Query Wizard, Data Entry on a Query, Query Printing.

---

How to Use the Wizard to Create a Crosstab Query
Crosstab queries make it easier to view records by displaying the information in a compact view similar to a spreadsheet. With the wizard, you just need to answer some questions to create the query. These instructions apply to Access 97.

---

The Structured Query Language
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

The Structured Query Language (SQL)
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

Can't Access Table in MS Query
I received the following error message when trying to create a new database query in Excel 2003: Can't access table C:Documents and Settings…My DocumentsTester.mdb.qryTest. I found a few knowledge base articles, but nothing relevant to my situation. I almost never use the wizard to create external data queries, but I thought I'd give it a shot. Using the wizard, I get this error: Undefined function 'Nz' in expression.

---

Query Design Articles and Tutorials
Here you will find articles and tutorials relating to Microsoft Access query designs, from planning what tables and fields will be used to selecting criteria to be applied. There is also information on query optimization and using calculations within the query. Hopefully you will find something of interest, whether you need to limit results of the query by applying simple criteria to designing expressions to calculate data on the fly.

---

Create a form by using the Form Wizard
Access provides several quick-create form tools on the Create tab, each of which lets you create a form with a single click. However, if you want to be more selective about what fields appear on the form, you can use the Form Wizard instead. The wizard also lets you define how the data is grouped and sorted, and you can use fields from more than one table or query (provided that you specified the relationships between the tables and queries beforehand).

---

How to Create a Simple Query
In Access 2003, you can use a simple query to retrieve data from fields. A simple query can also calculate values such as average, minimum, maximum and sum. The wizard makes it easy.

---

Create a Cross Tab Query without the Wizard
Now Create a Cross Tab Query without the Wizard in MS-Access queries.

---

Use the Form Wizard in Access 2007
The Form Wizard in Access 2007 creates a form from one or more tables or queries. It will ask you detailed questions about the fields, layout and record sources, and the desired format and creates a form based on those responses. The Form Wizard will be most useful to a user who does not already know Structured Query Language. Here's how to use the Form Wizard in Access 2007.

---

Crosstab queries
A crosstab query is used when we want to represent a summary query with two grouping columns like a double input table, in which each one of the group columns is an entry, one down the left side of the datasheet and the other across the top. Learn the crosstab Query wizard and the design view of a crosstab query.

---

Create queries for a new Access 2007 database
Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports. After completing this course you will be able to: 1)Use the Query Designer to create a select query that returns data from a single table. 2)Create a select query that asks you to enter parameters, then returns results that match those parameters. 3)Use a formula in a query to calculate a sum. 4)Use the Query Wizard to create a select query that returns data from two tables. 5)Use a text expression to concatenate fields.

---

Distributed Queries
Creating the Distributed Query: This is no different from querying in the Access database normally. If you use the query wizard to create a query, you will see the familiar interface from where you first select the table name from the drop-down and choose the columns you want as shown. The drop-down shows all the linked tables as well as any queries present.

---

Create a Query Using More Than One Table
In Microsoft Access 2003 you can use the Query Wizard to compare, contrast and integrate the information in different databases. Here’s how to create a query that uses more than one table in Access 2003.

---

Use a table or query as a mail-merge data source
You can create a mail merge operation by using the Microsoft Word Mail Merge Wizard. This wizard is also available from Microsoft Office Access 2007, and lets you set up a mail merge process that uses a table or query in an Access database as the data source for form letters, e-mail messages, mailing labels, envelopes, or directories. This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Office Word 2007 document. This topic covers the process for writing letters. For step-by-step information about how to set up a mail merge process, see Office Word 2007 Help.

---

How to Create a Select Query
Select queries retrieve data from other fields and can sum, count or average values as well. Initiate a select query in Access 2003 using the wizard, or follow this tutorial.

---

Query Joins - Inner & Outer Joins
You will often need to join tables in a Microsoft Access query where you need to view information from two or more separate database tables. For this you will need to use query joins to accomplish the task. When you run a database query to find data in related tables, by default Microsoft Access will look for records that have a matching value on both sides of the relationship. Whilst this is what you may want to do most of the time, by knowing how to use the different types of query joins, you can control which records will be displayed as the output. This enables you to again find the exact data that you want - not more and not less.

---

Microsoft Office Access 2007: 13 Pages
Contents: Tables and Relationships, Using Related Tables, Types of relationships, Viewing the Relationship window, Adding a Table in the Relationships Window, Setting Referential Integrity, Queries, Using Queries and RecordSets, Using the Simple Query Wizard, Creating a Query in Design View, Opening a Query, Adding a Table to a Query, Running a Query, Sorting a Query, Adding Criteria to a Query, Using Comparison Operators, Using an OR Condition, Creating a Parameter Query, Creating a Calculated Field, Creating Aggregate/Function Query, Creating an Action Query, Using Multiple Tables in a Query. (PDF file, install Acrobat Reader to read this Microsoft Office Access 2007 tutorial)

---

Wizard to Create a Crosstab Query
A Crosstab query is a special type of summary query that correlates summary values between two or more sets of field values. Basically, it calculates and restructures data for easier analysis. It can calculate a sum, average, count or other type of total for data that is grouped by two types of information—one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query’s calculation. Here’s how to create a Crosstab query in Access 2003.

---

Find records with the most recent or oldest dates
This article explains how to use a top value query to find the most recent or earliest dates in a set of records. You can use the information that this type of query returns to answer a variety of business questions, such as when a customer last placed an order. What do you want to do? * Understand how top value queries work with dates * Find the most recent or earliest date * Find the latest or earliest dates for records in categories or groups * Find the most recent and the earliest dates

---

Use the Find and Replace dialog box to change data
This topic explains how to use the Find and Replace dialog box to find and optionally replace data in an Access database. * Learn about using the Find and Replace dialog box * Find and replace data in a table * Find and replace data in a form * Find data in a query result set * Find wildcard characters * Examples of wildcards in use * Find quotation marks and null or blank values * Find and Replace dialog box control reference

---

Introduction to Data Analysis
After creating one or more tables in a database and populating it (them) with values, one of the next steps you would take is to examine or analyze the values in the database. Analyzing the values in a table is also referred to as querying. TOC: Querying a Database, Introduction to SQL, The Query Wizard, Query Design, Accessing the SQL Code of a Query, Removing a Column From a Query, Replacing and Moving a Column, A Query or a SQL Statement as a Record Source.

---

Get answers with queries
Find out how Microsoft Access queries enable you to answer questions and perform tasks with your data. Learn how to create a select query, the most common type of query. After completing this course you will be able to: 1) Create a select query. 2) Refine a query in Design view. 3) Retrieve data that matches the criteria you specify. (Microsoft Office Access 2003)

---

Create parameter queries that prompt users for input
A Microsoft Access parameter query is useful when you perform the same type of query often, but the values that you search for change. If you're familiar with the basic select query, learn how to turn it into a parameter query. After completing this course you will be able to: 1) Understand when and how to use parameter queries. 2) Set up and run a parameter query that prompts you for the data you want to find. 3) Set up a parameter query that retrieves all the data between two values. (Microsoft Office Access 2003)

---

Eliminate Duplicates with SQL SELECT DISTINCT
When you are working with the SQL SELECT statement, you will more than likely come across duplicate rows when viewing your query results. This should cause no real problems, and by using the SQL DISTINCT keyword in your SELECT statement you will be able to remove all duplicate rows from your query results.

---

Data Access Page
I am making a data access page that will return sales data (Access XP). I am trying to group the orders by customer so I can have a footer calculating total revenue generated by each customer. The page is set up with a customer header/footer, order header/footer, and a OrderDetail header. The data is being pulled from a query with [Customer Number] as criteria. The only problem I am having with this page is when I enter a customer number, the sections between the customer header and footer are in duplicate. I have tried to draw the data from one query per section, two queries (orders and OrderDetail), and from the customer table, orders query and OrderDetail Query... Any way I try, the orders and OrderDetail sections are duplicated for records with more than one sale. There is some sort of JOIN going on that I cannot figure out because there aren't any duplicates for the customers with only one order in the db.

---

Select data by using a query
When you want to select specific data from one or more sources, you can use a select query. A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources. You can use tables and other select queries as data sources for a select query. This topic provides an overview of select queries, and gives steps for creating a select query, by using the Query Wizard or in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).

---

What happened to the Table Wizard?
In earlier versions of Access, you used the Table Wizard to quickly create a table from sample tables and fields. But in Microsoft Office Access 2007, there is no Table Wizard.

---

Access 2003 Wizards not working
I'm having problems with Access 2003 wizards. Form and report wizards will only show one field from the table or query I want to use. I can't use the Crosstab query wizard either. I have tried uninstalling Office 03 and re-installing it. Also downloaded any update available from Microsoft, but still have the same problem. Any ideas?

---