The Office XP suite provides two different types of database tools.
Access allows you to set up multiple databases that can be related to each other by one or more common fields. Excel allows you to build as many databases as you want, but each one is an island. They can't be related to each other, even if they have a great deal in common; therefore, Access is a relational database application while Excel is a flat-file database - "flat-file" because each database file has a single dimension and doesn't connect to other databases, which would give it depth.
Obviously, if you need to set up a series of databases that work together for reporting purposes - for example, a report that shows all the customers who have purchased a certain product, drwaing data from a Customers database and from a Products database - then Access would be the better choice for you. If you need to set up just one database, or if the databases you intend to build are unrelated, Excel is far simpler to use than Access for most users.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment