IOM205
Advanced Database Management
1st SEMESTER 2025/26 Individual Coursework
INSTRUCTIONS TO CANDIDATES
1. A single copy of your work must be submitted electronically through Learning Mall Online by 00:00, Monday, 15 Dec. 2025 (China Standard Time, UTC/ GMT+8).
2. This coursework will count for 70% of the final mark in this course.
3. Generative AI is not allowed in completing this coursework.
Coursework Title:
Individual Coursework: Implementing a Database using Microsoft Access
Scenario:
The Scenario is the same as GROUP COURSEWORK.
Task Details/Description:
For this coursework, you may continue working with the deliverables (ERM, Tables and Sample records) produced in the group coursework. Including any extra features, you may wish to – adding value to the application in functionality and usability may earn extra credit. Your report must clearly state these features.
The primary task for this part ofthe coursework is to individually produce a fully tested and functional database application that has been implemented using Microsoft Access.
Please note, you must at the minimum have the following functionalities in your database application to score a passing mark for the corresponding grading component. -
Please refer to the pages at the end of this document for the grading components and criteria.
Deliverables:
You MUST submit the following two deliverables (ID1, 60% of total mark, and ID2, 40% of total mark) to complete this coursework.
ID1: Fully tested and functional database that fulfils the functional requirements meeting the business needs specified in the scenario.
• The database must support several business processes described in the scenario context and specification. You may change some of the design produced in the group coursework based on the feedback received from the instructors.
• Include functionality (forms, queries, reports and charts) to support the main operations of the company. The database should be able to: add, edit and remove books, order books, generate invoices, reorder low stock and produce useful management information (e.g., total value of stocks).
• Entities must be defined using a focused set of attributes that are both essential and contextually appropriate. Continue/revise on what has been produced in your group coursework.
• Include at least one unbounded form, one trivial and one non-trivial form, that will help to realise key business needs, i.e., gather inputs and produce the correct output, which are user-friendly and displayed in an appropriate manner to the user (e.g., home page – unbounded form, add a new customer – trivial form, add new customer order, reorder books – non-trivial forms).
• Include at least two non-trivial queries. Your queries should demonstrate the use of multiple tables, parameters, calculated fields and multi-stage query. You should also produce appropriate SQL code for at least one of your queries. The code should be annotated in the report to demonstrate your understanding (please refer to ID2.3 below in the deliverables section).
• Include one neatly formatted Access report to provide useful management information. Include at least one level of grouping, and at least one summary/calculated field (e.g., customer invoice, most valued customer based on purchase orders, most popular books sold or reordered, total expenses incurred towards each publisher, most valued employee based on sales).
• Include one Access chart linked to a form or report that illustrates some key operational information from the application to the organisation (e.g., sales made each month, popular books).
ID2: Report not exceeding 1500 words (+/-10%), which MUST include the following. The front cover page (with student number and title of the assignment), table of contents, headers, sub-headers, figure and tables, labels as well as annotations, citations, and references, are not included in the word count (i.e., 1500 words). Estimated word limits for each section are provided below to help you write the report and have some idea of how much to focus on each section, while deciding the contents. You must use Harvard referencing style. for your references and citations. Please note, your report MUST include the following at a (or the) minimum to score a passing mark for the corresponding grading component. Please refer to the last two pages of this document for the grading components and criteria.
• ID2.1: Simple instructions briefly describing how to operate the database. The instructions must be written as if for a typical employee with limited knowledge of Microsoft Access. You should use figures and annotate them to better articulate the instructions. Brief description of the core features (2 to 3) of the database, for example, how these features meet the needs of the business (e.g., useful non-trivial forms), addressing the current limitations, explained with the aid of screenshots from your database application (as applicable). Justify the features and/or design decisions citing appropriate literature. [estimated word limit — 300 words]
• ID2.2: Include a concise description of one non-trivial form. that you designed. In your description [estimated word limit — 300 words]:
• 1) specify why the form is non-trivial and how it addresses the organization’s needs.
• 2) Provide figures or screenshots illustrating the form in table view, along with sample output.
• ID2.3: Include a concise description of two non-trivial queries designed for management purposes. In your description [estimated word limit — 400 words]:
• 1) specify why each query is non-trivial and how it addresses the organization’s needs.
• 2) Provide figures or screenshots illustrating each query in table view, along with their corresponding output.
• 3) You must also include the screenshot of the SQL code for both queries and briefly explain the code in your own words—demonstrating your understanding of how each query executes.
• ID2.4: Include a brief description of one Access report. In your description, state why the report is useful for the management, and how it will add value to the business. Please include figures to show sample report outputs you have generated. [estimated word limit — 300 words]. Include a brief description of one non-trivial chart linked to a form. or report. Explain the value of the chart to the organisation. Please include a figure to show the sample output. You may annotate them (as applicable). [estimated word limit — 200 words]
Submission:
You are required to submit TWO files: (1) Your Microsoft Access Application (name_studentid.accdb); (2) Your Report (name_studentid.pdf/docx). The coursework is going to be submitted electronically. Further instructions about how to do this will be provided during a workshop session.
Your work will be assessed on robustness, functionality meeting the business requirements, usability, and the overall quality of your design. The working and fully functional database will contribute to the majority weight for this coursework, hence please create necessary back-ups.
Warning! If your database cannot be opened, is corrupt or is otherwise inaccessible, or your media contains malware, you will score ZERO for this part ofthe assignment. Please ensure you have created one or more back-up copies of your work in suitable places using appropriate mediums available to you, to avoid losing the work you may have already done.
Assessment Weighting for the Module:
The weight ofthe individual coursework is 70%