Databases: Microsoft Excel 2003

5 Pages 1246 Words

Databases: Microsoft Excel 2003
A database is an abundance of information that can be used to store, sort, and catagorize information to suit the user. Databases are very important for keeping records in any business for lists of clients, employees, schedules, spending, business reports, and even customer information. As quotes at www.webopedia.com databases are “often abbreviated DB. A collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system.”
Databases can be used with database management systems. There are many different DBMSs that can be used in small or large computer systems. When you want information from the database you ask in query form. Requests for information can be general or very specific depending upon the symbols you use with your query. For example you can use quotation marks, plus sign, and greater and less than symbols to narrow the field of your request.
A data warehouse can be used by a businesses to help them see how the company is doing. It is like a test score you get that lets you know where you stand at that one point in a particular class. Businesses can use this information in a data warehouse to help make marketing decisions.
There are many database systems that are applicable to my business, Powell Productions. From what I have learned since the start of this class, I think that Microsoft Excel 2003 program would suit my business’s needs the best. This program will enable me to keep track of all the different types of data that I need to store and be able to retrieve on a daily basis. Excel 2003 has two basic ways to sort information. The first one is Basic Sorting. Basic Sorting is very simple once you have input the data into the Excel worksheet which used rows, columns, and cells. The information you want is highlighted and then you use the tool...