Database: Database and Microsoft Excel Essay

Submitted By lishkjr

Words: 412

Pages: 2

Open Document

Database
Database
A database system is defined as a integrated computer structure which stores collections of end user or meta data. In any organization, a database system is very important. Databases can be used to store any information you to collect and store. This information could be a company storing information on all of its employees or a company collecting monthly sales data. The size of the organization or company will determine how you will store this data. Microsoft Access is a great program which works very well for a small work environment. Work environments that are small could utilize spreadsheets from excel to store their data which could suit their needs depending on the data they want to store. A larger company may need more than just Excel to store their data. Large companies would need to consider utilizing a database management system. A database management system can be described as a collection of data that the user can create, read, update, and delete data from a database. It serves as interface between the database and the end users or application programs.
I work for a big automotive company and there is a lot of data that is tracked on a day to day basis. An example of this would be tracking everyone’s day to day productivity. My group that I work for is a small group of people, less than 10 and we track all of our productivity using Microsoft Access and Microsoft Excel. I mostly use Microsoft Excel as a way of imputing data into spreadsheets. We than use these spreadsheets gather data to track our progress on a project we are working on to see where we are during and ending of the project.

Cadburys Information Systems

information. In Cadburys and in many other companies, they use different tools to process their information. They could use Microsoft Office Word to enter their information and store it. To then process their information they could use database software such as Microsoft Access, this would be good for large databases and reporting. Microsoft Excel would be good for a flat file database as it is just simply a list, it would also be good for use on figures, i.e. prices of products, how many product sold…

Words 1250 - Pages 5

Efficiency & Collaboration Proposal Essay

taken to ensure financial success and stability within the company. It is the responsibility of this team to achieve this important goal. This company has been using Microsoft® Excel®, which is a very successful program here in the Sales Department. In order to improve efficiency, data must be migrated into a relational database, streamline the departments work processes, and improve communications within the company. Below is the team assessment and proposal. The system of information coordinates…

Words 682 - Pages 3

Efficiency and Collaboration Proposal Essay

efficiency is important to both the business and the customers. But what makes the business efficient? The most important programs to run in a business are the database system as well as collaboration tools. If you are using the Microsoft Office Suite, Access is the most efficient because of its ability to process information using a relational database system. However, the collaboration tools that a business uses are equally important. These tools whether it is an inter- or intra-net type system, are critical…

Words 692 - Pages 3

Productivity Software In The Classroom

types of productivity software are explored, and spreadsheets and databases are specifically discussed in your textbook. How to most effectively use these two types of software in the classroom is explored. Because Microsoft Office Excel and Access are the most commonly used pieces of software in this field, they are discussed heavily. Alternative software products can also be used. Open Office offers free Microsoft Office Excel and Access-compatible software called Open Office Calc and Open…

Words 1740 - Pages 7

To Add To Your Talk About Email Which Is An Easy Example Of Unstructured Data

1. Structured data refers to information with a high degree of organization, they are included in a relational database that is seamless and readily searchable simple, direct search engine algorithms or other search operations; while unstructured data is essentially the opposite. The lack of structure makes compilation a time consuming task. It would be beneficial to a company across all business levels to find an instrument of data analysis that can reduce the costs unstructured data adds to the…

Words 586 - Pages 3

Essay on Advanced Computer Application

equivalent to the SUNY ESC Advanced Computer Application course. My essay will cover the following computer applications: Operating Systems, a variety of Software applications, Graphic Design, Antivirus Protection, Desktop Publishing, Utilities and Database Management. In these areas, I will describe the learning experience that resulted from each. 2. Sources of the Learning: Within the past 15 years, I have gained valuable advanced computer experience from several different sources such as, employment…

Words 925 - Pages 4

Bcom 220 Essay

service, but have been faced with much needed upgrade to our database. I would like to discuss a few suggestions that we will surely benefit from. I will be discussing the benefits of using Microsoft Access, suggest collaborative software that we can utilize in the future, identify how it can help the sales department, and Identify how it will improve communications in the work place. The usefulness of converting to a better updated database is much needed and will be much appreciated when used to its…

Words 529 - Pages 3

Summary Of The Steps To Create A Database

Table of Contents Access Summary of the steps to create a database 1. Design the database a. What OUTPUT do you require i. What input will be require to give you the output 2. Create the database 3. Design the tables 4. Create the tables a. Use the Design View b. Remember to name the table and the fields appropriately 5. Create the relationships between the tables – do this BEFORE you add any data to the tables. a. Remember to enforce the referential integrity 6. Create the forms…

Words 1011 - Pages 5

A Brief Note On The Fridge Calculator

The Fridge Calculator: Refrigulator Table of Contents Abstract 3 Design 4 The Breakdown Scanning 5-7 Weighing 7-9 Communication 10-15 Databases 15-19 Future 19-21 Appendix 22-33 References 34 Abstract In today’s society all kitchen appliances are digital, “smart”, and futuristic, except the refrigerator. Coffee machines are designed…

Words 4149 - Pages 17

Database Design Document: Personal Music Library

IT/260 Database Design Document Personal Music Library Prepared By: Date Modified: 02/23/2014 Week: nine Part 1: Introduction (due Week in Two) a) Application Summary: I chose the Personal Music Library, were I will use a program and database manager to download and save all my music in alphabetical order so I have easy access to my music and I will be able to search by artist or song title. b) Database Software: I will use a…

Words 683 - Pages 3