In Progress

Changes to existing database (Access; SQLite; VBA)

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

Skills: Database Development, Excel VBA, Microsoft Access, SQLite

See more: sqlite3_open example, sqlite odbc driver excel, sqlite3 c++, sqlite vba tutorial, sqlite c++ wrapper, sqlite3_open_v2 example, sqlite for excel, sqlite api python, access 2010 vba webcam form, changes existing access database layout, access existing database form, create invoice existing database access, changes existing access database, modify existing database access, open sql database access 2007 vba

About the Employer:
( 41 reviews ) Ottawa, Canada

Project ID: #15169651

Awarded to:


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 E More

$555 USD in 10 days
(2 Reviews)

27 freelancers are bidding on average $539 for this job


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 Expe More

$473 USD in 10 days
(72 Reviews)

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 Aan More

$833 USD in 20 days
(29 Reviews)

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 milest More

$555 USD in 10 days
(26 Reviews)

Hi, I'll do all assignments / Relevant Skills and Experience Access Proposed Milestones $750 USD - default

$750 USD in 10 days
(40 Reviews)

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 an More

$467 USD in 10 days
(12 Reviews)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS More

$250 USD in 10 days
(35 Reviews)

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 Пред More

$500 USD in 7 days
(58 Reviews)

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.

$600 USD in 7 days
(14 Reviews)

A proposal has not yet been provided

$444 USD in 5 days
(11 Reviews)

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# usin More

$555 USD in 10 days
(3 Reviews)
$555 USD in 10 days
(6 Reviews)

A proposal has not yet been provided

$722 USD in 7 days
(13 Reviews)

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 More

$380 USD in 15 days
(8 Reviews)

Nice to meet yoiu. Relevant Skills and Experience I am good in DB and VBA. Proposed Milestones $555 USD - b So i can help you.

$555 USD in 10 days
(4 Reviews)

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 time More

$500 USD in 10 days
(4 Reviews)

Hello,Sir please visit our team site:[login to view URL] High-Quality+fast development+good credit+fast communication=My work method! My first aim is to provide you quality and professional task. i have dev More

$555 USD in 10 days
(1 Review)
$750 USD in 10 days
(0 Reviews)

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 g More

$555 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$666 USD in 15 days
(0 Reviews)

I can help you

$555 USD in 10 days
(0 Reviews)