Efficiency and Collaboration Proposal

Only available on StudyMode
  • Download(s) : 93
  • Published : May 30, 2013
Open Document
Text Preview
Efficiency and Collaboration Proposal
BIS-220
Team - ?

Efficiency and Collaboration Proposal
Accurate data retrieval is very important. Companies must use programs to organize and store data to operate their businesses more efficiently. Two programs used for this is Microsoft® Excel® and Microsoft® Access®. Microsoft® Excel® is a spreadsheet application developed by Microsoft Corporation. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It is considered the industry standard for spreadsheets in these platforms. Microsoft® Access®, is also supported by Visual Basic for Applications and is a database management system from Microsoft Corporation that combines Microsoft Database Engine with graphical user interface (GUI).

The amount of data the Microsoft® Excel® spreadsheet stores is 65,536, whereas, Microsoft® Access® accumulates unlimited data. Microsoft® Access® provides users a lot of options to handle and manipulate data compared to Microsoft® Excel® spreadsheets. Microsoft® Access® is more secure and flexible in dealing with enormous amounts of data. When dealing with a large Microsoft® Excel® spreadsheet list, the user can use the Microsoft® Access® data management capabilities, security, or multiuser capabilities, so that the data from Microsoft® Excel® can be converted to a Microsoft® Access® database (Microsoft Corporation, 2012). Microsoft® Access® offers many features and improvements. It offers integration with SharePoint® Server via Microsoft® Access® Services which allows for Microsoft® Access® databases to be published to SharePoint®, which enables multiple users to interact with the database application from any standards-compliant Web browser.

You can use Microsoft® Access® to connect to data from a variety of external data sources that you can view, query, and edit that data without having to import it. For example, Microsoft® Access® provides commands to...
tracking img