What is the best way to fix a table with repeating groups?

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


C

Computer Science & Information Technology

You might also like to view...

A ________ is used to create a many-to-many relationship between two tables by storing their primary keys

A) unique table B) macro C) junction table D) single form layout

Computer Science & Information Technology

A(n) ________ cell reference changes when a formula or function is copied from one location to another location

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Which of the following is not an appropriate use of the MAX function?

What will be an ideal response?

Computer Science & Information Technology

The queue delete operation is known as _____.

A. enqueue B. dequeue C. remove D. pop

Computer Science & Information Technology