Em Andamento

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

Habilidades: Desenvolvimento de Banco de Dados, Excel VBA, Microsoft Access, Microsoft SQL Server

Veja mais: 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, open sql server 2008 database access 2007 vba, vba copy database access, ms access close database specific time vba, invoice database access vba, access 2007 vba sort form runtime

Acerca do Empregador:
( 41 comentários ) Ottawa, Canada

ID do Projeto: #15169651

Concedido a:


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 Mais

$555 USD em 10 dias
(2 Comentários)

27 freelancers estão ofertando em média $539 para esse trabalho


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 Mais

$473 USD in 10 dias
(72 Comentários)

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 Mais

$833 USD in 20 dias
(29 Comentários)

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 Mais

$555 USD in 10 dias
(26 Comentários)

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

$750 USD in 10 dias
(40 Comentários)

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 Mais

$467 USD in 10 dias
(12 Comentários)

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 Mais

$250 USD in 10 dias
(35 Comentários)

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

$500 USD in 7 dias
(58 Comentários)

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 dias
(14 Comentários)

A proposal has not yet been provided

$444 USD in 5 dias
(11 Comentários)

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 Mais

$555 USD in 10 dias
(3 Comentários)
$555 USD in 10 dias
(6 Comentários)

A proposal has not yet been provided

$722 USD in 7 dias
(13 Comentários)

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 Mais

$380 USD in 15 dias
(8 Comentários)

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 dias
(4 Comentários)

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 Mais

$500 USD in 10 dias
(4 Comentários)

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 Mais

$555 USD in 10 dias
(1 Comentário)
$750 USD in 10 dias
(0 Comentários)

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 Mais

$555 USD in 10 dias
(0 Comentários)

A proposal has not yet been provided

$666 USD in 15 dias
(0 Comentários)

I can help you

$555 USD in 10 dias
(0 Comentários)