BTM311 Asgn C: Building a Database using Microsoft Access

BTM311 Asgn C: Building a Database using Microsoft Access: ValueFresh Stores Limited (ValueFresh)

ValueFresh Stores Ltd has been serving the retail shopping needs of rural and small-town communities in British Columbia and Alberta since 1968.  Originally, they provided dry goods to farmers and ranchers, but they expanded to carry a full array of groceries and other items for residential (and some commercial) customers.  Although not as large as “bigbox” stores, they have developed a strong and growing base (20 stores) in small towns by hiring residents to run their stores with a local, community-centered focus. 

“Once we put data into our database, we need to get it out again”, said Miranda Bellows.  “To do this, we need help in converting our business requirements into commands that the database understands.  We need a form to help us capture data about producers and their products, a query that calculates order-stats for selected stores, and a report on discounts-given for non-tax-exempt products.”   

REQUIREMENTS:   Working individually, deliver the following:

A) Build an Access 2016 (or compatible) database of TABLES that match the “ValueFresh_Asgn_C_2022_01_Data_Model” handed out in the Assignments folder on your BTM311 eClass web-site (do NOT use your personal data model that you built in the previous assignment).  In the database, install LOOKUPS on all foreign key fields, so that the database operator can always see a list of correct choices when inputting values.  For all lookups, un-check the “hide key column” box in the lookup wizard. Ensure all relationships from the data model are registered and ensure your relationships still include referential integrity enforcement.  Ensure lookups are functional and helpful (ie. show more than 1 field but no more than four fields).

B) Using Access’s “Get External Data” function, populate your Access tables with all appropriate data from the Excel spreadsheet (“ValueFresh_Asgn_C_2022_01_Data”) handed out in the eClass Assignments folder.  Initially, you may have to reformat and “clean up” the tables by cutting and re-pasting them.  Suggestion: first import rows to the tables that only act as “1” tables in 1-M relationships – then add rows to their “Child” tables, and so on.     

C) Using Access wizards, build a “FORM that contains a sub-form” (based on the Producer and Product tables).  This form should allow staff to enter new Producers, one Producer at a time.  When entering a new Producer, the operator should also be able to enter multiple Products for that Producer.  For each table involved in this form, all attributes should be displayed, and should be operator-enterable.  Ensure your form is fully functional and well designed/laid-out.

D) Use your new “Producer form” to insert at least 2 new Producers, with 3 Products for each (invent your own values).  

E) Build a QUERY that gathers Order-Items for Orders sold from Stores with loading-dock size > 42000.  For each Order, display: its store-id (& store-municipality), member-id (& member-last-name), order-placed-date, cashier number and order id.  Include Orders even if they have no Member (hint: use outer join).  Prepare an extracolumn which calculatesunit price paid * quantity-ordered” (to be summarized later).  Group rows so there is one row per order.  For each order, display: Sum of your above calculated-column (use heading “Total”), Count of the Order-Items (use heading “Order-Lines”), Sum of the quantity-ordered (use heading “Items_Carried”) and Max of the unit-price-paid (use heading “Biggest_Ticket”).  Sort the query by store ID, then by member-id, then by order placed-date, then by order-id (first two ascending & last two descending).  The left-to-right order of columns in query should be appropriate, given the required sort order.  Ensure the query functions correctly, always extracting the correct data in the right format.

F) Build a REPORT (based on a newly created QUERY, not query ‘E’ above) that retrieves all Order-Items for each Product that is not GST-exempt.  Each row of output should include the product-line description, producer-name along with the Product’s id-number, descriptive name and regular-price.  As well, each row should also show the Order-Item’s unit-price-paid, along with an extra column which calculates regular_price – unit_price_paid (use heading “Discount-given”).  Include Product-Lines even if they have no Product, and include Products even if they have no Producer or no Order-Item (hint: use outer joins).  The report’s grouping-levels should be by product-line-description and by producer-name.  The report should be further sorted by product-descriptive-name (ascending).  The left-to-right order of columns in the report should be appropriate, given the required sort order.  Ensure the report is fully functioning, well designed and laid-out, and always reports the correct data.  HINT: do most of this work in your query – then use the query in a report.

