What is the best way to fix a table with repeating groups?
A)Either fix the repeating groups in Excel before importing to Access or alternately add rows in Access and separate repeating data into individual rows
B)Export table to Excel,fix repeating groups,then import back to Access
C)Create additional columns for repeating data
D)Filter or query the table searching for repeating groups

Question

Quizplus · Accepted Answer

The best way to fix a table with repeating groups is either to fix the repeating groups in Excel before importing to Access or alternatively add rows in Access and separate repeating data into individual rows. This will ensure that the data is organized properly and can be easily queried or filtered. Exporting to Excel or creating additional columns can be time-consuming and may not effectively address the issue of repeating groups. Filtering or querying may also be useful, but it is not a complete solution for fixing the table structure.

What Is the Best Way to Fix a Table with Repeating