O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required