• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 1: Understanding Microsoft Access > Designing Your Database Application

Chapter 3. Designing Your Database Application

Application Design Fundamentals53
An Application Design Strategy56
Data Analysis64
Database Design Concepts67
When to Break the Rules79


You could begin building a database in Microsoft Access much as you might begin creating a simple single-sheet solution in a spreadsheet application such as Microsoft Excel—by simply organizing your data into rows and columns and then inserting formulas where you need calculations. If you’ve ever worked extensively with a database or a spreadsheet application, you already know that this unplanned approach works in only the most trivial situations. Solving real problems takes some planning; otherwise, you end up building your application over and over again. One of the beauties of a relational database system such as Access is that it’s much easier to make midcourse corrections. However, it’s well worth spending time up front designing the tasks you want to perform, the data structures you need to support those tasks, and the flow of tasks within your database application.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint