Preview

Athabasca Assignment

Good Essays
Open Document
Open Document
837 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Athabasca Assignment
Assignment 1: Using a Database for Strategic Business Development
Assignment 1 is worth 5 percent of your final grade for this course. Answer all questions in the Hands-on MIS project “Improving Decision Making: Using a Database to Clarify Business Strategy” on pages 92–93 of the textbook. Read the assignment instructions in the textbook carefully and follow all instructions.
Background:
Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.

For this assignment, you will be analyzing the data in a simple, one-table database by creating queries and reports in Microsoft Access. The system you are “developing” will be used by The Queen’s Inn in St. John’s, Newfoundland for strategic business development purposes.

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.
Instructions:
* If you have not yet set up your access to MyMISLab, go to the Learning Materials page for the proper steps and codes. It is vital that you set up MyMISLab correctly to ensure you have access to the resources for CMIS 351. * Go to MyMISLab and download the Exercise Data File: MIS11ch03 for this assignment from the Assignment 1 folder (after logging in, click Course Content, choose View All Content, then scroll

You May Also Find These Documents Helpful

  • Satisfactory Essays

    In this document of BCOM 230 Week 5 Individual Assignment you will find the next information:…

    • 454 Words
    • 3 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

    To create the database I will first have to create a plan of how many tables to put into it e.g. a staff table, staff roster, Product table, Order Table, Rental Table, and Supplier Table. In laying out the plan for this assignment I had to decide what tables would have a…

    • 1737 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Access & Excel. The purpose of this assignment is to test the students’ ability in operating and managing business data…

    • 3101 Words
    • 12 Pages
    Good Essays
  • Good Essays

    Team “C” would like to propose a convenient and efficient system that will allow the company to function in a more proficient manner. The purpose of this proposal is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team C will demonstrate this by 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.…

    • 828 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Microsoft Access Exercise

    • 1624 Words
    • 7 Pages

    In the first situation, a veterinarian has experienced tremendous growth within his business. All animal records are shelved in folders and are sorted alphabetically by the owner’s name. He is ready to rid himself of the time and space these files take and has inquired about Microsoft® Access®. He wants to know about the key functions of using Microsoft® Access® and how a table, query, primary key, and a report are important to his database needs. Some of the key functions of using Microsoft Access are tables, queries, records, relationships, and reports (Shelly, Cashman, & Vermaat, 2007). The records for each animal can be stored in a database. A database is files in which you store data and include all the major key functions related to the stored data; including functions you define to automate the use of your data (Shelly, Cashman, & Vermaat, 2007). When creating the database for the veterinarian business in Microsoft Access, the database needs to contain at least one table and can contain many different tables. According to Shelly, Cashman, and…

    • 1624 Words
    • 7 Pages
    Better Essays
  • Powerful Essays

    The Company is seeking to have a database that will accommodate and sustain its business operations as it continues with the expansion plan. The existing database system is restricted in the functionalities linked to business reporting and intelligence. Tour Operator should change some of the issues such as eliminating the redundant data. The data integrity rules should be followed in the normalization process. The removal…

    • 948 Words
    • 4 Pages
    Powerful Essays
  • Best Essays

    to our manual online or by keeping it on your computer system, you have hassle-free answers with…

    • 1527 Words
    • 6 Pages
    Best Essays
  • Good Essays

    2.5 Database Analysis

    • 823 Words
    • 4 Pages

    A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Databases in particular can form a key part of an information management plan which can support researchers and facilitate data management throughout the research lifecycle. Database technology can assist data at the collection stage by providing customized ways to input data, and the ability to do so from different locations such as five different accommodations in the research. Also the database design would need separate database tables to cater for five accommodation. The access to the data can be developed by better and more flexible ways of searching. The Database will create and show the relationship between the different tables.…

    • 823 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    My Personal Life Planing

    • 9542 Words
    • 39 Pages

    [pic] Getting Started with Access 2007 This document gives an introduction to Microsoft Access— the Relational Database Management System John Davies, Phil Marshall & Brenda Lowndes January 2008 Document 094 Computing Services Department Contents 1 Introduction 2 Fundamentals 2 System Requirements 2 Data Types Supported by Access 2 Restrictions Imposed by Access 2 2 Running Access 2 Help 2 Creating a New Database 2 Opening an Existing Database 2 Creating Tables within a Database 2 Field Properties 2 Indexes 2 Table Properties 2 Saving and Naming a Table 2 Modifying the Structure of a Table 2 Viewing Data 2 Sorting 2 Finding a Record in a Table 2 Special Characters (Wild cards) 2 Inserting, Deleting and Modifying Data 2 Using Existing Data 2 Exporting to Other Systems 2 Queries 2…

    • 9542 Words
    • 39 Pages
    Powerful Essays
  • Better Essays

    Database Software

    • 1270 Words
    • 4 Pages

    The acquisition of database software for business information management is a source of business leverage in the ever competitive business environment. The management of business information is made possible by the acquisition of efficient database software. Database software is the term that refers to the computer program that helps to enter, update, organize, retrieve, and report information held in a computer database. Among the commonly used database software for personal computers and server database include Microsoft Access, Open Office Base, Filemaker Pro, MySQL, and Oracle. The benefits of using computer-based database are considerable. Without database software, it would be difficult to find a respectable system of managing information. Companies have varied use of comprehensive and accurate databases. Businesses maintain databases of customers, vendors, supplies, inventories, service requests, product orders and employees. Database software that assists a business to handle important function of a data type and provide appropriate data analysis methods is an essential tool of management. Their user-friendliness and flexibility has made database software crucial business component (Ambler, 2012).…

    • 1270 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Assignment01

    • 591 Words
    • 2 Pages

    If you wish to have further background, reread the material in this chapter of the text.…

    • 591 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    ba125

    • 381 Words
    • 2 Pages

    Part III: Reference: Shelly, Cashman, and Vermaat,(2010). Database Management Essential Concepts and Techniques in Microsoft Access 2007, Philippine edition.…

    • 381 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Driver

    • 3248 Words
    • 13 Pages

    This report is submitted in partial fulfillment of the requirements for the Bachelor of Computer Science (Database Management)…

    • 3248 Words
    • 13 Pages
    Powerful Essays
  • Powerful Essays

    To create tables in a database, forms to enter data into the tables and a variety of queries to be performed based on the table.…

    • 2860 Words
    • 11 Pages
    Powerful Essays