Ditutup

Access (or excel) Data base App cleaning data in existing access data bases

I research military history and compile large lists of soldiers. The largest table has 6 million rows of names in it, the smaller ones have 100,000 upwards.

1st step is the importing of the relevant data base. When the path to the relevant database has been selected, I then select the table that I need to work on from that database. I find the table (from a drop down list that appears) and click import to import it into the app. The imported table will be imported to tblData and will be the same as it was (column headings included) as it was in the original database.

Functions I want

1. Duplicate below - this is for duplicating data in a blank cell using the data in the cell immediately above the blank cell. The code will copy and paste the data into the blank cell and will continue to do so until it finds the next cell that is not null.

It will then find the next blank cell and do the same.

2. UnitList and Units.

The UnitList is the important function.

I want you to build a table (called Unit Changes) that will activate a function based on the data in 1 of 5 other tables (called ULWW1, ULVictorian, UL1920, UL1939, or UL1947).

When you double click on Unit Changes the software will ask which table do you want to use (ie drop down list ULWW1, ULVictorian, UL1920, UL1939, or UL1947).

Select the relevant time frame and then the code will look for the column headed Unit in the selected table (say ULWW1), look for the cells in the column called Unit in tblData and find a Unit in the old column of ULWW1 and replace it with the new (in ULWW1).

The data ranges from 1790 to 2019 so I need the UnitList tables.

3. RankList and Ranks.

We have to do the same to update the various Ranks in tblData when a table is imported into the software.

I want you to build a table (called Rank Changes) that will activate a function based on the data in 1 of 5 other tables (called RLWW1, RLVictorian, RL1920, RL1939, or RL1947).

When you double click on Rank Changes the software will ask which table do you want to use (ie drop down list RLWW1, RLVictorian, RL1920, RL1939, or RL1947).

Select the relevant time frame and then the code will look for the column headed Rank in the selected table (say RLWW1), look for the cells in the column called Unit in tblData and find a Rank in the old column of RLWW1 and replace it with the new (in RLWW1).

4. change to Upper Case. I would like the code to look for a column called UpperCase (depending on what data I want in Upper Case, I will change the name of the relevant columns in tblData).

So all the user has to do is click on Upper Case and the code says do you want me to start working to change to upper case or something ... remember I will have changed the column header in tblData to reflect what you have used in the code.

5. delete duplicates. The code goes through all the data and look for identical rows .... the data in the cells needs to be identical except in pdf name/pdf page.

The software will show me (with the 2 rows together, hopefully the 2nd identical entry highlighted in pale grey) that these rows are identical. All 2nd rows will have a column in which there is a box which by default will be ticked.

At the top of the view pages there will be a button PROCESS and another STOP. If PROCESS is clicked then all the 2nd duplicated rows that have a tick in the box will be deleted in tblData. If STOP is clicked then the window closes/nothing is changed.

Before I click PROCESS I need to have the ability to untick as many boxes as I want.

When rows are deleted it will be the second row that is to be deleted, not the first.

6. - a new function will be a button called Similar - by clicking this button the software will interrogate the data and look for similar, but not identical, pieces of data.

See attached document for complete brief.

Many thanks.

Keahlian: Microsoft Access, Excel, Pemrograman Database, Entri Data, Pemrosesan Data

Lihat lebih lanjut: similarities between excel and access, excel to access converter online, copy data from excel to access, update access table from excel, import excel into access 2010, import excel into access 2016, import excel data into existing access table, access vs excel pros and cons, convert access data base, add access data base vbnet 2005, vbnet create access data base, access excel purchasing data entry, 100 terminologies data base access, opening locked access data base, access 2003 warehouse data base, access data base executable, creating multi user access excel vba app, access data base report, visual access excel data, access excel copy paste data

Tentang Pemberi kerja:
( 0 ulasan ) Toronto, Canada

ID Proyek: #23974703

22 freelancer menawar dengan rata-rata $21/jam untuk pekerjaan ini

schoudhary1553

