Access 2016 Advanced

Access 2016

Lesson 2 – Exploring Access

The Table Analyzer Wizard has seven pages. The first two pages are informational, with the first page describing the problem of duplicate data in the table and the second describing the solution. You can choose not to display these pages.

You then select the table you want to analyze. On subsequent pages, you indicate whether you want the wizard to decide how to split the table or whether you want to do it yourself. If you allow the wizard to split the table, the recommended tables and the relationships between them appear. You can then move fields between tables or even drag fields to create new tables. Each piece of information should be stored in only one location, and each table should contain only data that refers to a single subject.

After the fields have been put into the correct tables, you can set the primary keys. To be related properly, each table must have a primary key, and the primary key must be a field that uniquely identifies each record. Therefore, a primary key field cannot contain duplicate data. Access will generate unique fields, if necessary.

On the last page, you can allow the Table Analyzer Wizard to create a query. The query will be given the same name as the old table and the old table will be renamed. As a result, any reports, forms, or queries that refer to the old table can still be used.

The Table Analyzer Wizard

OFFICEPRO, Inc.

Page 17