Starting with a Plan
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.
Structuring Your Database
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 ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
