Simple excel database programming by wilsontan

I need a very simple excel program done by today. Please bid only if you have excel programming/macro experience. This will not take more than couple of hours for an experienced excel programmer, so please bid accordingly.

Details will be provided to interested parties.

Thanks.

ID-Short
-The Number column indicates the sequence of item and also a permanent number ID assigned to it See in the excel sheet provided, battery part number431436-001 appears twice but maintains number 1 as the code (blue cells)Any new part number
must take the second number in series. E.g look at 431489-001 battery that has taken number 2 and it goes on and on like that to 3. Therefore column D should have a formula that will
be able to assign numbers as indicated.

priate question category/type decisions
- Remove duplicate questions if/when they appear. This point is important as the front-end randomly generates the quiz and whilst I will review the quiz before using it, I need to minimise the work as much as possible.

Ideally the successful bidder would also have a genuine love for trivia. It would make this job MUCH more enjoyable!!

Thanks for your time. Looking forward to hearing from you all.

Make sure that database programming changes do not cause unintended errors in reports.

Glowing letter of recommendation & referral will be provided to successful candidate when job is complete. This may also lead to further jobs as our sole-sourced Contract Programmer to cover all our future out-sourced needs.

---

Additional files submitted:
Add _1.doc

ware suggestions need to be Windows based, ideally XP, Vista & Windows 7

7. Attached are specification details on the barcode scanner, software and drivers for compatibility.

8. Will be looking to download approximately approximately 20 batchs a day each batch contains between 5 barcodes up to 50 barcodes, approximately database size would be 3000 barcodes in total.

If you have any questions please contact me.

le.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://www.qualmax.com/product_search_test.php)

It would also include introduction page about the company and direct link to pop-up call and pop-up email. The apps should look highquality and userfriendly for the company image.

Please inform which apps you have developed in the past so I could get a basic idea of your experience.

Thank you.


Paul

el database template..

We have about 30 different vendors who are all sending us Excel sheet with product numbers, names, descriptions, sizes, prices, etc.. We need all of those sheets consolidated into our database format, and we need it all done with 100% accuracy. Total SKU's will amount to roughly 15,000 products.

We will also need to generate titles, descriptions, and keyword metas out of the features and descriptions that are given by the vendor.

nd see if everything works. If the database works, it has to be copied to our local server together with the command screen.
- In order to work on our local server we will have to set up a remote control

---

Additional files submitted:
JOB DESCRIPTION.doc
DATABASE LAYOUT.xls
source.doc

e file containing the following data fields (a) document # (b) GL account (c) Fund # (d) dept # and debit and credit columns. The source system generating the file sometimes "rounds" by a cent throwing a document out of balance. The macro needs to read the data and, when it finds a document out of balance, balance the debits and credits. Written -- detailed -- specs are available with sample data, logic to apply, and sample results.

I have 2 excel databases that need to be merged.

There are some common elements between them (name and an ID #), but the header rows are different.

I need them in merged one excel database.

ceiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.

Each property will be logged on the excel spreadsheet after the property has been cleaned.

Candidate must have access to the internet and be able to send 2-5 faxes per week.

Skills Required:
Microsoft Excel, internet research, database skills

eiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.

Each property will be logged on the excel spreadsheet after the property has been cleaned.

Candidate must have access to the internet and be able to send 2-5 faxes per week.

Skills Required:
Microsoft Excel, internet research, database skills

eiving lists, contractor will clean lists. Cleaning lists pertains to finding the owner of the property and verifying that the property meets the criteria of the Employer.

Each property will be logged on the excel spreadsheet after the property has been cleaned.

Candidate must have access to the internet and be able to send 2-5 faxes per week.

Skills Required:
Microsoft Excel, internet research, database skills

the results only show up to 100 of the results. Therefore you will have to filter the data alphabetically by the 'Company Name' i.e search AA, then AB, then AC... BB, BC, BD. within the 'Company Name' of each result is a link to further details for the company which details the email, phone numbers, address etc to be extracted and put into the excel database.

Further clarifications and instructions can be provided if necessary.

dding-left: 20px; width: 320px">


Additional files submitted: (Files are only available for logged in users)
ReSources+Database+Spec+01-21-2011.txt

names;
.possibility to contact people or full class at once (no emails showed)
.update personal info after login
-C# admin program:
.able to view/edit all data
.export to CSV/XLS/XML
.check validity of email addresses
.check last update of all records (if longer one 1 year - send email suggesting to update)

No fancy things. Just simple programming to accomplish goals.

Hi, we are looking for simple online database and have attached the layout in access database file. The database will be viewed by 4 quiery tables. the quiries are made from a simple filter. There will also be an admin password to main table and there will be 4 separate passwords to each of the tables. We have attached the fields and tables in a zip access database.