Find Jobs
Hire Freelancers

Access database setup, populate and append data.

$30-250 USD

Anulowano
Opublikowano około 10 lat temu

$30-250 USD

Płatne przy odbiorze
See attached Excel workbook DatabaseSpec.xls. On the tab "Tables" are high level requirements for a number of tables and sample data. The main table is tblExpenses. On tab "Example" is an example of a spreadsheet. In this case it stretches up to row 22. Below that is an import and append scheme, which I will discuss below. 1) I want a database in 2007 or 2010 format with the set of tables mentioned on tab "Tables". Approriate field formats and sizes, should be deduced from the example data in the tables under the headings and the given example on the "Example" tab. The ID fields should be key fields and auto numbered. Text fields should not allow duplicates, except for the tblExpenses where duplicates are OK. Tables are to be populated with the example data. 2) Forms to populate the tables, should be provided. A form in single form format must be provided to view the data in tblExpenses, but should display corresponding text values instead of the ID'd contained in the fields. 3) Excel spreadsheets similar to the example given, but which may contain a different number of records have to be appended to tblExpenses. For that purpose supply A form and VBA code (including tables and queries if necessary) as required to browse for the file to import and append the data to the tblExpenses. NOTE THAT THE YELLOW section on tab "Example" demonstrates how the data from the spreadsheet must map onto the tblExpenses. See for instance that the Licensee field will be populated with the Lic_ID from the tblLicensees. 4) Access 2003 or 2007 or 2010 is acceptable. Please state what you will provide.
Identyfikator projektu: 5523474

Informację o projekcie

23 ofert
Zdalny projekt
Aktywny 10 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
23 freelancers are bidding on average $168 USD for this job
Awatar Użytkownika
Hi, Your project looks very interesting so I will be very glad to support you on it. . The initial requirements are well defined but my intention is to have a permanent communication during the project evolution in order to get finally the best result. Hoping we will start a professional and productive collaboration I am looking forward by you. Thank you, Gelu
$150 USD w 7 dni
5,0 (127 opinii)
6,2
6,2
Awatar Użytkownika
I'm an expert Access / Excel / SQL developer and can code the required import / database editing / forms functionality so that it works as you required. I can deliver in 5 days or less. Thanks for considering me. Bests, Larry
$231 USD w 5 dni
5,0 (16 opinii)
4,9
4,9
Awatar Użytkownika
I have 8 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if u want i will done with VBA (but i think u can use VB6.0+Access Database for more control) if you want i will also send demo of my work or you can download from my profile also (VB6.0 + Access Database) waiting for your feedback on same.
$166 USD w 7 dni
5,0 (8 opinii)
4,7
4,7
Awatar Użytkownika
Hi.. I have gone through details of your project and feel comfortable in taking up the task. In your requirement, there are 10 tables will be required in database file. I will provide you a form where you can input required data that will store in tblExpenses and also a form to view the data. An option will be provided in the form to browse data file and which will append records in the table tblExpenses. For the project, I will use MS Access 2010 for the development work. Waiting for your response to discuss in detail on the project and list out things in detail. Thanks.
$144 USD w 5 dni
4,8 (17 opinii)
4,3
4,3
Awatar Użytkownika
HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data operations and also other functions like selecting the data criteria for generation of the reports, the user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. I can offer you with a very dynamic access reports, dynamic in terms of their structure i.e. the structure of a single report can change depending on the data to be displayed on it each time for e.g. access reports can be used to generate invoices on them, now as structure of the invoice is dynamic i.e. there may be any number of items billed, so in such scenarios I can offer you reports which can handle this dynamic nature of such data. Criteria for the data to be displayed on the report can be set on user forms and they can be generated on button clicks. I want to send you an access DEMO application to give you an idea of the functionality that I can offer you, if you could reply me on this message I will be able to send you the demo app. Regards.
$120 USD w 7 dni
4,7 (9 opinii)
3,7
3,7
Awatar Użytkownika
Hi Sir,I am interested to work on this project.I can provide in Access 2010. I have 5 years of experience in MS Access and VBA. I am confident about the project to finish. Lets discuss, I can show you example if we discuss. Thanks
$200 USD w 3 dni
4,9 (5 opinii)
3,5
3,5
Awatar Użytkownika
Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$210 USD w 7 dni
4,8 (4 opinii)
3,4
3,4
Awatar Użytkownika
Hi, We are MS Access developer with experience in Import/export to MS Excel. Pl see our profile and work experience. Thanks.
$166 USD w 10 dni
4,5 (1 opinia)
2,8
2,8
Awatar Użytkownika
A proposal has not yet been provided
$222 USD w 7 dni
5,0 (1 opinia)
2,4
2,4
Awatar Użytkownika
Hello Fripau, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 3 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I'm used to working with MS Access environment to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, I think I have all the skills to give High quality of work delivery withing budget and time Best regards,
$147 USD w 5 dni
5,0 (1 opinia)
2,0
2,0
Awatar Użytkownika
Hi, I'm very interested helping you creating and designing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$160 USD w 8 dni
5,0 (3 opinii)
1,8
1,8
Awatar Użytkownika
Hi, I am interested in this project. I am an IT professional with 13 years of experience. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks. Regards, Jawad
$138 USD w 3 dni
5,0 (2 opinii)
1,6
1,6
Awatar Użytkownika
Hi, I have read the description of your project and I would like to offer my services for this project. Over the last 10 years, i have done many projects on different languages and databases. I can show you my recent work which i did over different freelancing sites. Recently i completed a database of a lawyer firm, which used the software to store their clients and case information from the start to end. It is running in many US lawyer firms successfully. Let me know if you want to know more. Thanks
$155 USD w 3 dni
5,0 (1 opinia)
1,3
1,3
Awatar Użytkownika
experienced software professional with 20 years in development and maintenance of applications. I can develop in Access 2007
$222 USD w 5 dni
5,0 (1 opinia)
0,8
0,8
Awatar Użytkownika
Easy Project for me I am An excel VBA Expert and I am sure that I can help you ............................................. pm me to discuss more .................................
$166 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am ready to develop database design for below task Thank you
$72 USD w 3 dni
0,0 (0 opinii)
3,1
3,1
Awatar Użytkownika
Hi there, We belong to Microsoft Network Partner and we have 20 years of experience in database development and reporting. We work with MS Access, SQL Server, MySQL. Also we offer solutions based on MS Office. We are located in Calgary, Canada Thank you, Eugene.
$277 USD w 15 dni
0,0 (0 opinii)
1,5
1,5
Awatar Użytkownika
I propose to supply a solution as per your specifications using Excel 2007 format. I am available and ready to begin immediately.
$222 USD w 3 dni
0,0 (0 opinii)
2,7
2,7
Awatar Użytkownika
I will be in a position of providing my work in the Microsoft 2010 format and in the time line of three days as I have stated.I will be grateful working with you I plan to work along with your guidelines for more information ,specification or questions you may do this through my email
$60 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
EXPERIENCE WITH ACCURACY RELIABILITY IN TIME EXPERIENCE WITH ACCURACY RELIABILITY IN TIME EXPERIENCE WITH ACCURACY RELIABILITY IN TIME
$155 USD w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga SOUTH AFRICA
Stellenbosch, South Africa
0,0
0
Członek od lut 24, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.