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

Chapter 14. Building Excel Databases > Planning an Excel Database

Planning an Excel Database

Ask yourself the following questions:

  • Why do you want your information listed in an Excel database?

  • What types of reports do you want to generate?

  • Who else will need to use your data and for what purpose?

  • What is the computer/Excel skill level of others who will use your database?

  • What information do you have, and what information do you need to generate?

  • For the information you have, in what order of entry can it be most efficiently accessed?

  • What methods (formulas and so on) will you use to generate the information you require?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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