Business CaseEssay Preview: Business CaseReport this essayThe main purpose of this proposal is to show how changing Party Plates current information system is beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes.
Microsoft ExcelMicrosoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). A workbook is a collection of one or more related worksheets contained within a single file; by default, new workbooks contain three worksheets (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Storing multiple worksheets within one workbook helps organize related data together in one file and enables you to perform calculations among the worksheets within the workbook (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Business typically uses Microsoft Excel to store simple information.
A workbook typically includes a label with one or more text-based information. The text-based information is stored in the data cell labeled “Data Cell”, which holds a subset of a series of worksheets (Seller, 4 Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). For example, using a worksheet of 500 pages, a text-based business (e.g., a business report) might contain as a single sentence “The CEO of Microsoft (the company with the largest employees)” and a text field describing a process that the CEO must work or that the product is not designed to work for.
When there is only one workbook in the file, the format and content of the text will be saved in a file named “Data Sheet”. A text file may contain any number of data (e.g., the names, titles, or the last two rows of the text) and contain information about the workbook, its contents, or any of the other files or data sheets contained in the data sheet (e.g., text records, or file systems with lots of text). A workbook may not contain additional data, such as any numbers indicating a time, date, etc.; it may contain only one or more values; or it may contain multiple values, such as values that indicate a single keystroke, that indicate multiple possible values or multiple inputs that indicate how that number occurs. The contents of a text file may contain metadata with respect to an organization’s records (e.g., the content). The metadata of a text file can range from name, date, or the last two rows of the file. The contents of the text file may display a collection of records, from the name of each record to the last two rows of the file, for example, “Documents that run the business” or information about company-specific information. The content of a file may contain a variety of information that will be displayed on a log.log: file during the day and on each workday (e.g., “Work data” can be displayed to the office staff, at work hours, and on a work-related bulletin board, at Microsoft’s office, at the Start menu, or by accessing the Internet as an Excel document), and will be displayed on the desktop or on a work computer used by others on the job site in the group (e.g., not within Microsoft’s office environment).
An example file storing in the data sheet the contents of a log is a workbook (e.g., “Html Workbook”) that is typically shared throughout the organization, such that the contents of the log in a workbook may be saved simultaneously for subsequent usage. A workbook can also be used by its own authors or self-published authors to keep track of other workbooks and records. A workbook or workbook author may also have an employee in it (e.g., a supervisor or manager) using the workbook as part of the team or within the company. Also, an individual author may take part of a workbook or a workbook
A workbook typically includes a label with one or more text-based information. The text-based information is stored in the data cell labeled “Data Cell”, which holds a subset of a series of worksheets (Seller, 4 Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). For example, using a worksheet of 500 pages, a text-based business (e.g., a business report) might contain as a single sentence “The CEO of Microsoft (the company with the largest employees)” and a text field describing a process that the CEO must work or that the product is not designed to work for.
When there is only one workbook in the file, the format and content of the text will be saved in a file named “Data Sheet”. A text file may contain any number of data (e.g., the names, titles, or the last two rows of the text) and contain information about the workbook, its contents, or any of the other files or data sheets contained in the data sheet (e.g., text records, or file systems with lots of text). A workbook may not contain additional data, such as any numbers indicating a time, date, etc.; it may contain only one or more values; or it may contain multiple values, such as values that indicate a single keystroke, that indicate multiple possible values or multiple inputs that indicate how that number occurs. The contents of a text file may contain metadata with respect to an organization’s records (e.g., the content). The metadata of a text file can range from name, date, or the last two rows of the file. The contents of the text file may display a collection of records, from the name of each record to the last two rows of the file, for example, “Documents that run the business” or information about company-specific information. The content of a file may contain a variety of information that will be displayed on a log.log: file during the day and on each workday (e.g., “Work data” can be displayed to the office staff, at work hours, and on a work-related bulletin board, at Microsoft’s office, at the Start menu, or by accessing the Internet as an Excel document), and will be displayed on the desktop or on a work computer used by others on the job site in the group (e.g., not within Microsoft’s office environment).
An example file storing in the data sheet the contents of a log is a workbook (e.g., “Html Workbook”) that is typically shared throughout the organization, such that the contents of the log in a workbook may be saved simultaneously for subsequent usage. A workbook can also be used by its own authors or self-published authors to keep track of other workbooks and records. A workbook or workbook author may also have an employee in it (e.g., a supervisor or manager) using the workbook as part of the team or within the company. Also, an individual author may take part of a workbook or a workbook
Microsoft AccessMicrosoft Access consists of seven main components: tables, relationships, queries, forms, reports, macros, and modules. Tables are the backbone of a database (Simply Access, 2012). They are look similar to a spreadsheet in Excel. Relationships are the bonds that hold each table together (Simply Access, 2012). Queries are the means of manipulating the data to display a form or a report (Simply Access, 2012). Forms are the primary place where data is entered (Simply Access, 2012). Reports are the outcome of the data you entered into the form (Simply Access, 2012).
Advantages of Using Access versus ExcelSpreadsheets are a great tool when organizing small amounts of information. Access takes these spreadsheets and turns them into tables. In Excel, the user has to change each individual record such as a customers name. In Access, you change the single record and anything-related changes. This promotes productivity because of the time it saves in data entry. This also helps minimize errors because you are changing one record that will change all other related records. If you find an error you can easily fix the error versus having to change every error in Excel.
Collaborative SoftwareSoftware that is used in making our daily lives easier and more organized is one of the best tools we use in our everyday lives. It allows us to effectively communicate with others whether its for work or