ASSIGNMENT GUIDEBOOK – MGTS7202
SEMESTER one particular, 2015
Meters ICROSOFT Um FFICE 2013 – A CCESS & E XCEL
UQ W USINESS S i9000 CHOOL Meters ERCHANDISE H TORE
PARTICULAR DATE 10: 00 Friday, 05 June 2015
DELIVERABLES 1 . One electronic digital file has to be submitted with the Blackboard Project Submission Tool consisting of a ZERO archive that contain:
a. an Access Repository,
b. a great Excel Workbook,
c. two PDF reviews.
2 . A great assignment coversheet must be submitted to the BEL Faculty Collaborative Learning Hub.
This assignment is designed to help pupils learn the technology aspects of Organization Information Devices in general. Through this assignment, students is going to gain hands-on experience with software applications essential for their future work.
This assignment requires the creation of your interactive software using Microsoft company Office 2013, in particular Ms Access & Excel. The purpose of this project is to test out the students' ability in operating and managing business data in both Get databases and Excel spreadsheets. Through the tutorials, student will be taught the basic skills to complete this kind of assignment, and provided with sensible exercises a lot like those inside the assignment. Therefore , it is essential that students go to each tutorial in order to be able to successful total the assignment. The project is worth 25% of your total grade achievable in this program. This is a person assignment and MUST be done simply by each college student.
The Access database and Excel design of the anticipated worksheets can be obtained on the MGTS7202 Blackboard web page. The Excel template must be used as the basis for your workbook. You may modify its image formatting (colours, fonts, and so forth ) to provide a professional completed product.
The assignment requires no before technical qualifications. Moreover, it truly is designed for business students in general to appreciate simple IS applications. Prior understanding of the software tools could be helpful, but will not guarantee a significant advantage or higher marks.
This kind of assignment needs you to total an Access database document using Microsoft Access 2013 and a workbook employing Microsoft Surpass 2013 depending on the specification in this record: -
The Access databases file ought to contain the essential forms, inquiries, and studies you designed. The Surpass workbook will need to use the info generated coming from Access questions. You must incorporate appropriate formulae and capabilities required to build the workbook in such a way that the formulae and functions are fully adaptable and dynamic.
CASE BACKGROUND AND SCENARIO
The University of Queensland Organization School Items Store, among the important brances of advertising the image of UQ Organization School, has been dedicated to providing first-class products with the UQBS icon. The items cover many different categories, electronic. g. bags, pants, short circuits, clocks, and so forth
VERSION: 4 FEBRUARY 2015
PAGE | 1
ASSIGNMENT GUIDE – MGTS7202
SESSION 1, 2015
To assist the officer of UQBS's Items Store in managing the store and making business decisions, you are required to take care of the store's database and create a workbook that will allow him to record the staff/product information, examine sales overall performance, as well as producing strategic decisions (e. g. free surprise distribution). A great access repository and one workbook template have been presented on the program Blackboard site. The specific responsibilities are described below.
MS ACCESS DATA SOURCE CONTENT
You have been provided with a Microsoft Access 2013 Database made up of seven dining tables. You will need to utilize data during these tables to do the under tasks. Moreover to these duties you will need to build a number of queries as described in the relevant section of the MS Exceed Workbook Content material tasks. You are required to set up the relevant relationships between tables provided.
SALES EXAMINATION (2013-2014) RECORD
Using a problem, create a specialist report that compares the sales overall performance...