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

  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    cis3730_Exam1_Studyguide

    • 512 Words
    • 2 Pages

    You will be asked to write SQL scripts to display required information, like we did in the homework.…

    • 512 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

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

    • 454 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    u1 assessment

    • 3816 Words
    • 17 Pages

    The first thing you need to do is save a copy of this document, either onto your computer or a USB drive…

    • 3816 Words
    • 17 Pages
    Good Essays
  • Better Essays

    Microsoft Access Exercise

    • 1624 Words
    • 7 Pages

    Microsoft Access provides many functions for end users. While working in IT Support, many different situations may present from customers phoning in and requesting information or assistance. Following are three different situations that may be presented at a support desk. First, we will examine a veterinarian who wants to use Microsoft® Access® for his business, and has some questions regarding the functions of Access. Second, a man created a database to inventory his customers’ past due accounts to ensure that he receives payment. Third, a user has been using a Microsoft® Access® database and queries to track her commemorative plate collection. She recently discovered each plate has a serial number, and after adding the serial number to the database, her queries did not function the same.…

    • 1624 Words
    • 7 Pages
    Better 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
  • 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

    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
  • 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
  • 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
  • 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