Find Jobs
Hire Freelancers

Access database setup, populate and append data.

$30-250 USD

Cancelled
Posted about 10 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 5523474

About the project

22 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $173 USD for this job
User Avatar
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 in 7 days
5.0 (113 reviews)
6.1
6.1
User Avatar
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 in 3 days
5.0 (79 reviews)
5.7
5.7
User Avatar
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 in 5 days
4.7 (121 reviews)
6.1
6.1
User Avatar
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 in 7 days
5.0 (22 reviews)
5.3
5.3
User Avatar
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 in 5 days
5.0 (9 reviews)
4.9
4.9
User Avatar
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 in 3 days
5.0 (11 reviews)
4.6
4.6
User Avatar
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 in 7 days
5.0 (12 reviews)
4.8
4.8
User Avatar
I am ready to develop database design for below task Thank you
$72 USD in 3 days
5.0 (3 reviews)
3.1
3.1
User Avatar
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 in 3 days
5.0 (3 reviews)
2.6
2.6
User Avatar
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 in 7 days
3.2 (6 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$222 USD in 7 days
5.0 (1 review)
2.4
2.4
User Avatar
Hi, We are MS Access developer with experience in Import/export to MS Excel. Pl see our profile and work experience. Thanks.
$166 USD in 10 days
4.5 (1 review)
2.8
2.8
User Avatar
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 in 8 days
4.7 (4 reviews)
2.2
2.2
User Avatar
experienced software professional with 20 years in development and maintenance of applications. I can develop in Access 2007
$222 USD in 5 days
5.0 (2 reviews)
1.8
1.8
User Avatar
I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
$277 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
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 in 15 days
0.0 (0 reviews)
1.5
1.5
User Avatar
I propose to supply a solution as per your specifications using Excel 2007 format. I am available and ready to begin immediately.
$222 USD in 3 days
0.0 (0 reviews)
2.4
2.4
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
EXPERIENCE WITH ACCURACY RELIABILITY IN TIME EXPERIENCE WITH ACCURACY RELIABILITY IN TIME EXPERIENCE WITH ACCURACY RELIABILITY IN TIME
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Stellenbosch, South Africa
0.0
0
Member since Feb 24, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.