want everything to be done in access from excel, for the excel file which i have attached.

[sidhu246]

as am beginner for access and i have loadz of data which is similar to the one which i have posted in (https://www.excelforum.com/excel-gen...her-sheet.html) and data is going to be stored in table(sheet) and output has to be effected in other table(sheet). Due to much data excel is getting slow and taking hours in order to get output. And the produced qty has to be entered manually date wise . I have no idea how to do this in access. Can anyone over here help me out.

[sidhu246]

want similar thing to be done in access like in the post shown can anyone help me out with this post.https://www.excelforum.com/excel-gen...her-sheet.html

[June7]

Exactly what do you want - import data to Access database and eliminate the Excel?

[sidhu246]

Yes june7.
I want only access to be used, as data is getting piled up day to day. And I have no idea about access. Can you please help me in doing the thing in access.

[June7]

Start with a review of https://support.office.com/en-us/art...F-4106F78850B4

[sidhu246]

Thanks June7.. can you please lemme know how to add queries for the excel table.. Actually the functions i used in excel that are not same in access. Can you make the similar database for me with the same data and send it. As i don't have time and i need to complete this project on time.. thanks

[June7]

No, I am not going to build database for you. If you don't have the time and/or can't be bothered with learning the skills, then I suggest you find a contractor.

[sidhu246]

Whatever .. Thanks @June7 for your time..

[orange]

There are several free youtube tutorials dealing with database and Access specifically.
Here is a playlist by 599CD (Richard Rost)
You should also be aware that database and spreadsheet are very different. They are different products
and built on quite different object models.

Here is a link to database design and planning. The tutorials under Practical Experience will be very helpful to you, if you spend time to work through them.

Good luck.