关键词 > BSYS501
BSYS501 Semester 1, 2024 Assessment 1: Part B
发布时间：2024-05-29
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
BSYS501
Semester 1, 2024
Assessment 1: Part B
Task Overview
As an owner of the First-Travel company, you would like to use the database to help you manage different types of data in your travel agency operations. You have a strong belief that having a good design of a relational database with different tables, fields, and primary keys is an important first step. Using the following dataset you want to create tables, relationships among tables, forms, queries and reports in Microsoft Access.
Please make sure you download " BSYS501-Assessment1B.xlsx" dataset for the assessment. Do not use the workshop dataset for the assessment.
Use the following instructions carefully to complete the assignment and upload your MS Access solution file on Canvas.
|
S. No. |
Tasks |
Pts (100) |
|
Tables |
||
|
1 |
Import the given data set including all four tables (PACKAGE, CUSTOMER, SALES REP and SALES TRANSACTION). |
20 pts |
|
2 |
Ensure each table has an appropriate primary key. |
4 pts |
|
3 |
Ensure each table has appropriate data types for all fields. |
4 pts |
|
4 |
Create a Combo Box for entering data for the fields related to Payment Type. |
4 pts |
|
5 |
Create the following relationships among all the tables. between CUSTOMESR and SALES TRANSACTIONS between PACKAGE and SALES TRANSACTIONS between SALE REP and SALES TRANSACTIONS Make sure referential integrity is maintained for all relationships. |
10 pts |
|
Forms |
||
|
6 |
Create a split form for the SALES REP table that includes all fields. |
5 pts |
|
7 |
Create three buttons for the Sales Rep Form: - “Add” (add a new record) - “Save” (save a new record) - “Delete” (delete an existing record) Make sure all the buttons behave according to their corresponding actions. |
9 pts |
|
8 |
Apply formatting (at least two features) to modify this form to enhance its visual appearance. Save the form as ‘Sales Rep Form’ . |
4 pts |
|
Query |
||
|
|
Create a query that count of the number of packages sold by each rep. The query result should display: - Number of packages sold - Sales Rep ID Number - First Name, and Last Name of Rep - Ensure to add a meaningful column caption, where applicable). - Save the query as ‘Sales Transaction Query’ . |
20 pts |
|
Report |
||
|
|
Use the Report Wizard tool to create a report from the CUSTOMER, SALES REP, PACKAGE and SALES TRANSACTIONS tables. Your report needs to meet the following criteria: - You only need to display the following columns: Sales Rep’s First Name, Last Name, Transaction Date, Customer’s Country, Package Price and Package Name. - Use customer Country field as a grouping level for the report. - Save the report as ‘Sales Rep Report’ . - Preview the report to make sure that it looks professional and readable. |
20 pts |
Course Learning Outcome Assessed
ü Use business analytical tools to generate insights for decision making.
Time Commitment
- Around 10 hours for the self-study of the material related to Assignment 1 and around 5 hours to complete the assignment.
Suggested Procedures
- In order to be able to successfully complete the assignment, you should attend all the weekly workshops.
Marking and Feedback
- The penalty for late submission will be a reduction by 5% or one grade (e.g. B+ to B) per day up to a maximum of five days. An assessment item will not be marked if it is more than five days late.
Submission Information
- Save your work using the following format: Lastname_Firstname_StreamNo.accdb
- Submit your assignment files on Canvas in the link given below.
- Due date: 10 May 2024 at 23:59
