MS Access / Excel database

Closed job

Recent jobs from category Admin support

  • no avatar
    zarii 2 deals
    Good day, Excel covers about 100k records, for which I need an additional column of data, more precisely it looks like this: - Name - Brand - Missing data (code) So far, I have used GPT chat myself, returning one simple prompt + copy-paste column with Name and Brand. Out of 44 items sent back, the chat returned 43 items. The most important provision in the order refers to the following: The Contractor undertakes to execute the order with due diligence and in accordance with applicable regulations and requirements of correctness. Completion time: until 19.11
  • no avatar
    grucholl 6 deals
    I will outsource the input of various auto parts into a Prestashop store. I am looking for a person who has knowledge and experience of car parts and automotive and English language skills in this area. A person who knows the difference between a camshaft and a crankshaft or a stabilizer bar and a torque bar.... I have to introduce several hundred parts from the American market, which should be fully entered into the Prestashop store in Polish. I will provide part number, EAN code and product price. I will provide some catalogs where you can get information and pictures about the parts, but it may happen ( individual cases) that you will have to look for the information yourself. I ask in the offer to quote the price for running one item from the store.
  • no avatar
    Łukasz
    I am looking for a person who will make me formulas from Excel data (VBA or other simple possibilities come into play). The Excel data is already prepared. In the future I will want to supplement the file with new data. In short, from the data that is already in Excel I want to flirt data according to my needs. E.g. averages/totals number of goals/cards/penalties of a team in a season, a year or in the last 5,10 games, etc., further after selecting "team" from the list I will see the statistics of a particular team. Then comparing 2 teams I add for example Arsenal vs Liverpool and it shows stats: team vs opponent from last matches, season etc. (I can choose from how many recent matches it should show). In general, I am open to suggestions, ideas and help to make this clear and functional. I will try to give more details, information or questions on priv. I am looking for a person for whom doing such things will not be a problem and maybe will offer his vision of how it can be done practically etc., because I unfortunately do not know the functionalists of Excel so as to use it 100%. Interested persons please contact me. Remuneration to be determined. In general I am open to suggestions, ideas and help to make it clear and functional.
no avatar
AGREST
Employer
2 deals
Job category:
Databases
Expected budget:

Negotiable

Published:
Finished

Job description

Database of all products - product information i.e. name, expiration date

expiration date, batch number, SKU Wholesale, SKU Retail, wholesale price, retail price, etc.

Records in the database on our side.

Ability to simply enter records into the database

Ability to generate a file with prices (Pricelist) in XLS - records or, if possible

possible formatted ready file (for export to PDF)

Example columns: Name, Name, Inventory, Net price.

Possibility to generate a file with stock in XLS - records or

formatted ready file if possible ( for export to PDF)

Ability to generate file for label design in XLS - records: lot number

lot, expiration date SKU code, recipe, etc.

Ability to generate file for label design in XLS - records: lot number

lot number, expiration date SKU code, recipe, etc.

Ability to generate CSV file for importing product updates

Ability to develop the project further.

The job in figures:

/

Submitted offers 17

Add your offer or ask the client for more details