Premium Essay

Benefits of Using Microsoft Access

In: Computers and Technology

Submitted By hayden78
Words 267
Pages 2
Efficiency and collaboration proposal
Benefits of using Microsoft Access
Microsoft Access is a database application included in Microsoft Office, which helps businesses to save money. The different components and features make Microsoft access easy to use. The database application is beneficial to the work environment and offers a quick-learning format (Demand Media, Inc., 1999-2012). People can create an operational database in less than one-hour when importing information from other Microsoft Office applications (Demand Media, Inc., 1999-2012).Microsoft Access is capable of taking information from the enterprise software. More than one person can access or use the database at a time. People can add, delete, and update information instantly without the knowledge of programming languages (Demand Media, Inc., 1999-2012). Beginners can use the database wizard to create database objects and relationships that has easy to follow instructions. The database application helps to avoid errors and duplicates of data. The application is compatible with word and excel. There is no database code needed to perform database functions where with other applications a code is required. Microsoft Access has predesigned database templates allowing people to add data immediately without developing a template (Demand Media, Inc., 1999-2012). A business would benefit from Microsoft Access because most businesses grow and collect data over the years. The business can use the application to simplify data, which provides viewing in multiply ways and storing multiple tables into one computer file instead of multiple files.

References
Demand Media, Inc. (1999-2012). The Uses of the Microsoft Access Database. Retrieved from

Similar Documents

Premium Essay

Efficiency and Collaboration

...The Efficiency and Collaboration Proposal The use of Microsoft Excel has proven to be effective in tracking personnel data. To help improve efficiency of the current information systems it may prove beneficial to switch to a more relational database like Microsoft Access. In turn, this will help improve internal communication and help streamline some of the work processes for the sales department. Currently the Party Plates Company uses Microsoft Excel to track personnel data in a spreadsheet inputting small amounts of repetitious data each time a record is created. Although Microsoft Excel and Microsoft Access offer some of the same tools such as applying filters, sorting table data, and extracting information, Microsoft Access a relational database, has features to track actions and events in multiple related tables. It offers more built in tools better to organize, track, and to make a relational structure between the tables by using a common field for the purpose of creating queries, forms, and reports large amounts of data than Microsoft Excel. The Party Plates Company would benefit from the use of converting their personnel data from single Microsoft Excel spreadsheets into a relational database, such as Microsoft Access (2012 Microsoft Corporation). There are many benefits that Party Plates would get from using Microsoft Access. The cost is reasonable to the other databases available; this system permits customization of databases making it possible to manage other...

Words: 720 - Pages: 3

Premium Essay

E&C Proposal

...E&C PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their...

Words: 813 - Pages: 4

Premium Essay

Business

...Microsoft Access can help Party Plates in many different ways. Primarily, Microsoft Access is cost effective and readily available to most business owners in a package for professional use. This program is great for many businesses that need more organization in their sales, production, or finance departments etc. Secondly, this program is compatible with other programs, like Microsoft Word or Microsoft Excel, for ease of access. Being able to import an Excel spreadsheet into the Microsoft Access database cuts down on the amount of duplicate data. Lastly, Access can help with the collaboration of different departments when reporting to higher levels. For example, Microsoft Access can be utilized: to create a profit/overhead report for the President/CEO of the company, to track how much product each salesperson sells for goal setting/keeping, or just to keep track of your employees’ payroll. Overall, Party Plates will benefit from the use of this program. Although Microsoft Excel spreadsheet does not qualify as a database, this application is extensively utilized to hoard data and is habitually employed in working out uncomplicated database tribulations, since it is a flat file database. However, it is very useful to convert data currently held in Microsoft Excel spreadsheets into a relational database using Microsoft Access. First, converting Excel data into a relational database through Access has the benefit of lesser inaccuracies and variations. The significance of...

Words: 616 - Pages: 3

Premium Essay

Business Proposal

