0

I have large single table that 'tracks' books, their shelving, and the people who currently have them. I want to build a database for them that is easier to work with. I tried to use the 'Analyze Table' function, but since it is a flat table there are duplicate shelves and people when I do that and I am not sure how to remove the duplicates while maintaining the relationships across the books.

So basically the one table is currently: ISBN, TITLE, AUTHOR, PURCHASE COST, PURCHASE DATE, FIRST NAME, LAST NAME, PHONE, OFFICE, AISLE, BOOKCASE, SHELF. And I want to split it into three tables with their respective fields; BOOKS, PEOPLE, SHELVING

I tried to use the 'Analyze Table' function, but it doesnt seem to support a way to remove the duplicates while maintaining the relationships.

Improve this question
6
  • 2
    There is also a "Find Duplicates Query Wizard" Commented Jul 25, 2023 at 15:56
  • Does this answer your question? How to find duplicates in a table using Access SQL? Commented Jul 25, 2023 at 16:00
  • Review stackoverflow.com/questions/31194959/… Commented Jul 25, 2023 at 16:01
  • Apologies, but these responses are just for locating and removing duplicates. The issue is maintaining the relationships when removing the duplicates, not the actual removal itself. Commented Jul 25, 2023 at 16:07
  • For each new table use a make-table query grouped by target fields. For example, to create PEOPLES table : SELECT FIRSTNAME,LASTNAME,PHONE,OFFICE INTO PEOPLES FROM [old flat table] GROUP BY FIRSTNAME,LASTNAME,PHONE,OFFICE and then add an ID column (autonumber, primary key) to it. Commented Jul 26, 2023 at 7:54
Related questions
1
MS-Access: Table entry can have different properties based on it's type
0
Creating a simple(but not for me) db
1
How do I create a form to input new records into a table that contains only ID values from other tables?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.