The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

With this new relational database/table feature, this process is so easy that once it’s set up in Excel, you can extract specific data and create dozens of reports in minutes. PCWorld helps you ...

Drop-down lists in Microsoft Excel (and Word and Access ... repeat steps 13 through 14 above in the section “How to create a simple drop-down List.” Now it’s time to test your work.

I would be creating a database for a small company, moving tons of Excel files over into the database, and providing them with an *easy* way to access/update everything.<BR><BR>Currently ...