Access Help

I have an” access” assignment with all the instructions. I will attach the document and instructions. Just follow the instructions.

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Access Help
Just from $13/Page
Order Essay

MIS303 Assignment #6 Microsoft Access Assignment
Note (Important):
(1) This is an individual assignment. It accounts for 10% of your grade.
(2) Due Date: April 19th, 2018 Thursday 7:20:59pm
(3) Your final solution should be ONE Microsoft Access 2016 file (.accdb file) that is submitted
via Blackboard. Make sure that you submit the actual Access file rather than the temporary
lock file that I will not be able to open. Otherwise, you will get a 0 grade.
(4) Pay attention to details: all questions are detail-oriented. Make sure you read the instruction
word by word carefully. Otherwise, you might lose points for failing to fulfill any of the
clearly specified requirements.
(5) You may want to submit your solution at least 30 minutes before the deadline. Make sure you
click “Submit” rather than “Save Draft” to actually submit. You are required to double-check
your submission by downloading it and opening it to see if it is your final version. You will
be responsible for any technical difficulty or mistake on your side that results in submitting
the wrong work or your work not being submitted or being accepted as late. No exceptions
will be made.
(6) Make good use of the tutorial for the in-class exercise. If you forget about some of the skills
we have covered in class, you can always refer to the tutorial posted on Blackboard which
documents every step we have done for the in-class exercise.
Assignment #6: Microsoft Access (Total: 50 pts + 2 optional bonus pts)
To facilitate product innovation and support the company’s differentiation’s strategy, BoardStar
Inc. plans to implement a new online crowdsourcing platform to gather new product ideas from
BoardStar’s customers and fans. You have been hired by BoardStar Inc. and asked to use your
database skills to help with the design and development of the database required for the online
crowdsourcing platform.
The database must keep track of each user who participates in the crowdsourcing platform,
including their unique user ID, first name, last name, email address (that is required to register
for an account on the platform), and phone number. The database should also record information
of each new product idea proposed by the users, including its unique idea ID, product name,
product description, the date the idea was proposed, and the ID of the user who proposed the
idea. In order to understand which new product ideas should be chosen and implemented,
BoardStar adopts two mechanisms to pick the best ideas among all the proposed. The first
mechanism is to ask online users to anonymously vote on all the proposed ideas. All the votes on
a proposed idea are saved in the database. This crowd vote information, including the unique
vote ID, the ID of the idea being voted, the date the vote was cast, the value of the vote (which is
1 if the voter likes the idea and votes it up, or -1 if the voter dislikes the idea and votes it down,
or 0 if the voter is neutral about the proposed new product idea), and the voter’s willingness-topay (short as WTP, i.e., the price the voter is willing to pay for the proposed new product if it is
implemented), is kept in the database. The second mechanism is to ask a panel of internal experts
to pick ideas. The panel of experts first screen all the proposed ideas to identify promising ones.
They then perform a detailed evaluation of the selected ideas. For each promising idea, each
expert independently evaluates its production and financial feasibility. Information regarding
each expert’s evaluation of an idea, including the unique evaluation ID, the ID of the idea being
Page 1 of 4
MIS303 Assignment #6 Microsoft Access Assignment
evaluated, various evaluation items such as the estimated date when the production of the new
proposed product can start, the estimated date when the proposed product can be released on the
market for sale, the estimated production cost per unit of the proposed product, the estimated
consumer demand (in number of units) for the proposed product, and the suggested retail price
per unit for the proposed product, is also kept in the database.
Each user participating in the online crowdsourcing platform may propose multiple new product
ideas or may not propose any idea, but each particular idea is proposed by one and only one user.
Each new product idea may receive multiple crowd votes by the users or may not be voted by
any user at all, but each particular crowd vote record corresponds to one and only one idea. A
new product idea may not pass the screening stage and therefore may not be chosen by the panel
of experts to conduct a detailed expert evaluation. But once an idea is marked by the panel of
experts as promising (i.e., passes the screening stage), it receives multiple evaluations from all
the experts as each expert performs their independent assessments of the idea. Each expert
evaluation record is about one and only one product idea.
In the first task, you have created the E-R diagram for the database. In the second task, you have
created the database using Microsoft Access 2016 and entered data into the database.
Now your third task is to create queries and reports for BoardStar to make business decisions. If
you are unsure about the meaning of an attribute, you should go to the design view of the table
and read the description of the attribute.
Q0. Download the database (BoardStar.accdb) from Blackboard. Rename it exactly as your last
name followed by your G number without “G” and then followed by suffix
“_assignment_6” (there should not be extra spaces or underlines in between; e.g.
Ye12345678_assignment_6.accdb with .accdb being the file extension). You will work on
Q1-Q8 on this Access database and then submit it via Blackboard. (1 pts)
Q1. For a good proposed idea, sometimes BoardStar needs to call the user who proposed the
idea for clarification and further discussion. Create a query named Q1_User Missing Phone
using data from the User table to list users whose phone number is missing. Include the
user’s ID, first name, last name, and email address in the results. Do NOT include phone
number. Sort the results by user last name in the descending order. (5 pts)
Q2. BoardStar wants to filter out the positive votes for proposed ideas. Create a query named
Q2_Up Votes using data from the CrowdVote table and the Idea Table to list all votes that
are favorable to proposed ideas (i.e., the voter votes the idea up — the VoteValue is
positive). Include the voteID, idea ID, product name, VoteDate, and VoteValue in the
results. Sort the results by idea ID in the ascending order. (5 pts)
Q3. BoardStar does not want to develop new product whose time-to-market is more than 90
days. For this purpose, BoardStar wants to first find out which new product idea has the risk
of having more than 90 days of time-to-market based on expert evaluation. Estimated timeto-market is measured as how long it takes the product to be delivered to the market, which
should be the interval in days between ProductionDate and SaleDate. Create a query named
Q3_Time-to-Market Risk using data from the ExpertEvaluation table to list all the expert
evaluation records whose estimated time-to-market of a product idea is greater than 90 days.
Include EvaluationID, idea ID, and estimated time-to-market in the query. Sort the results
by estimated time-to-market in the descending order. (6 pts)
Page 2 of 4
MIS303 Assignment #6 Microsoft Access Assignment
Q4. BoardStar wants to know each expert’s estimated profit of ideas that have passed the
screening. Create a query named Q4_Profit Estimation using data from the
ExpertEvaluation table to achieve this goal. Include EvaluationID and idea ID in the query.
Then add a field Estimated Sales to compute the estimated sales, and a field Estimated
Cost to compute estimated cost. Finally, add a field Estimated Profit to compute the profit
from selling the product. Sort the results by IdeaID in the descending order. (8 pts)
Q5. BoardStar wants to know the expected time-to-market and profit of ideas chosen by experts.
Create a query named Q5_Product Expectation Summary using data from the
ExpertEvaluation table and the Idea table to achieve this goal. The expected time-to-market
of a product idea is the average of all time-to-market estimates (refer to Q3 for calculation
of estimated time-to-market) of the same idea by different experts, and the expected profit of
a product idea is the average of all profit estimates of the same idea by different experts.
Include idea ID, user ID, product name, expected time-to-market, and expected profit in the
results. Sort the results by expected profit in the descending order. Make sure that all the
column labels in the query results are informative and easy to understand. Hint: choose the
appropriate functions in the Total field (e.g., use “Avg” to do average). (10 pts)
Q6. BoardStar wants to know which new product ideas are favored most by the users. Create a
query named Q6_Crowd Vote Summary using data from the CrowdVote table and the
Idea table to rank the product ideas based on crowd voting. Include idea ID, product name,
number of received votes, and aggregate vote value in the result. For a given product idea,
number of received votes is the count of votes received for the idea, and aggregate vote
value is the sum of all vote values. Sort the results by aggregate vote value in the descending
order so that the manager knows what the most favored product by the crowd is. Make sure
that all the column labels in the query results are informative and easy to understand. Hint:
choose the appropriate functions in the Total field. (10 pts)
Q7. Create a report named Q7_Profit Estimation Report to display the results of query in Q4
for BoardStar. Include an appropriate title for the report. Include in the report IdeaID,
EvaluationID, Estimated Sales, and Estimated Profit. Sort the results by IdeaID in the
ascending order first and then by Estimated Profit in the descending order without any
grouping. All columns should be left-aligned. Make sure that each title/field is sufficiently
wide that the data will not be shown as “####” and the label for each column will be fully
shown. Hint: your report should look like below: (5 pts)
Page 3 of 4
MIS303 Assignment #6 Microsoft Access Assignment
Q8. (Optional bonus question: not required) BoardStar wants to recognize the MVP user who
would bring the most value (i.e., the most total expected profit from selling the products that
are proposed by the user and meanwhile chosen by the experts). As explained in Q5, the
expected profit of a product idea is the average of all profit estimates of the idea by different
experts. The value of a user (i.e., user value) is the sum of expected profits of all expertchosen product ideas proposed by the user. Include the user’s UserID, first name, last name,
number of expert-chosen ideas proposed by the user, and user value in this query. Name this
query Q8_User Value. Sort the query results properly. You need to figure out what tables
are needed for designing this query. Hint: you may manually examine the data in the tables
to figure out what the results should look like and then compare it with your query results to
tell if the query is correct or not; Also, remember that when a complicated query cannot be
achieved in one step, you can create an intermediate query first and then build a final query
that utilizes the intermediate query. (2 optional bonus pts: no partial credit)
Page 4 of 4

Purchase answer to see full

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.


Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.


Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.


Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15