Preview

Microsoft Office

Better Essays
Open Document
Open Document
1165 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Microsoft Office
MICROSOFT ACCESS

Microsoft Access; History, Flaws, and Uses in Business
PCI 206

MICROSOFT ACCESS
Abstract
Microsoft Access is a database system. Its uses include storing, searching, saving, and linking all sorts of information. It can be used in any type of business either as its own program, or in assistance for a bigger program or bigger business. Like anything, it has its flaws, such as limited capacity, and inferiority to premiere database programs. Access is a program where for a personal user, the sky is the limit, and one shouldn’t be scared of the many things it can do.

MICROSOFT ACCESS
Microsoft Access; History, Flaws, and Uses in Business Microsoft Office Access is a relationship database management system by Microsoft that combines the Microsoft jet database management with graphical user interface and software development tools. It is a common used program in many businesses all around the country. It is a place to manage, store, link, and search for information. It is an easy way for members of a business to sort through hundreds of records. Its history goes as far back as 1982 and is now a member of the Microsoft Office Suite. It is argued by some that Access is not viable enough for bigger corporations, but more for the small and medium business owners. Although the program does have some flaws, Its uses in business overall outweigh the cons. Indeed Microsoft access is a complex program, but that’s because it does complex things. Microsoft Access dates back as far as the early 1980’s. In early development it was referred to as “Project Omega”. This Microsoft’s first attempt to sell a database product. As America entered the 1980’s, computers began to emerge and business started to electronically store their data. It was a very resource demanding application though, and worked slow on the then available processors. After scraping the Omega project, a new project emerged called the “Cirrus Project”. They wanted to create a competitor

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Many employees use Access to work with the city’s database. Several more manage their own…

    • 387 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    MS Access is a database management system design by Microsoft. It offers user four important objects they are:…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Memo Week 3 Dbm 381

    • 329 Words
    • 2 Pages

    This memorandum is created to explain normalization, its level and why it is sufficient for the system. We are all aware that Microsoft Access database is the best fit for the Taylor Ambulance Company. This database will be efficient in storing, tracking and billing incidents. To reduce redundancy in the system, it is important to apply normalization. Normalization is the processes where data are organize in a database. This process includes creating tables and establishing keys and relationships of data between the tables. Normalization will also make the database more flexible, in which redundancy will be reduced and possibly completely eliminate. This will also reduce inconsistence dependency. It will also be faster to create queries between tables after the data is normalize. A non-normalize database is full of redundant data and it is unorganized.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Ilab Instructions

    • 2258 Words
    • 10 Pages

    You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Possessing the right collaborative tools when conducting business is essential; we have been using Microsoft Excel at Party Plates for quite some time now. In the search for a database that will be more compatible to hold and organize the data of the company, the capabilities of Microsoft Access will be what we are looking for. We want to highlight some keys elements that would help us in making that for the future of our business.…

    • 400 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Remember that Access, Excel, and even FrontPage, are all tools. This assignment will help you discover how to use a database tool to support a business. You will be analyzing the data in the database and answering the questions in the exercise to create the queries and reports that are necessary to determine what the Inn’s current business situation is.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Bis245 Ilab

    • 2683 Words
    • 11 Pages

    A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.…

    • 2683 Words
    • 11 Pages
    Satisfactory Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
  • Better Essays

    One key advantage of a database management system is that it is secure. First and foremost on the minds of an organization is security. This type of system is managed through a DA (Database Administrator). This person sets limits on accessibility, which means not all employees, or customers can access all levels of information within the database. The first line of defense is to allow access to a computer only to authorized, trusted users and to authenticate those users by a password or similar mechanism (computer science. (2013). In Encyclopedia Britannica. Retrieved from http://www.britannica.com.libdatab.strayer.edu/EBchecked/topic/130675/computer-science).…

    • 864 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Microsoft Access and Microsoft Excel have many similarities that often times make it hard to decide what program to use. For example, both of the programs have the capabilities to store large amounts of data, run queries and, analysis, and perform complex calculations that return sought-after data. However, by converting data held in Microsoft Excel spreadsheets to Microsoft Access it can be useful for a company because Microsoft Access stores company data in tables that appear to be the same as Microsoft Excel spreadsheets only Microsoft Access is designed for complex querying in relation to data stored in other tables. Additionally, according to Microsoft Office 2012, Access is the best choice when one needs to track and record data regularly, and display, export, or print subsets of that data. Access forms provide a more convenient interface than an Excel worksheet for working with data Using Access or Excel to manage data. Anyone can use Access to automate frequently performed actions, and Access reports let’s one summarize data in printed or electronic form.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Bis 220 Wk 4

    • 526 Words
    • 3 Pages

    Microsoft Access has evolved into very user friendly tool and has become simple to learn. It provides for the easier adding, subtracting, and altering of data once the database. Access offers the ability to construct queries to extract reports from the database to analyze all aspects of the data captured in the database (Grauer, 2011). Whereas this is possible in Excel, it is much more cumbersome. Access also offers the ability for more than one user to update tables at the same time but will not allow for the updating of one record by two individuals at the same time.…

    • 526 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The purpose of this proposal is to show you why improving the efficiency of the current information systems that is being used in the sales department will benefit Party Plates. The sales department is currently using Microsoft Excel and would like to move to another relational database such as Microsoft Access. Team A will be addressing how converting from Excel to Access will help the company, and the advantages of using Access and the disadvantages of using Excel. Team A will also introduce collaborative software and how it is used and what it will do for the company. Team A will also explain how the change will affect the internal communication and how the company can benefit for the change of software.…

    • 828 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Each individual workstation will use Microsoft Windows 7 professional x64 service pack 1 for the operating system. The Main database server will use Microsoft Server 2008 R2 x64 for the operating system. The DBMS that will be used will be Microsoft Office Access. A form will be created to add data to the database and make it easy to retrieve data when needed. Reports can be downloaded and printed to show results of the data base inquiry.…

    • 799 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Overall Microsoft Access will bring tremendous benefits to our company and ease to the workload of our employees. This software will allow an efficient…

    • 317 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Setting Up a Database

    • 2510 Words
    • 11 Pages

    In order to complete my client’s needs I created a database and I started my work with Word Access 2010. This is how it looked at the beginning as I started my work today on the 5th of the October 2010. Today was our starting point for creating my clients database.…

    • 2510 Words
    • 11 Pages
    Powerful Essays