G) Deliver the database in one accdb file using the filename stated in the Assignment submission instructions (see eClass Assignments page).  Keep the total size of your database file to less than 25 Mb.  Databases over the limit will be penalized.  Save extra backup copies of your database often.  Submission instructions are provided on the eClass Asgn C page.

Cheating and Plagiarism:

All work is to be done individually.  Do not copy, in whole or in part, the work of others, including paper printouts, electronic files or computer programs.  Do not use the work of others as a starting point and then modify it.  All work submitted under your name must be yours and yours alone. 

The University of Alberta is committed to the highest standards of academic integrity and honesty. Students are expected to be familiar with these standards regarding academic honesty and to uphold the policies of the University in this respect. Students are particularly urged to familiarize themselves with the provisions of the Code of Student Behavior (online at www.ualberta.ca/secretariat/appeals.htm) and avoid any behavior that could potentially result in suspicions of cheating, plagiarism, misrepresentation of facts and/or participation in an offence. Academic dishonesty is a serious offence and can result in suspension or expulsion from the University.

Order Now

Get expert help for BTM311 Asgn C: Building a Database using Microsoft Access and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (September 25, 2022) BTM311 Asgn C: Building a Database using Microsoft Access. Retrieved from https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/.
"BTM311 Asgn C: Building a Database using Microsoft Access." Universal Assignment - September 25, 2022, https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/
Universal Assignment August 22, 2022 BTM311 Asgn C: Building a Database using Microsoft Access., viewed September 25, 2022,<https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/>
Universal Assignment - BTM311 Asgn C: Building a Database using Microsoft Access. [Internet]. [Accessed September 25, 2022]. Available from: https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/
"BTM311 Asgn C: Building a Database using Microsoft Access." Universal Assignment - Accessed September 25, 2022. https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/
"BTM311 Asgn C: Building a Database using Microsoft Access." Universal Assignment [Online]. Available: https://universalassignment.com/btm311-asgn-c-building-a-database-using-microsoft-access/. [Accessed: September 25, 2022]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 45%* OFF on Assignment Help

Popular Assignments

Find the Greatest Ancient History Assignment Help Instantly

Ancient History Assignment Help Benefits Student Performance! Ancient History assignment help uplifts student understanding and interest in the area. Ancient history can often become confusing for students because it involves understanding events that are hardly relatable to us in the present generation! Universal Assignment is the perfect platform for the

Read More »

Australia’s Best Aboriginal Studies Assignment Help Online

Upgrade your knowledge with the best Experts:  Quick Aboriginal Studies Assignment Help The world’s most rich research on Aboriginal studies takes place at the top educational institutions in Australia. This field involves rich socio-historical research on the Aboriginal indigenous community of Australia. Aboriginal Studies assignment help online can help students

Read More »

Physical Education Assignment Help: Expert Guidance to Boost your Career

Order Physical Education Assignment Help Instantly! Are you a Physical Education student, struggling to submit assignments on time? Universal Assignment Help Service is the perfect place for all your solutions. With expert guidance available from the best professionals, all your assignments will be top-quality. Physical Education involves a strict and

Read More »

Assignment Help in South Africa

5 Ways to Make Your Assignments Error-Free Assignments are a crucial part of every student’s life as they help them to enhance knowledge about the subjects and also improve academic grades, writing skills, time management skills, research skills, etc. Usually, due to internships, part-time jobs, and other co-curricular activities, students

Read More »

Instant Engineering Assignment Help in Ukraine

Engineering is a vast field of study that consists of several branches. While studying various branches of engineering in the best Ukraine universities, students are required to compose several types of assignments to improve their academic scores. There are many different reasons due to why students seek engineering assignment help

Read More »

[SOLVED] AHS205: The Australian Healthcare System within a Global Context

