Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Sunday, August 23, 2015 – Permalink – Normalization ModelExcel Mock-upNormalization, simplistically, is setting up tables of data so that information is entered only one time. Access is not as malleable as Excel, so for demonstration purposes, spreadsheet entries can be used to show the concept. "This article 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. Normal forms aren't hard to understand, and they're critical to designing useful databases." Design Access databases with normal forms and Excel Also see: An Introduction to Database Normalization Also see: Tushar-Mehta.com: Building and using a relational database in Excel See all Topics <Doug Klippert@ 3:32 AM
Comments:
Post a Comment
|