...Plates and Napkins Company Table of Contents Introduction 3 Benefits of Implementing Microsoft Access 3 Sales and Collaborative Software 4 Table……………………………………………………………………………………………....5 Conclusion 5 References...………………………………………………………………………………….……6 Proposal: Implementation of Microsoft Access Database Introduction Our party plates manufacturing business is growing and our customer base numbers are increasing every month therefore I am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because since our business is growing it is getting cumbersome and time consuming to manage multiple “Excel” files to analyze company’s data. According to article by CPA Janet Samuels and Robert wood they suggest “Data handling and reporting capabilities of access are more efficient” (Samuels, Woods 2007). Excel should be used when we need to create a onetime report by plugging in data, however in access you will have to setup a database to form reports. Therefore, we should implement the relational database so information is forever stored and accessible by employees to create different multiple reports. The benefits of implementing Microsoft Access over Excel are listed below. Benefits of Implementing Microsoft Access 1. We can easily import all of our Excel files in to access by using the External data ribbon. This imported data will be saved as...

Words: 831 - Pages: 4

Premium Essay

Party Plates

...Benefits of Party Plates Converting to Microsoft Access Party Plates is a rapidly growing institution and an outstanding plate and napkin supply pioneer, now again, newly poised to guide the direction of special event markets. The increase of company supply paired with the current high demand for said product presents the need for upgrades to the current information system software. Current software is somewhat out-of-date which could result in regression of company growth. Party Plates must acknowledge the ever-changing status of technology and invest in the implementation of new information systems, or current system upgrades. Team C suggests investing in software which will convert current data from Microsoft Excel into a relational database using Microsoft Access. The usefulness of the conversion software will improve internal communications while assisting to streamline some of the work processes for sales departments. This will also increase efficiency in both communications and sales; thus, creating a solid platform for each resulting smoother communications and an increase in sales. Sales will increase because the department can use Microsoft Access with much more facility, which permits more time to focus primarily in sales, not wasting time on dealing with outdated software issues. Systems often crash leaving employees to return to working manually and on their own until the system is restored; the employees at Party Plates using Microsoft Access, can be sure support...

Words: 848 - Pages: 4

Premium Essay

Efficiency and Collaboration

...communication and assist in sales. Efficiency and Collaboration Proposal As the manager of sales department at Party Plates; we have been considering changing form Microsoft Excel to Microsoft Access. These two products can be compatible to each other; however each as its own purpose and one can help our sales department better than the other (Sanger, 2012). Functions that are different between them are that Access is a relational database management system and can manage large amounts. Accesses can creat4 relationships between data because it uses flat files and can handle thousands of records. Excel is a spreadsheet and dose math. Excel has limited functionality and can handle up to 15,000 records. (Sanger, 2012). On the effort to increase sales, the corporation decided to use Microsoft Excel systems; it helps not also to increase sales but to have a better communication between the employees. The benefits are highly quantify, starting with the internal work environment, with the use of it the communication between employees is clear and faster, the corporation now can use applications that help to create documents, or prevent the duplication of data. With the use of it the company can avoid errors that can cost money and legal problems to the corporation. It gives the ability to have a better and faster access documents and programs to...

Words: 859 - Pages: 4

Premium Essay

Efficiency and Collaboration

...Mercier, Kathy Bowie, Angelia Moncrief-Wells, Beverly Yharbrough BIS/220 October 31, 2013 Frederick Lumpkin Efficiency and Collaboration The purpose of this proposal is to show the potential implementation of new information systems at Party Plates. There is so much excitement that comes with introducing all the new changes that could take place. The sales department is currently using Microsoft Excel but after looking around for something that would suit the businesses needs better it was found that Microsoft Access can fill those needs. As technology and our business grows there are always ways to improve. There are many benefits to switching over to Access that will benefit the company that will be discussed. Suggestions will be debated for future use of collaborative software and how it can help the sales department and how it can improve communications. Computers are very useful in today’s world. When you’re dealing with Microsoft excel, there’s a lot of information that you can create in Microsoft excel. Trying to convert data into Microsoft excel spreadsheet using Microsoft, is not an easy task. Excel can hold more information and it is generally very easy to read. Excel is a flat file database, not a relational database (Microsoft.com, 2013). Excel is very useful because you can analyze information or data, graphs, calculations, formulas, copy, paste and you can use it as a word document. You can decorate the spreadsheet with specific colors to identify key...

Words: 819 - Pages: 4

Free Essay

International Trade and Finance Speech Eco 372