AHS205: The Australian Healthcare System within a Global Context Part A 1. Healthcare professionals include registered nurses, physicians, dentists, physician assistants, and veterinarians. Registered nurse: The key function which the nurses play in treating the patient with depression include monitoring the clinical progress, improving the compliances of treatment, assessment for

Read More »

[SOLVED] Assignment: Pressure ulcer in ICU in UK

1- Critique different types of evidence ( the area I’ve chosen is pressure ulcer in ICU)2- Analyse what constitutes Best Evidence for practice in the UK3- Critically reflect on the BENEFITS and LIMITATIONS of evidence based practice (EBP) within nursing practice. Using Randomised Controlled Trial (RCT)Student will critique a qualitative

Read More »

[SOLVED] Assignment The lasting negative impact of Colonialism within contemporary Indian Economy and Industry

The lasting negative impact of Colonialism within contemporary Indian Economy and Industry Famine in India and colonialism During the period of colonialism, root causes of famine within India include government policies, population imbalance, crop failure, inflation and war. Increased mortality, epidemic, starvation and regional malnutrition follow and accompany famine within

Read More »

[SOLVED] OSQs: The Psychology of Competition: A Social Comparison Perspective

The Psychology of Competition: A Social Comparison Perspective OSQs Outlines Competitiveness and Social Comparison – The passage is all about reducing differences in the society and developing factors to do social comparison – Situational and individual factors have been highlighted to increase competitiveness The framework highlighting situational and individual factors

Read More »

 [SOLVED] Letter of advice 5126LAW: ASSESSMENT ITEM 3

Law Letter of Advice 25 January 2022 Ms. Amelia Hart 4 Cornet Street, Yeronga Re: Domestic Violence and parenting matter- Hart & Hart Dear Amelia, We do confirm that we have been asked to provide you with advice regarding the parenting and domestic violence matter during the appointment on 24

Read More »

5126LAW: ASSESSMENT ITEM 3  Letter of Advice Problem

5126LAW: ASSESSMENT ITEM 3  Information about this assignment:  This assessment piece requires you to prepare:  1. An initial letter of advice;  2. A draft Application for a Protection Order (Form DV1); and  3. Draft Written Submissions.  Initial letter of advice  Ensure that the initial letter of advice is addressed to

Read More »

HC1021 INTERPERSONAL AND E-COMMUNICATION Assignment T3 [SOLVED]

Student Number: (enter on the line below) Student Name: (enter on the line below) HC1021INTERPERSONAL AND E-COMMUniCATION final assessmeNt Trimester 3, 2021 Assessment Weight: 50 total marks Instructions: All questions must be answered by using the answer boxes provided in this paper. Completed answers must be submitted to Blackboard by

Read More »

COMM1001 Communication in Organisations

Assessment 4 – Written report (1200 Words) 50% Due Week 14 – By 5pm Friday Sept 27th Your full recorded interview from Assessment 3, becomes the basis of your report for Assessment 4 Drawing on the content from your interview and the academic literature related to the three communication topics

Read More »

MBA703 – The Economic Environment – Trimester 2 2022 Assessment Task 2

DUE DATE AND TIME:                        Friday, 23 September 2022, by 8:00pm (AEST) PERCENTAGE OF FINAL GRADE:                                                            40% WORD COUNT:                                   2000 words Description This assignment is based on an article published in the AFR titled “Australia must have a new macroeconomic framework”. Please read the article and answer the following questions (using

Read More »

IT510 Systems Analysis and Design Module Preview

This guide contains a preview of the materials for all module courses in this series: IT510M1: Systems Planning, Analysis, and Logic Processes IT510M2: Data Organization Process IT510M3: System Physical Attributes IT510M4: Written Proposals for System Analysis and Design Be sure to follow the detailed directions found within the actual module

Read More »

BULAW5915 Assignment

Information about the Assignment:   Due date   Sunday, 23:59, 18 September 2022 (Week 9) How to submit   The assignment must be submitted in word format through the submission link on Moodle.   Topics covered by Assignment Topic 4   Maximum word limit   2500 words   Total marks

Read More »

Biomedical Physiology and Engineering assignment

Stent grafts for coronary arteries were first used in the mid 1980’s.  I want you to review the developments in stent graft technology since that time and discuss the natural response of the body to angioplasty and stent placement and how biomedical engineers have responded to the adverse events encountered

Read More »

NRSG374 Assessment Task 1, 2022

ASSESSMENT TASK 1 Professional Development Resource: Narrated PowerPoint Due date: Thursday 15th September 2022 at 4pm Weighting: 50% Length and/or format: Narrated PowerPoint equivalent to 1500 Words +/- 10%8-10 Slides Including Title Page and ReferencesDiagrams and images can be used please include references as per APA7No longer than 8 mins

Read More »

2110AFE – PROBLEM-SOLVING ASSIGNMENT (T 2, 2022)

WEIGHT:          This assessment is worth 30% of the total marks for this course. WORD LIMIT: Your answer to Question 1 (Hypothetical ILAC Question) must be no longer than 1000 words. Your answer to Question 2 & 3 must be no longer than 1000 words. INSTRUCTIONS TO STUDENTS: Students may refer

Read More »

HRM 4801 Managing and Developing People

The following table provides an example of the overview of the assessment requirements. Assessment 1 : Individual reflexive review The following table provides an overview of the assessment requirements. Assignment brief : Individual reflexive review Module code HRM 4801 Module title Managing and Developing People Submission date, time 01.12.2020 :

Read More »

BUS4023 BUSINESS ETHICS

Course/ Module: BUSINESS ETHICS SEGI Course Code: BUS4023 UCLAN Module Code: (if applicable) Lecturer name: William Tan Coursework Submission Date:                         Individual Assessment 1: Week 7 Individual Assessment 2: Week 9 ASSESSMENT METHODS Number of Assessments Form of Assessment     % weighting Size of Assessment/Duration/ Word count Category of

Read More »

Human Subjects Case Studies

Case Study 1 – Research involving adults with terminal illness Dr. Abbott, an oncologist at a major teaching hospital, has been asked to put forward a number of her patients for participation in a clinical trial of a new cancer treatment. Mr. Day is a terminally ill patient with a

Read More »

BA Stage 3 Level 7 Special Education and Differentiation

Assignment Brief and Marking Scheme Programme: Module: Semester: Date of Title Issue: Assignment Deadline: Assignment Submission Details:   Module Credits: Weighting for this Assignment: BA Stage 3 Level 7 Special Education and Differentiation 1 05/10/20 26/11/20 Submit both the essay and the completed IEP in electronic format (PDF) to Moodle.

Read More »

PART II: Media Analysis and Reflection Submission

Students are also required to submit a Media Analysis and Reflection in relation to the media segment (see below) for the Media Discussion Forum. In approximately 350 to 500 words, please expand the synopsis you have provided as a Leader on the Discussion Forum. In this expanded version, you should

Read More »

Philosophy227 Take Home Essay Questions

Philosophy227 Take Home Essay Questions Carel argues that one can be happy – that one’s life can be meaningful – even if one is terminally ill. What is her argument? Do you agree? Is death harmful? Articulate a reason for thinking that death is harmful. Identity an argument against the

Read More »

General Psychology Assignment

Question Mark Travers in his article posted by Psychology Today dated 8th Sept, 2020 posed a question; “Are dating apps a breeding ground for dark personality?” in which new research suggests that the answer is likely yes (Johannes Kepler University). Dark personality triad comprises personality traits of Narcissism, Machiavellianism and

Read More »

Portfolio Planning Tool

Planning for a Target Position: Use this sheet to identify your Key Skill Areas. Add more Key Skill Areas or additional rows if needed.  Within each key skill area, indicate your skills, knowledge, and abilities along with the work samples/evidence you have to prove it, the skill type, source and

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?