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

Chapter 40. Access Essentials > Secrets of the Office Masters: A Database Desig...

Secrets of the Office Masters: A Database Design Checklist

Before you begin creating database objects, think carefully about who will use the database and what kind of reports you'll need to produce from the data stored within it.

  • Storing data—How much data do you plan to enter? How much training and expertise will be required of those who are responsible for that data entry? Will you need to create systems to ensure accurate and reliable data entry?

  • Retrieving data—What relationships do you need to establish among the different sets of data that you produce? How can you exploit these relationships to create new combinations of data from different sources? Do you need to subtotal or summarize the data in any way?

  • Modifying data—Who will be responsible for editing data, and what level of understanding will be required of them? What safeguards will you need to create to ensure that changes in your database do not result in duplicate records or inconsistent data? If several people are using the database, how do you prevent unauthorized changes to data, while still allowing users to retrieve the information they need?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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