There are many types of data you may need to store and manage: text and numbers, for example. Depending on what you want your data to do for you, you may or may not need to use a database. You might be able to use a spreadsheet program like Microsoft Excel. How do you know which data can be adequately managed with Excel and which data really requires Access to manage it more efficiently? It depends on how much data you have to manage, and what you want your data to do for you. Let's try to answer this by looking at a bookstore scenario.
If you work for a bookstore business, you might have to keep track of your customers and their orders.
You could use Microsoft Excel to store and manage this type of data; however, Excel is a spreadsheet softwareprogram that is traditionally used to manage numerical information, like totaling up all purchases by one customer. While it can do an adequate job at storing some types of text-based data -- like the customer's name and contact information-- that is not really what Excel was designed to do.
The following examples will show you why an Access Database may be a better choice for the bookstore business.
No comments:
Post a Comment