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

Chapter 14. Building Excel Databases > Common Problems and Solutions

Common Problems and Solutions

The following is a list of common problems encountered when designing a database in Excel.

Q1:The initial design of the database is formed from knowledge of the data at hand rather than the output requirements of the database.
A1: Take the time up front to determine exactly what you want this database to accomplish. This point can't be emphasized enough.
Q2:Repeating data is entered into the spreadsheet using the data form.
A2: If you have data that repeats in several cells of the database (such as the same state for a list of employee names and addresses), use the copying skills you learned previously in this book to copy the information to the cells of your spreadsheet, rather than entering the state name again and again on each screen of the data form.
Q3:Searching is performed by scrolling through the database, looking at one item at a time.
A3: Old habits can be hard to break, but this is one habit worth breaking. If you are looking for a particular item or group of items in your database, use the AutoFilter feature to search quickly for field information.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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