Simple Changes to an Access Database
- or -
Post a project like this$$
- Posted:
- Proposals: 7
- Remote
- #1715475
- Expired
Microsoft Access Developer, Access Developer, Access Development, Access Database Developer, MS Access VBA Developer
Paris
27026914290463549587822323452164609280167
Description
Experience Level: Intermediate
General information for the business: We need changes to an Order processing software
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: Hi all,
Summary: We use an Access Database to process customer orders. We upload the CSV files into the Access Database system, where it generates an integrated label/packing list and also the proof of postage. We now need few changes into the database as below.
1. Incorporate a section within the database to upload images and their respective "merchant_sku_item". The merchant_sku_item is an UNIQUE Identifier which can be used for further mapping the data. We will upload the "merchant_sku_item" and the image.
2. With the above "merchant_sku_item", all the images should be accumulated to prepare and print a picking list like the one attached (A4 sheet with images and description), also by totalling the sum of the merchant_sku_item. The picking list help us to prepare the orders. For example, if the "merchant_sku_item" is the same for 10 orders, the picking list will show 10 pieces of item with SKU 8438572685981.
3. Incorporate the images on the invoice like the one attached, with the code being as the "merchant_sku_item".
4. Add another column on the current invoice where the heading should be called "Description". This would be the same data as "item_name" from the CSV File.
Some sample files are attached due to limitations of the number of uploads I can do. Please let me know.
Thank you
Sam
Extra notes:
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: Hi all,
Summary: We use an Access Database to process customer orders. We upload the CSV files into the Access Database system, where it generates an integrated label/packing list and also the proof of postage. We now need few changes into the database as below.
1. Incorporate a section within the database to upload images and their respective "merchant_sku_item". The merchant_sku_item is an UNIQUE Identifier which can be used for further mapping the data. We will upload the "merchant_sku_item" and the image.
2. With the above "merchant_sku_item", all the images should be accumulated to prepare and print a picking list like the one attached (A4 sheet with images and description), also by totalling the sum of the merchant_sku_item. The picking list help us to prepare the orders. For example, if the "merchant_sku_item" is the same for 10 orders, the picking list will show 10 pieces of item with SKU 8438572685981.
3. Incorporate the images on the invoice like the one attached, with the code being as the "merchant_sku_item".
4. Add another column on the current invoice where the heading should be called "Description". This would be the same data as "item_name" from the CSV File.
Some sample files are attached due to limitations of the number of uploads I can do. Please let me know.
Thank you
Sam
Extra notes:
S F.
100% (29)Projects Completed
39
Freelancers worked with
34
Projects awarded
27%
Last project
23 Jun 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies