Turn on thread page Beta
    • Thread Starter

    Hi I 'am doing ICT G064 coursework for my alevels. I have to make a system for a client. The section I 'am stuck on is queries. I dont know what queries to make. I am making the system using microsoft access.
    The system is for local shop which sells tobacco products.

    The objectives I want the system to do are;

    View stock
    Enter any sales thats been made
    Add staff
    Order (products bought in)
    Supplier(who the product is bought from)
    Stock alert(The system should show when products are below 10)
    Staff performance(I want to see how many products each member has sold)
    Print sales report

    These are my entities;
    Staff (Staff Id, Name, Age)
    Sales (Date/time, Product id, Staff id, Description, Price, Quantity)
    Stock (Product id, Quantity, Cost, Brand, Size)
    Order (Product Id, Order date, Order quantity)
    Supplier (Supplier Name, Address, Contact number)

    Please contact me if you need any more information.

    Hi there,

    While you're waiting for an answer, did you know we have 300,000 study resources that could answer your question in TSR's Learn together section?

    We have everything from Teacher Marked Essays to Mindmaps and Quizzes to help you with your work. Take a look around.

    If you're stuck on how to get started, try creating some resources. It's free to do and can help breakdown tough topics into manageable chunks. Get creating now.


    Not sure what all of this is about? Head here to find out more.

University open days

  • University of Bradford
    All faculties Undergraduate
    Wed, 21 Nov '18
  • Buckinghamshire New University
    All Faculties Postgraduate
    Wed, 21 Nov '18
  • Heriot-Watt University
    All Schools Postgraduate
    Wed, 21 Nov '18
Black Friday: Yay or Nay?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.