i have an access db with identical fields (name, address, etc). it's all text data type. there is one table for each letter of the alphabet with each group of names in it. there is an automatic id ...

You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns. Each row in a table is called a record while every column is called a ...