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;
Enter any sales thats been made
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.
Turn on thread page Beta
ICT GO64 queries help? watch
- Thread Starter
- 19-11-2013 13:14
- 20-11-2013 14:20
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.