BIS 220
12/23/2013
DeAndra Hayes
Efficiency and Collaboration Proposal
In order to stay ahead of the competition and remain competitive in the marketplace, steps need to be 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 activities and provides a vehicle of communication throughout the organization. In addition, the system of information represents all resources and systems organized for the following purposes: information input, information storage, and the delivery and transmission of information. The ability to penetrate markets at a global level, seize market opportunities more quickly, and interact with small businesses as well as much larger entities are essential to the company.
With Microsoft® Access®, the ability to quote, schedule, track, ship and manage with ease can be realized. Microsoft® Access® will allow the company to organize any type of information. For example; customers, employees, staff evaluation, presentation of new product, stocks with interactive design capability. Microsoft® Access® also provides reports and forms that the company can present data in a uniform layout.
Microsoft® Access® is a database program that combines data from various resources, allows for single data entry fields, and prevents data repetition which helps avoid inaccuracies in data entry. It also enables associations between tables which provide standardization among data sets. Microsoft® Access® provides for retrieval of information that is sorted, analyzed, summarized, and reportable quickly. Microsoft® Access® also contains objects like tables, queries, forms and reports. The tables store data which are essential building blocks of any database. A record is a collection of facts about what data the columns contain. Queries in access retrieve and process data within columns and rows, while forms control data entries and data views. Queries provide visual aids, making the data easier to organize and create reports. Information in reports, tables, and queries turn into documents that are used to communicate throughout the company.
There are subtle, yet major distinctions when comparing the differences between Microsoft® Excel® and Microsoft® Access®. For instance, making spreadsheets in Excel® is a great tool that can be utilized for organizing small amounts of data. Access® compiles the data that is entered into a spreadsheet and organizes it into tables, whereas Excel® only stays in the spreadsheet format. If changes are required in