Question

Open the wizard that will analyze a table and move redundant data into new tables that are linked to a copy of the original table through lookups.

a. On the Database Tools tab, in the Analyze group, click the 'Analyze Table' button.
b. Navigate to the Edit menu, choose Table Analysis, and select 'Move Redundant Data.'
c. Access the Data Management section, click on 'Table Optimization,' and choose the 'Create Linked Tables' option.
d. Go to the Home tab, select 'Table Tools,' and click on 'Data Analysis.'

Answer 1

The correct option to open the wizard that will analyze a table and move redundant data into new tables that are linked to a copy of the original table through lookups is to access the Data Management section, click on 'Table Optimization,' and choose the 'Create Linked Tables' option.

Step-by-step explanation:

The correct option to open the wizard that will analyze a table and move redundant data into new tables that are linked to a copy of the original table through lookups is 'c. Access the Data Management section, click on 'Table Optimization,' and choose the 'Create Linked Tables' option.' In Microsoft Access, the 'Table Optimization' feature allows you to split a table into multiple linked tables to eliminate redundancy.