HCLT131-1 Computer Literacy Advanced Formative Assessment 3 | BCC

Published: 04 Jun, 2025
Category Assignment Subject Programming
University Boston City Campus Module Title HCLT131-1 Computer Literacy Advanced
Assessment Type Practical Assignment
Academic Year 2025 

Instructions: 

  • This paper consists of two (2) compulsory questions.
  • The assessment covers Units 9 -13 of the Study Guide.
  • Upload the Microsoft Access database and a PDF with answers to Question 2. Do not put any of the files in a zipped folder.
  • These two files are to be uploaded separately. 

HCLT131-1 Learning Outcomes: 

  • Define a database
  • Design and create a database
  • Add records to Tables
  • Create Table relationships
  • Create a Query and sort the Query using a Wizard 
  • Sort data in a Form using the available methods
  • Create a report using the Report Wizard

Question 1 [20 Marks] 

Background: 

You run a small online tech accessories store selling phone cases, chargers, and headphones. You've been managing your inventory and customer orders using spreadsheets, but it's becoming overwhelming and prone to errors. After learning about Microsoft (MS) Access, you've created a database system to organise your business better. Your database will include the following tables and attributes: 

  • Customer table [customerID, first name, last name, address, and cell number]
  • Inventory table [inventoryID, inventory name, price, size, and category]

Achieve Higher Grades with HCLT131-1 Assignment Solutions

 Order Non-Plagiarised Assignment

Required: 

Open the provided database HCLT131-1-Jan-June2025-FA3-Data in MS Access to create the sales management system. 

Rubric:

 HCLT131-1 Computer Literacy Advanced Formative Assessment 3 | BCC
Question 2

Answer the following questions based on the database you created in Question 1. Submit a PDF with your answers.

  • 2.1 Identify and explain any six data types available in MS Access. (6 marks)
  • 2.2 Describe the functions of your database's three tables (customer, inventory and supplier). (6 marks)
  • 2.3 Create a relationship between the Customer, Supplier and Inventory tables and produce a screenshot of the relationship diagram. (5 marks) 

Please note: The relationship must be created in MS Access and should display referential integrity between the tables.

  • 2.4 Query the entire inventory table (show all attributes) in MS Access of the store's database, with the inventory name. (4 marks)
  • 2.5 Former label font (form header) and size to Segoe UI Black, 26. Add a screenshot of the result. (4 marks)
  • 2.6 Create a report of the suppliers' table and ensure there are no grouping levels. Add a screenshot of the report. (5 marks)

The below only applies to students enrolled in the Bachelor of Accounting program. Aligns to SAICA competencies:

HCLT131-1 Computer Literacy Advanced Formative Assessment 3 | BCC

Are you trying to find someone who can help with my HCLT131-1 Computer Literacy Advanced? Well! You're in the right place, our podium. Workingment provides Programming Assignment Help. Our well-researched and talented professors can also provide you with odd assignments. Suppose you're judging whether to Write My Assignment with our professors. No doubt! Our team can help with your assignment. We also provide Free Sample assignments for your guidance. Get in touch right now!

If you want to see the related solution of this brief, then click here: Computer

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

MED031-6 Final Project in Mass Communications Assignment 2 Example | University of Bedfordshire

Category: Assignment

Subject: Education

University: University of Bedfordshire

Module Title: MED031-6 Final Project in Mass Communications

View Free Samples

BABM2006 Work-Based Management Project Assignment 3 Example

Category: Assignment

Subject: Management

University: De Montfort University

Module Title: BABM2006 Work-Based Management Project

View Free Samples

LAA127/LAA127C Contract Law Assignment Coursework Sample 2025

Category: Coursework Example

Subject: Law

University: Swansea University

Module Title: LAA127/LAA127C Contract Law

View Free Samples

MGT4541 Strategy, Leadership and Management of Organisations Assignment 3 Example

Category: Assignment

Subject: Management

University: Middlesex University

Module Title: MGT4541 Strategy, Leadership and Management of Organisations

View Free Samples

DGM22702 Digital Consumer Journey Project Example 2025-26 | RUL

Category: Assignment

Subject: Computer Science

University: Ravensbourne University London

Module Title: DGM22702 Digital Consumer Journey

View Free Samples
Online Assignment Help in UK