Access: Normalizing your database - AdvantEdge Training & Consulting

Access: Normalizing your database

Not sure if you separated out the fields in the tables correctly? Normalizing your database is key to building an easy to use database. Using the “Analyze Table” command, Access will make recommendations. It then allows you to keep or alter the suggestions.
The steps for using this functionality is as follows:

    1. Click the Database Tools tab and then the Analyze Table command, located in the Analyze group.

Normalize database

    1. The first two screens give descriptions about the analyzer, with Show Example buttons to help you understand the process. Click the Next buttons to pass these two screens.
    2. In the next screen, select the table you want analyzed and click the Next button.

Normalize database

    1. Leave the Yes, Let the wizard decide choice selected and click the Next button. The next screen will allow you to check out the suggestions and make any necessary changes.
    2. Drag and drop fields between the tables, if needed.
    3. Rename the tables, if necessary, by double clicking on the top area of each table you wish to rename.

Normalize database

    1. A dialog box to rename the table will appear. Type in the new name and click the OK button.

Normalize database

  1. Click the Next button to go to the next step.
  2. The last step will ask you if you want to create a query, based on the tables being split up. Select Yes or No, and then click the Finish button.
  3. The tables and queries (if query creation was selected) will be created.
Learn to make Access databases that people will actually want to use with classes from AdvantEdge Training & Consulting.
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top