Other How tos

Question 1

Find Duplicates Query

Answer 1

• Build a ‘Find Duplicates Query Wizard’ using fields with unique records.
• Duplicate records will show next to each other.
• can Manual Delete or Batch Delete

Question 2

Combine Fields in access

Answer 2

+ or &

Location: [City]+’,’+[State]
Field title: Location
Kalamazoo, MI

Question 3

Create Relationship

Answer 3

A primary key from one table and use it to relate in another table.

Question 4

How to create a parameter query?

Answer 4

• Create a SELECT query
• Place [ ] brackets around parameter in criteria row
  
  • *Field names, periods, exclamation marks, square brackets, or ampersands cant be used in parameter