...significantly within the last two years and the current Excel system, excel, cannot keep up with all data. In order to improve the efficiency of the current information systems used in Party Plates, the antiquated system needs to be upgraded to a much more efficient system such as Microsoft Access. The upgrade will benefit the company in terms of better data tracking and the ability of producingto produce useful reports in relation to customer sales. Microsoft Access is a database software that allows a user to manipulate large amounts of data. Unlike Excel, Access can hold more than 65 thousand records, which can be converted and viewed in various forms depending on what is needed. Microsoft Access offers two main benefits, its user friendly friendliness and its ability to hold large amounts of data without sacrificing performance. Microsoft Access functions in different ways that tie together …what? . Tables are used to store data from which queries can pull information from and perform calculations against the data. Forms can be used to enter information into tables. Reports will allow the information to be displayed in a printer-ready format. The reports can also be exported to other Microsoft Office programs, such as Excel or Word. Finally, macros allow for the automation of database tasks. Modules are an area for advanced programming language within the database. The last sentence does not support the topic - Refer to grammar guide for details on how to avoid dependent...

Words: 1402 - Pages: 6

Free Essay

Efficiency and Collaboration Proposal

...explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process. Usefulness Depending on whom you speak with you will get a different response when asked, which software is better Microsoft Excel or Access. They are both very powerful and unique software used by tremendous amount of individual’s worldwide. Just know that both are used to make our day at work or even at home easier by recording and organizing important data. However, how they store, organize, or display that data is completely different from each other making it one of the major differences between the two. For example, excel offers what is known as the what-if analysis, which can forecast the outcome of the worksheet. Although they may seem completely different visually, they are very similar in the information that can be stored. Microsoft access can store data in tables that look similar to those of a worksheet but function quite differently. Microsoft Excel on the hand displays flat-file database, which instead of tables displays data in rows and columns about a specific subject. Benefits Migrating to Microsoft Access will be beneficial to the...

Words: 684 - Pages: 3

Premium Essay

Proposal

