Design Access Databases With Normal Forms And Excel

Topics:
Software tips
Tags:
Data Management,
Software,
Office Suites,
Normalization,
Microsoft Office,
Microsoft Excel,
Microsoft Access,
Hardware,
Form,
Enterprise Software,
...
Source:
Microsoft

FREE Registration is required

Overview: To become a true Access power user, you need to understand a key database design concept called normalization. Normalization is the process of ensuring that your data conforms to sets of rules called normal forms. When you normalize your data, you eliminate redundant data and ensure that the information in each table is properly linked. . Normal forms aren't hard to understand and they're critical to designing useful databases. This paper explains how to use Microsoft Excel to create prototypes of your Access databases and how to make sure your data adheres to a set of rules called normal forms.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format: HTML | Pages: 13


advertisement
  • Click Here
  • Click Here
  • Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this directory, you become a member of BNET. In addition, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a directory registrant, you will receive a complimentary subscription to the BNET member newsletter, The BNET Report. You can unsubscribe from this newsletter at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).