Changes to existing database (Access; SQLite; VBA)
$250-750 USD
Tamamlandı
İlan edilme: 6 yıldan fazla önce
$250-750 USD
Teslimde ödenir
The selected developer will be provided with an Access project (Access 2010; *.accdb) that contains a database, a switchboard, a print feature and seven existing reports.
We hope to select a coder on September 19.
The work required is as follows:
1. Database
a. Replace the existing access database with SQLite
b. The existing database contains less than five tables, and less than 30 fields
c. “Category” and “Categories”: replace these words with “Group” and “Groups”
i. In database fields/tables, as well as Switchboard elements and reports
d. Split “Role” into “Time” and “Imp”
i. Currently, there is a table called tblRoles – replace this table with two new tables, tblTime and tblImp. Both of the new tables will have the same config as the existing tblRoles – alter field names according to the new table name
e. If data entered by user exceeds that available in a given field, inform the user of the limit and that it has been exceeded.
f. Maintain ability to use and paste international characters (for example, those commonly used in French)
2. Switchboard
a. Alter existing switchboard (and all 6 underlying screens/forms) to reflect the changes to the database (new fields , new names, etc. as described above)
3. Print feature
a. This feature is access via a command button in frmSOP form
b. Alter the print feature to reflect changes in the database
4. Reports
a. Alter existing reports (there are 8 reports, referring to 5 queries) to reflect the changes to the database (new fields etc, as described above)
5. Migration Tool
a. Develop and provide a mechanism to allow the migration of data contained in the existing *.accdb database into the new SQLite database.
6. Ensure the resulting product
a. is compatible with Windows 7 and later versions of Windows
b. allows undistorted pasting from other applications
7. In your bid on this project, we request that you include:
a. Your fee for fully delivering on this project
b. Your project timelines (for example, date by which you will deliver your prototype solution for testing by us; how quickly you expect to respond to comments, bugs we identify )
c. Any questions you wish us to answer at this time
d. Support you will provide for your work, after the project is fully completed and paid
Hello. First, create new database on SQL Lite, create all required tables with proper structures. Then import records from old Db to SQL Lite [login to view URL] that make changes on coding /forms, reports/
Relevant Skills and Experience
During 2007-2012, i'd been working as a senior developer for the Financial system developed in MS Access. I am experienced with MS Access programming more than 10 years.
Proposed Milestones
$55 USD - Describe full detail requirements and start the project
$100 USD - After 5 days starting the project, will show you first version with SQL Lite database for testing
$400 USD - Finalize any bugs, other developments after testing and complete the project.
Additional Services Offered
$1 USD - If any errors after completed, will fix without charges.
$1 USD - If new requirements, discuss and work with charges /reasonable price/.
Is this system must be multi user?
$555 USD 10 gün içinde
4,9 (7 değerlendirme)
4,4
4,4
25 freelancer bu proje için ortalama $540 USD teklif veriyor
Dear, we are Team of French + US.
I checked your project description, I can develop your MS-Access program.
As you can see I have very good rate, you can be sure I am serious.
Regards,
Fabrice
Relevant Skills and Experience
Access
Proposed Milestones
$473 USD - milestone
Do you want to work with SQLite DB from Microsoft Access? I am ready to carry out your project in the shortest possible time and with the highest quality!
Соответствующие навыки и опыт
Microsoft Access, SQL, vba
Предлагаемые промежуточные платежи
$250 USD - Prototype solution for testing
$250 USD - Project completed
Support is guaranteed. I'm not an intermediary.
Hello Sir,
I am an expert MSACCESS developer and interested in this project. I believe about 20 days to complete this project.
Please open chat to discuss more details about this project and my approach.
Thanks
Aanvik
Greetings,
I am expert in SQL and VBA. and i am working here 18 hours in the day. so please give me chance to work on your project. will serve you the 100% results.
Stay tuned, I'm still working on this proposal.
Migrate an MS Access database to SQLite, following all the items listed in your project briefing
Relevant Skills and Experience
MS Access
Database Development
SQLLite
SQL
Proposed Milestones
$155 USD - Initial milestone upon acceptance of the project
$400 USD - Final milestone when all items listed in briefing are completed
Would you like to discuss any specifics via chat?
I'm a Database Developer. I can provide changes to your existing databases. I'm very good at Access VBA and database programming. I am delighted to take on your projects. I have 100% completion rate
Relevant Skills and Experience
• Web Architecture.
• Access VBA Scripting.
• SQL Programming.
• Database Programming & Development.
• Business Intelligence Development.
Proposed Milestones
$167 USD - Project
$150 USD - Project
$150 USD - Project
Hello, I have gone through the project description and the following are my responses to your questions;
a. Your fee for fully delivering on this project
"$500", milestones to be agreed upon.
b. Your project timelines (for example, date by which you will deliver your prototype solution for testing by us; how quickly you expect to respond to comments, bugs we identify )
"I will provide the prototype for testing in 7 days. I am almost always available online and will be available to work on issues identified."
c. Any questions you wish us to answer at this time
"Access/VBA does not natively support SQlite and would required external plugins. This is not a problem. After the migration, are you primarily concerned with Access as the application front , or would you accept alternative solutions for the front-end?"
d. Support you will provide for your work, after the project is fully completed and paid.
"I will be available to assist with functionality issues that may need to be rectified, explanations, optimizations that are within the project the current project scope. We can discuss additional functionality which maybe outside of the original scope."
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional.
Relevant Skills and Experience
VBA and Excel,Word,Office Applications
-- Expert on C# using .NET framework using Visual Studio 2012 and 2013
-- Database development,Access,Oracle and MySQL
-- WPF and Windows Forms Application
Proposed Milestones
$555 USD - Database Development
Hi, I can develop this solution in about 2/3 weeks.
I can answer instantly via chat (using also freelance mobile app), but really support on issue when I'm at the PC (of course). I will be at the PC for sure from 8.00 AM to 19.00 PM (Central European TIme).
Offer free support after the delivery of the solution for a couple of week at least. Of course the support has to be considered for defect or minor changes, other big changes need to be discussed.
If you are interested in working with me, please contact me, so we can discuss with the details (have so many question on the solution).
I have worked on databases and various other IT technologies since 10 years.
Dear Sir/ Ma'am,
I am interested in this project as it is exactly within the scope of my team.
Over the last few years, we’ve worked with a variety of clients in SEO, Website Development and Designing. I have gone through your complete project description and ready to start from today to develop your product as per your requirements in given terms and timeline.
We are working in the field of website designing and development from 7+ years. We build user focused, flexible and SEO optimized websites. I understand that you are looking for a expert who can work with you to deliver a perfect end product.
We will do complete testing of finished product for bug fixing and other issues, to deliver you an absolute product.
Waiting for your response.
Thanks & Regards
Softsketch
Please come forward for a discussion.
Hello,
I vahe 10+ years experience with as a developer.
Lately i have developed several applicatons using Access as interface and SQL database to store the app data.
Regards
Please contact me for demo, if you are interested.
I am going to show a few apps, with SQL in the back.
I can start working immediatly and deliver a draft version for less than a week.
I can react to found bug right away.
Regards
A seasoned Software Developer with 10 yrs of experience with different Programming Languages and Database. Self Supporting and motivated person being able to commit and deliver in a timely manner.
Relevant Skills and Experience
A seasoned Software Developer with 10 yrs of experience with different Programming Languages and Database. Self Supporting and motivated person being able to commit and deliver in a timely manner.
Proposed Milestones
$555 USD - Final Output
Additional Services Offered
$10 USD - Maintenance
I know your heart is set on SQLite, but consider this. I can set up most CUSTOM database applications within a week for just $250.
Relevant Skills and Experience
During twenty years of creating database applications for clients, I developed a method to support a diverse set of CUSTOM applications.
Proposed Milestones
$271 USD - Transaction Editor Setup and Test Drive
$1 USD - * Spreadsheet ease-of-use * Forms processing * Customer/Vendor/Employee Portals
$1 USD - * Custom reporting * Accountability of a database * Save SEARCHES and SORT on multiple columns
$1 USD - * Recover from mistakes with CHANGE HISTORY LOG * Column and Row-defined MULTI-USER ACCESS
$1 USD - * EMAIL PDF proposals/orders/bills/invoices/requisitions/reports
$1 USD - * SCHEDULED and EVENT-based updates * Automated NOTIFICATIONS * Flexible WORKFLOW Management
$1 USD - * Highly RELIABLE and SECURE * and so much more...
Additional Services Offered
$1 USD - INCLUDES ALL SERVICES in a single plan: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT.
$1 USD - Reply or Search for "Konduit Transaction Editor" for additional capabilities.
What is the functional purpose of your application?