I gang

Access Database

I have MATERIAL INVENTORY file with 70k records. I have 3 of my clerks reviewing

the data and need a mechanism to control what has been reviewed and what is still

outstanding.

Hence, I need to create a Access Database with the following features:

1. Ability to load EXCEL spreadsheet (only 1 tab) with MATERIAL MASTER (70k records - see attached MASTER_FILE).

2. Ability to load 'reviewed' files (XLS spreadsheet - see attached UPDATE_FILE). I broken the master file into 3

files ~ 23k and these are been reviewed by the clerks... They are updating the spreadsheet and there are 17 additional

columns).

*** I propose that we have two tables: 1 for MASTER and 1 for UPDATES (the 3 fields that are listed in RED will be

the key between them).

Features and Options:

1. Track 'open'/'non-reviewed records.

2. 'Generate' excel files with 'open' items for clerks to review.

3. Statistics and etc...

**** I need this to be done ASAP - so if you do not have time now, please do not bid on it...

Thank you!

Færdigheder: Excel, Microsoft Access

Se mere: data clerks, c# with access database, c with access database, access database, create access database spreadsheet, load excel, access control database, create inventory excel, database updating, create microsoft access database inventory, create inventory access database, database access inventory, inventory data access, access track inventory, create tab excel, inventory microsoft access, excel create access database, access database track time, master database access, track time access database, create inventory database excel, access database excel, excel database inventory, create excel spreadsheet inventory, xls tab

Om arbejdsgiveren:
( 3 bedømmelser ) Brooklyn, United States

Projekt-ID: #4036680

Tildelt til:

bfgreyling

Hi, expert in Excel/Access and developed this type of utility for previous SAP data migration project.

$75 USD in 2 dage
(7 bedømmelser)
3.3

31 freelancere byder i gennemsnit $127 for dette job

fastudiovw

I have 20+ years odf experience programming ms-accessm .net & sql server. Regards Fabio

$185 USD in 4 dage
(605 bedømmelser)
7.1
Prashantskin

[url removed, login to view] I have gone through your project requirements and the excel files. I will develop the project within 1-2 days only.. Please see PMB for further details Thanks for your time Regards Prashant

$150 USD in 2 dage
(456 bedømmelser)
6.9
Krusche

Please check the PMB for an effective solution example.

$75 USD in 3 dage
(26 bedømmelser)
5.6
pkcyber

see your PMB

$75 USD in 2 dage
(17 bedømmelser)
5.1
winnet21

Hi, I have experience with this project I happily if work with you in this project. Regards

$110 USD in 2 dage
(12 bedømmelser)
4.8
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c Mere

$75 USD in 2 dage
(26 bedømmelser)
4.5
ExactSystems

Please see detail on PMB. regards

$250 USD in 5 dage
(4 bedømmelser)
4.5
NourElDeen

Dear Sir, I would like to help you with that project. Best Regards, NourElDeen

$80 USD in 3 dage
(19 bedømmelser)
4.1
alekhine1962

Dear Buyer, I am developing Access databases since 1998, having worked with versions since 97 to 2007. I went through your Excel files. Straightforward project. I have some technical questions, however, you can check Mere

$120 USD in 3 dage
(15 bedømmelser)
4.0
nibiranijum

Hi, I am an IT professional with expertise in database, access and others. I have read your requirements. I am interested to do this. I can guarantee of quality output. Please have a look on my profile. Rgds, sha Mere

$200 USD in 5 dage
(2 bedømmelser)
3.0
mukulsinha25

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and Mere

$120 USD in 3 dage
(2 bedømmelser)
2.2
mfawzy6

Check pm please sir

$65 USD in 2 dage
(2 bedømmelser)
1.4
bgriffin001

I have been doing Office/ VB/ Access/ Excel/ SQL/ .NET for years. I have experience with almost every kind of industry. I recently tested for Access skills above the 85% level. Here are some references: Exxon, Ba Mere

$140 USD in 2 dage
(1 bedømmelse)
1.0
smkamranqadri

Think done, pick me up at your price and duration.

$30 USD på 1 dag
(0 bedømmelser)
0.0
atlDataCoder

Greetings. I could complete this project for you. I already have the import from the excel spreadsheets done for both MASTER and UPDATE files. Thank you. Please see PM.

$150 USD på 1 dag
(0 bedømmelser)
0.0
boyet0911

Experienced programmer/developer here. Kindly check your pmb for my details. Thanks.

$120 USD in 10 dage
(0 bedømmelser)
1.5
pratik30ei

hi sir i am ready to start your project

$75 USD in 4 dage
(0 bedømmelser)
0.0
ITUnit

Find a sample Database with PMB which meets your requirement. May proceed further if approved. Thanks.

$150 USD in 3 dage
(1 bedømmelse)
0.0
reechmeraj

Hello, I have been working on WCF, C#, BizTalk, ASP.NET for the past 10 years and during this tenure I handled various clients by delivering quality software within specified timeline.

$250 USD in 5 dage
(0 bedømmelser)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS Mere

$75 USD in 3 dage
(0 bedømmelser)
0.0