Question Details

(Solved) Assignment 1: Using a Database for Strategic Business Development Please remember that Excel is not database software and cannot be used as a...


Assignment 1: Using a Database for Strategic Business Development

Please remember that Excel is not database software and cannot be used as a substitute for Access

Read the Hands-on MIS project Improving Decision Making: Using a Database to Clarify Business Strategy on pages 92–93 of the textbook carefully, follow all instructions, and answer all questions.

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.

NOTE: The Access e-text authors advocate using Calculated Data Fields in Access 2010. While these do solve many of the problems that used to exist with calculated fields (because Access does the calculation automatically for you), for this assignment, do NOT use the Calculated Data Field functionality.

Instructions:

Download the 2007 Access database file. If the data file doesn’t open, check your browser’s pop-up blocker settings or try holding down the Ctrl key when clicking the file.

Assignment 1 Access 2007 Database

(Note: If you have an older version of Access and are unable to open the data file above, try this one: Assignment_1_Database.mdb)

After you have downloaded and opened the file, click FILE→ SAVE AS→, then SAVE the file to your hard drive according to the following assignment naming standards:

yourlastname_CMIS351_assign1.mdb

OR 

yourlastname_CMIS351_assign1.accdb (depending on the file format default of your version of Access)


Once the file has been saved, you can open it and start working on your assignment.

Analyze the data in the database and in the application exercise.

To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).

Create queries and reports that will provide information to help management at the Queen’s Inn to be more competitive and profitable. If you look at the original database you downloaded, you will see that it provides suggestions for the three reports that should be created for The Queen’s Inn. These empty templates will give you an indication of what queries and reports you must create for this assignment.

If you need a refresher on using Access databases, see the resources on the Important Information about Database Assignments page.

Write a brief report (1-2 pages) describing what database information (from your analysis) would make the business more competitive and profitable. Your report must include, at a minimum, answers to the four questions in the second last paragraph of the exercise on page 93 of the textbook.

For this assignment you must hand in:

an Access database with reports and queries as described above (the number of queries and reports will be up to you)

you must also submit a Word document containing a report as described in the assignment instructions on page 93.

Marking criteria:

You will be marked according to the following criteria.

Database

4 marks

implemented correctly

queries are correct

Reports

3 marks

provide required information

comprehensive

readable (accurate spelling and grammar)

Written report

3 marks

professional, business-like

relevant

correct (covers required information)

When your assignment is complete, return to this page and follow the instructions for submitting it.

Assignment 1: Using a Database for Strategic
Business Development
Please remember that Excel is not database software and
cannot be used as a substitute for Access
Read the Hands-on MIS project Improving Decision Making:
Using a Database to Clarify Business Strategy on pages 92–
93 of the textbook carefully, follow all instructions, and answer
all questions.
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.
NOTE: The Access e-text authors advocate using Calculated Data
Fields in Access 2010. While these do solve many of the
problems that used to exist with calculated fields (because
Access does the calculation automatically for you), for this
assignment, do NOT use the Calculated Data Field functionality.
• Instructions:
Download the 2007 Access database file. If the data file doesn’t
open, check your browser’s pop-up blocker settings or try holding
down the Ctrl key when clicking the file. •
•
•
• • • •
• Assignment 1 Access 2007 Database
(Note: If you have an older version of Access and are unable to
open the data file above, try this one:
Assignment_1_Database.mdb)
After you have downloaded and opened the file, click FILE→
SAVE AS→, then SAVE the file to your hard drive according to
the following assignment naming standards:
yourlastname_CMIS351_assign1.mdb
OR yourlastname_CMIS351_assign1.accdb (depending on the file
format default of your version of Access)
Once the file has been saved, you can open it and start working
on your assignment. •
•
•
•
• Analyze the data in the database and in the application exercise.
To complete this assignment, you will need to do data
calculations. Remember to follow good database practice here by
not saving your calculations as part of the data table itself (they
should appear only in your queries). •
• Create queries and reports that will provide information to help
management at the Queen’s Inn to be more competitive and
profitable. If you look at the original database you downloaded,
you will see that it provides suggestions for the three reports that
should be created for The Queen’s Inn. These empty templates
will give you an indication of what queries and reports you must
create for this assignment. •
•
• • If you need a refresher on using Access databases, see the
resources on the Important Information about Database
Assignments page.
Write a brief report (1-2 pages) describing what database
information (from your analysis) would make the business more
competitive and profitable. Your report must include, at a
minimum, answers to the four questions in the second last
paragraph of the exercise on page 93 of the textbook.
For this assignment you must hand in:
an Access database with reports and queries as described above (the number of queries and reports will be up to you)
you must also submit a Word document containing a report
as described in the assignment instructions on page 93.
Marking criteria:
You will be marked according to the following criteria.
Database 4 marks implemented correctly
queries are correct
Reports 3 marks provide required information
comprehensive
readable (accurate spelling and grammar)
Written report 3 marks professional, business-like
relevant
correct (covers required information)
When your assignment is complete, return to this page and follow
the instructions for submitting it.

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200028271.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now