Hello, I can help you with your project - Access (or excel) Data base App cleaning data in existing access data bases I have gone through your job posting and become very much interested to work with you. I am an exp Lebih banyak

$20 CAD / jam
(358 Ulasan)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have some help with an Access database. Unfortunately, nothing is attached. I will ch Lebih banyak

$25 CAD / jam
(294 Ulasan)
7.6
VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? Lebih banyak

$20 CAD / jam
(183 Ulasan)
6.7
dvcontact

Hi, Would you like to see a quick demo of your data cleaned and imported from one sheet to another before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this propo Lebih banyak

$25 CAD / jam
(57 Ulasan)
6.5
royalcalif

Let me review the spread sheet raw data and your preferable format as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I Lebih banyak

$20 CAD / jam
(124 Ulasan)
6.2
finecodervw

Hi, Keen to work on this project. Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013,2019 projects both big and small using MS Access a Lebih banyak

$25 CAD / jam
(87 Ulasan)
6.1
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. I can code all 1-6 assignments based on your instructions - professionally and on time. I’m Ms Access/VBA developer Lebih banyak

$25 CAD / jam
(55 Ulasan)
6.1
fanninson45

I had done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Data Lebih banyak

$20 CAD / jam
(24 Ulasan)
6.0
maxdmg

Hello, we have built applications for many clients on Upworks and Freelancer for the past several years, but we have been developing software for over 20 years. We have converted data from mainframe tape to PC and impo Lebih banyak

$20 CAD / jam
(3 Ulasan)
3.5
Ladiginvladislav

Hello. How are you? I can work for you faithfully/ I have read your proposal carefully. Excel and Vba is familiar with me. I can help you faithfully with your job. Sure the perfect result. Looking for your reply. Than Lebih banyak

$20 CAD / jam
(5 Ulasan)
3.7
TumblingWave

Hi there, I'm an expert in all the MS Office products, I can do this for you exponentially faster than the other freelancers. My quote is inclusive of all taxes. Regards, Barry - Tumbling Wave Software

$21 CAD / jam
(5 Ulasan)
2.3
ibjimoh204

I am proficient in data entry project, The skills required in the job matches with me properly as a skilled data entry employee and I would like to offer myself as a candidate for this job.I appreciate the invitation Lebih banyak

$20 CAD / jam
(0 Ulasan)
0.0
LizanneM90

I will make sure my accuracy is high. I will get the job done as fast and best of my abilities. I will basically give it my all and submit it back in the shortest period of time.

$20 CAD / jam
(0 Ulasan)
0.0
buin123

I m so excited to work on your project, your project will be done withing a short period of time and I will works hard in your project

$16 CAD / jam
(0 Ulasan)
0.0
sanjaykumar0111

Hi there! Greetings from Sanjay, hope my message finds you in good health. It's straight to your referenced post we already developed such applications like in Microsoft Access DB,MS Excel and hold a good experience Lebih banyak

$21 CAD / jam
(0 Ulasan)
0.0
chintamanigond8

Sir I am lot of work on excel .so I request to you that give me one chance Relevant Skills and Experience Sir nearly per day I am some work on excel so I have good experience with less error.

$22 CAD / jam
(0 Ulasan)
0.0
$22 CAD / jam
(0 Ulasan)
0.0
mdrajumolla1935

I am very interested in this work. Please, do this work by me. Relevant Skills and Experience If you do this work by me, l promise that I return to you some money. My other skills Copy type Data antry, Photography

$15 CAD / jam
(0 Ulasan)
0.0
BasmaTalaat92

Hello Dear, I have read your inquiry and understand what exactly you want. Also I'm very familiar with making such projects. My expertise includes. -Excel Equations. -Excel Pivot Tables. -Excel Macros. Thanks to check Lebih banyak

$15 CAD / jam
(0 Ulasan)
2.4
rajib209

The job made me happy as because the skills required in the job matches with me properly. Nowadays there’s bunch of freelancers available who ensure you to work properly but they don’t keep their promises. Most people Lebih banyak

$15 CAD / jam
(0 Ulasan)
0.0