...information system to track personnel data. Converting Microsoft Excel documents to Microsoft Access. Explain how this updated system can benefit the Party Plates Company. Provide suggestions on the future use of collaborative software and how this can help the sales department improve communications and streamline work processes. Converting Microsoft Excel to Microsoft Access Although people are more familiar with working with Excel over Access, there are significant advantages of converting the data over, According to Access in Microsoft Office 2010, the beneficial power of Microsoft Access derived from a database with multiple tables and the relationship that connects the tables (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Access has six objects: tables, forms, reports, and queries, the most popular tables enable users to input information display data in an organized format, and ask questions about data through queries and filters. It is beneficial to convert data from Excel spreadsheets to Access when data belongs filed in more than one table. Access provides a better way to handle large groups of data and has built in tools efficiently to organize data and create relationships between tables. Another advantage of converting data to Access programs is its ability to work in storage versus is memory. Once, information is input to a field it is automatically saved. The last benefit to converting data to Access would be the opportunity of more than one user accessing...

Words: 691 - Pages: 3

Free Essay

Efficiency and Collaboration Proposal

...relational database such as Microsoft Access versus their current database, Microsoft Excel. Team C will explain the effectiveness of converting data currently held in Microsoft Excel into an interactive database using Microsoft Access. Team C will also introduce types of collaborative software; how this software can improve communications and streamline work processes. It is time for something new, something invigorating and inspirational for this business’ organization. Party Plate’s current system is Microsoft Excel. The system is excellent for managing and maintaining data entry information as well as other electronically processed information. Microsoft Excel has allowed our business to control the inventory and regulate the calculations that are constantly occurring during a daily routine. Excel’s spreadsheet program has allowed this company to create and breakdown prices into rows and sections wherever needed for evaluating values and rates for our customers’ orders and suppliers’ productions. Excel allows us to distinguish between the two as well as the many other values that may be involved in the transaction. Errors are easily corrected that may be found after evaluation is nearly complete. The program has been a remarkable system that has enabled us to develop proper skills needed for accurate inventory; however, Microsoft Access appears to be a better target. Microsoft Access is dedicated to the same aspects of Microsoft Excel. Access is recommended because it helps...

Words: 754 - Pages: 4

Premium Essay

Efficiency and Collaration

...Efficiency and Collaboration Proposal Microsoft Excel has been used for many years by Party Plates to store and compile specific personnel data, but it does limit us when it comes to create a relation between the stored data. In reality, Excel is not a database, and its practicality is somewhat limited since Excel is a “flat file database” which means that the data inputted is stored in a single file in the form of rows and columns. There are no relationships or links between records and fields in Excel except for the table structure (Chung, 2013). This is when Access becomes an interesting tool for Party Plates to convert our current data stored in Excel into a relational database. A relational database is able to use data stored in different tables and relate them together in order to easily find specific information. Access also has the advantage of sorting data based on any field and would easily allow Party Plates to generate reports that contain only specific fields from each table. Once we transfer our data to Access, we would be able to add more tables and link them, create queries, share and update between authorized users in the company, and create extensive reports and forms. Microsoft’s Access is a database management tool that stores large volumes of information together. It has many benefits for the work environment. One benefit is that it is user friendly and training does not take an extensive amount of time. It allows you to sort, analyze, summarize and...

Words: 609 - Pages: 3

Premium Essay

How to Use a New Computer Audit to Prevent and Detect Fraud

...computer logic and applied to company data.1 Results of this logic could take the form of a simple matching of the human resource file to the accounts payable vendor master file. On the other side of the coin, it could be an advanced neural network application focused on detecting money laundering schemes. Whether it is simple or advanced, data analysis provides many benefits in the prevention and detection of fraud. On one hand, the fraud examiner gains insight on 100 percent of an organization’s transaction data vs. more limited manual methods of selection. Further, this approach can generally be completed in less time than manual procedures, given the automation of the work. Examiners also gain improved business intelligence as the generated reports often lead to conclusions beyond whether just fraud occurred. Such new insights can lead to suggested process improvements to the client. The Institute of Internal Auditors (IIA) Research Foundation recently announced the posting of a free online document to help fraud examiners worldwide use computers to fight fraud. Proactively Detecting Occupational Fraud Using Computer Audit Reports, written by the author of this article, is designed to assist fraud examiners and management in implementing data analysis...

Words: 2941 - Pages: 12

Premium Essay

New Information System Proposal

...The intent of this proposal is to describe the effectiveness of switching from Microsoft® Excel to Microsoft ® Access and how internal communications will help modernize the sales department. Let me start by saying that Microsoft® Access is a user-friendly tool and is simple to learn. It provides for the easier adding, subtracting, and altering of data, in addition to offering the ability for more than one user to update tables at the same time. By converting the data we currently hold in Microsoft® Excel spreadsheets to Microsoft ®Access, we will be able to track different aspects of our business more effectively. Benefits delivered once data has been entered in Microsoft® Access: • We will also be able to use the reports to drive positive business results. • We will be able to track sales trends by associate. • We will also be able to track the buying patterns of our customers allowing us to stock the appropriate items by sales surges. • Our sales force will be able to use the database to more effectively streamline their work and understand how to be more productive with our customers. Although many of the items listed above are possible in Microsoft® Excel, the data must be inputted to the spreadsheets and work books and can be more difficult to find the information the user is looking for. Access is the better solution for an extensive customer list. In our business of Party Plates there is a need to categorize certain information to create a database that will...

Words: 536 - Pages: 3

Premium Essay

Week 3 Bis 220

...new information systems at Party Plates. We are excited to introduce all the new changes taking place. The sales department is currently using Microsoft Excel but after looking around for something that would suit our needs better we found Microsoft Access. As technology and our business grow we are always looking for ways to improve. We will tell you how switching over to Access will benefit the company. We will also include suggestions for future use of collaborative software and how it can help the sales department improve communications. Stated below are the changes being made. Microsoft Access is a program that is used to store large data. Microsoft Access is very beneficial in the work environment, because of the different features that it offers, and it is easy to learn. The program is user friendly which incorporates other features offered through Microsoft Office. Without sacrificing performance, large amounts of data can be stored into the database. It is very easy to store available information into the database. If your office environment is large , Access may be programmed to retrieve information from the enterprise software. This short document will illustrate the benefits of moving personnel data for Party Plates from Microsoft ® Excel into Microsoft ® Access. Though there are many more reasons to utilize Access or other similar relational database software, we will focus on the personnel data management in particular. The data collected...

Words: 807 - Pages: 4