Wednesday, January 28, 2009

Why Use a Database

The key difference between Access and Excel is that Excel is used for a single table or a single data entry list. Where Access becomes useful is when you need more than one list or more than one table. Excel information is flat or nonrelational. Think of Excel as being a flat 2-d cartoon while Access being a 3D animation.

Access is also more useful with larger amounts of data and categories, and data that is relational. Access is designed to handle much more complex information than Excel.