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.
Subscribe to:
Post Comments (Atom)
1 comment:
Good. The simile of the 2d and 3d animations is an apt one. Excel does of course have some powerful functionality itself including the awesome functions sets available. But yes, for most complex data sets Access would be preferable.
Post a Comment