Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Conclusion

It's time again to look back and see what you've done. Here's what you've accomplished since the first review:

1. Drew up a preliminary list of columns and created a list of tables in which to put them.

   You ignored mission objectives and made tables that represented one and only one subject.

2. Took a first stab at putting those columns into tables.

3. Evaluated the columns to see if any were calculated or multivalue fields.

   You dealt with these by creating or deleting new fields.

4. Reviewed the tables for candidate keys and selected a primary key for each table.

5. Reviewed the columns for multivalue fields.

   You did a preliminary fix by creating new tables that included the multivalue field and the primary key of the original table.

At this point, you've ...