Before you consider building a database in Excel, you need to plan how you want to structure the database. Whether you just think about the plan or write it down on paper, it's advisable to have a plan. That way, you'll save yourself a lot of time and effort because you are less likely to build a database that doesn't work for you.
Consider these helpful questions and answers before structuring your database:
What is the size of the database going to be when I'm finished with it? Well, Excel gives you plenty of room on a worksheet. The size of the database can be as large as your worksheet, 256 columns by 65,536 rows.
What should I know about field names in relation to structuring my database? The ...