Need Help in Point of Sale in access

[ZKHADI]

Hy friends. i have attached below an image of my POS system i made foundation. but i stuck in some points.
which i describe in image. please check the image below and read the points. because here if i describe you will not get idea what i mean to say.

thanks and waiting for solution. thanks in advance

 

[mike60smart]

Hy friends. i have attached below an image of my POS system i made foundation. but i stuck in some points.
which i describe in image. please check the image below and read the points. because here if i describe you will not get idea what i mean to say.

thanks and waiting for solution. thanks in advance

Hi
Can you upload a zipped copy of the database?

 

[Uncle Gizmo]

Can you upload a zipped copy of the database?

I agree. I can't see any way to progress with just the annotated image.

Provide a copy of the database, (remove any confidential information first) and provide comprehensive instructions on what you want. There's no point in trying to guess what you want, that's just a waste of time.

 

[ZKHADI]

Yes here it is...
no necessary data in this database. you can modify in your own way. i dont mind i need help from you. do your best.
thanks

 

[ZKHADI]

Hi
Can you upload a zipped copy of the database?

Database zip uploaded

 

[ZKHADI]

hello is there anyone who get my zip folder?

 

[Uncle Gizmo]

I read your question when you first posted it and I thought that's a big question!

There is no way I have the time to even begin to start to answer it, although I have done this in the past.

Seeing as no one has taken up the challenge in answering your question I suspect they feel the same as me, that this is a rabbit hole of a question and nobody wants to venture into it.

I suggest you divide it up into smaller questions and apply for answers to those in turn.

You need to think about the steps necessary to get from where you are to the results you want and write them out in long hand explain what you think your database should look like at each stage in the development.

One question might be" how do you scan a barcode?"

Another question might be to ask the forum if they could suggest some steps you need to take?

 

[ZKHADI]

I read your question when you first posted it and I thought that's a big question!

There is no way I have the time to even begin to start to answer it, although I have done this in the past.

Seeing as no one has taken up the challenge in answering your question I suspect they feel the same as me, that this is a rabbit hole of a question and nobody wants to venture into it.

I suggest you divide it up into smaller questions and apply for answers to those in turn.

You need to think about the steps necessary to get from where you are to the results you want and write them out in long hand explain what you think your database should look like at each stage in the development.

One question might be" how do you scan a barcode?"

Another question might be to ask the forum if they could suggest some steps you need to take?

Thank you. i was also thinking to divide my problem into pieces then it will solve . i will upload question again.

 

[mike60smart]

Just to highlight a few of your problems:-

SupplierT table you are using a Lookup onthe Category Field. This is NOT recommended.

Item Table needs the ID Autonumber to be set as a Primary Key. This field should also be renamed to ItemID vice ID.

CategoryT table needs an Autonumber CategoryID to be added.

tblNumbers needs another field in addition to the Autonumber field
Customer Table This table should only have fields relating to a Customer ie Customer Name

All of the other fields relate to the Purchase of Items which means you need 2 more tables

You should remove all spaces in field names.

You should use a proper naming convention for all Objects.

 

[ZKHADI]

Just to highlight a few of your problems:-

SupplierT table you are using a Lookup onthe Category Field. This is NOT recommended.

Item Table needs the ID Autonumber to be set as a Primary Key. This field should also be renamed to ItemID vice ID.

CategoryT table needs an Autonumber CategoryID to be added.

tblNumbers needs another field in addition to the Autonumber field
Customer Table This table should only have fields relating to a Customer ie Customer Name

All of the other fields relate to the Purchase of Items which means you need 2 more tables

You should remove all spaces in field names.

You should use a proper naming convention for all Objects.

brother if you have time then download the zip folder and do you best and return me file please

 

[mike60smart]

brother if you have time then download the zip folder and do you best and return me file please

Hi
The idea is that you actually do the work.

 

[Uncle Gizmo]

Hi
The idea is that you actually do the work

Hehehe, my thoughts exactly...

Mike has pointed out some flaws in your database. Most are easy fixes like changing field names.

If you made an effort, and demonstrated that you are here to learn MS Access then I can assure you, you will be amazed at the help that will be given freely to you.

 

[ZKHADI]

Hehehe, my thoughts exactly...

Mike has pointed out some flaws in your database. Most are easy fixes like changing field names.

If you made an effort, and demonstrated that you are here to learn MS Access then I can assure you, you will be amazed at the help that will be given freely to you.

I love to learn programming but lack of money nd lack of good teacher in y teratory. Thats is why learning here.

 

[Uncle Gizmo]

Re:- love to learn programming but lack of money nd lack of good teacher in y teratory. Thats is why learning here.

You actually said:-

brother if you have time then download the zip folder and do you best and return me file please.

Is the comment you made and is the comment I was responding to....

All the help you require will be provided to you for free on this forum, all you need do is demonstrate a willingness to learn.

 

[mike60smart]

I love to learn programming but lack of money nd lack of good teacher in y teratory. Thats is why learning here.

Hi
If you make the changes I suggested then we will be able to help further.

 

[ZKHADI]

Yes i will try to ke changes

 

[arnelgp]

there are lot of Open-Source POS.
one of them is: Chromis POS download | SourceForge.net

 

[ZKHADI]

I will visit site but own pos have those features which we want. Ready made lack of those features