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%