Access Database
- or -
Post a project like this$
- Posted:
- Proposals: 12
- Remote
- #1991280
- Expired
Project Planner/Scheduler, Database Developer, Data Management (MS Access, MS Excel, MS Word, MS Project and Primavera P6)
Quezon City
Expert in website and application development|| FullStack Developer|| Android/IOS Developer|| MERN
Ahmedabad
9634511709451196810315980835495219951821063249517902702695487002219721109261
Description
Experience Level: Entry
Hi All,
I hope you are well. I have a small project for you. Please can you have a look at quote me for this. Its actually quite simple.
Attachments: 1 Text File, 1 Excel File
Scope of Project: Amazon produces a text file download for the items we are sending to their inventory. We need to use data from that text file to generate a commercial invoice in a PDF Format with prices (USD $).
Steps:
1. The data Text File Download needs to be imported into the Access Database.
2. The database then allows the User to edit the descriptions to abbreviate the long description (under the "Title" header) and then saves the new abbreviated description for future use.
3. The database prompts the user to add a price - this column is not available on the text file, and then save for future use.
4. The database uses that price and multiplies with the quantity from the text file to compute a total price for that product.
5. The database compiles a final total for quantity & price for the entire shipment.
6. It exports a final commercial invoice in a PDF format, the name of the export file being the same that of "CI & Shipment ID & Name"
7. For every new imports, it just prompts to enter the price and abbreviate only new products being imported to avoid repetition of tasks.
8. The invoice should have our company details in a nice looking A4 format.
Please let me know if you have any questions on this & I look forward hearing from you soon.
Thanks
Sam
I hope you are well. I have a small project for you. Please can you have a look at quote me for this. Its actually quite simple.
Attachments: 1 Text File, 1 Excel File
Scope of Project: Amazon produces a text file download for the items we are sending to their inventory. We need to use data from that text file to generate a commercial invoice in a PDF Format with prices (USD $).
Steps:
1. The data Text File Download needs to be imported into the Access Database.
2. The database then allows the User to edit the descriptions to abbreviate the long description (under the "Title" header) and then saves the new abbreviated description for future use.
3. The database prompts the user to add a price - this column is not available on the text file, and then save for future use.
4. The database uses that price and multiplies with the quantity from the text file to compute a total price for that product.
5. The database compiles a final total for quantity & price for the entire shipment.
6. It exports a final commercial invoice in a PDF format, the name of the export file being the same that of "CI & Shipment ID & Name"
7. For every new imports, it just prompts to enter the price and abbreviate only new products being imported to avoid repetition of tasks.
8. The invoice should have our company details in a nice looking A4 format.
Please let me know if you have any questions on this & I look forward hearing from you soon.
Thanks
Sam
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
-
Hi, Is the download in the format attached with the header information (rows 1-14) already on there or have you added this?
-
Hi Sam,
Would you be interested in a software as a service / subscription based solutions where we make available the functionality you need on w web page and you pay a small amount every month to use it? You could cancel at any time and access/export all of your data at any time. -
Are you looking to integrate into an existing Access database, or would you be willing to discuss alternative database platform for your needs?
S F.27 Apr 2018Just a new database where I can import the text file to compute & export a PDF invoice.
634172634133633997
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