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

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages

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