Fermé

access / excel database

Hello ,

I am trying to create a one to many relationship using several linked excel spreadsheets.

I need the excel spreadsheets to be linked as they are updated on a weekly basis.

Once the relationships are created I want to combine certain columns from each spreadsheet using a query.

Once I have all the information I need on one table I need to import this into excel to create a profit per sale and total profit per month.

I have already created a database that suited my needs perfectly using Vlookup and various formulas, however, it has become too big and heavy to use.

I would like help and advice to optimize database. The above description with access is my theory on how to do this. If anyone can provide a more creative / effective way to assist I am all ears.

I have tried doing this myself and I am coming across error messages that I cannot solve by myself.

Compétences : Microsoft Access, Excel, Comptabilité, Visual Basic

en voir plus : export data excel database java, access excel purchasing data entry, search particular data excel database, visual basic data access layer, using access excel database, basic excel database, searching data excel database, write data excel database macro, visual basic data entry system oracle database, extract word data excel database, basic data excel, visual access excel data, access excel copy paste data, combining data access excel, form excel visual basic data, migrate data excel database visual basic, visual basic data pdf file

Concernant l'employeur :
( 0 commentaires ) Envigado, Colombia

Nº du projet : #20880705

55 freelance font une offre moyenne de $140 pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(326 Commentaires)
7.9
asin1987

Dear Employer, I perfectly understand your job and have seen your attached sheet as well. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for yo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(176 Commentaires)
7.5
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel workbook optimized to produce useful data such as profit. I plan to use Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(264 Commentaires)
7.5
caabdul

Hi, I am skillful accountant and Excel developer so you may expect the best here. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(129 Commentaires)
7.0
dvcontact

Hi, Reading your project description about combining several downloadable report using unique reference number makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(50 Commentaires)
6.4
zu02

Hi I'll code all via ms access . The interface will be very friendly. Regards Zurab ms access/vba coder since 1997.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(53 Commentaires)
6.1
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)
5.6
razvancotofana

Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your merging and formatting job. Please share your project details over chat. BR, Razvan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(16 Commentaires)
5.3
AkilaArun

Hi, I am interested in working on the task. I have experience working with excel , excel VBA and in data processing. Saw the [login to view URL] like to discuss more about the requirement and the output format. Looking Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(42 Commentaires)
5.0
rayyankabir

Hi there, Greetings! I am an experienced MS Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Offi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(20 Commentaires)
4.8
VBAautomation

Thank you for giving me the opportunity to express my interest on your project. This project is related to my are of expertise. I can provide you best support on your project. let's have a chat and I am highly interest Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(25 Commentaires)
5.2
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel, Access/VBA programmer on freelancer.com and I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(21 Commentaires)
5.1
bhupendrayadav

I can create the database by linking multiples files and creating report like profit per sale and profit per month from that, for optimizing the database and process , i would use VBA macros instead of formulas, please Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(32 Commentaires)
5.1
usamafca71

I am a Chartered Accountant & Business Consultant. I have more than 5-year experience in the field of FINANCE, ACCOUNTING, AUDIT, RISK ASSESSMENT and BUSINESS MANAGEMENT. I have performed more than+50 accounts and busi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(26 Commentaires)
4.2
ironstar20311

( ͡ᵔ ͜ʖ ͡ᵔ ) Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Here are projects I have done recently using Excel VBA and formulas. ==== Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(20 Commentaires)
4.1
fanninson45

SHOWCASE I have 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-A Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
4.2
AnowarRatul

$ 30 ONLY!!! In just 3 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LEAST Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(23 Commentaires)
3.6
alhassanlatif

Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have read your description could you contact me for details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(6 Commentaires)
3.6
royalwebraisers

Hi, I would like to suggest you to use MySQL as database. This can handle huge database and we can generate many reports like you need. Please let me know if we can discuss in more details. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
3.6
alokes

Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like develop the database using MS Access as per your requirement and input provided by you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
2.9