2017 - Page 5 of 5 - 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: Click the Database Tools tab and then the Analyze Table command, located in the Analyze group. 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. In the next screen, select the table you want analyzed and click the Next button. 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. Drag and drop fields between the tables, if needed. Rename the tables, if necessary, by double clicking on the top area of each table you wish to rename. A dialog box to rename the table will appear. Type in the new name and click the OK button. Click the Next button to go to the next step. 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. 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.

Access: Normalizing your database Read Post »


Excel: Rows and Column Headers

Are you tired of holding printed sheets next to each other to compare the row or column headers? Ever wonder how to get the header rows or columns to show up on each printed page of an Excel worksheet? This video will show you how to add them. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

Excel: Rows and Column Headers Read Post »

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