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

Taidot: Tietokantakehitys, Excel VBA, Microsoft Access, SQLite

Näytä lisää: 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, vba save invoice database access examples, access 2007 vba sort form, vba import database access, clear access database content using vba, access 2007 vba open form sorted, import access database access vba, vba access ado as400 start command, access database required field vba, fillable form adobe feed database access, html form changes mysql database php, vba input form access, access copy address info form vba

Tietoa työnantajasta:
( 41 arvostelua ) Ottawa, Canada

Projektin tunnus: #15169651

Myönnetty käyttäjälle:


Hello. First, create new database on SQL Lite, create all required tables with proper structures. Then import records from old Db to SQL Lite [url removed, login to view] that make changes on coding /forms, reports/ Relevant Skills and E Lisää

555 $ USD 10 päivässä
(2 arvostelua)

27 freelanceria on tarjonnut keskimäärin 539 $ tähän työhön


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 Lisää

473 $ USD 10 päivässä
(72 arvostelua)

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 Lisää

833 $ USD 20 päivässä
(29 arvostelua)

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 Lisää

555 $ USD 10 päivässä
(26 arvostelua)

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

750 $ USD 10 päivässä
(40 arvostelua)

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 Lisää

467 $ USD 10 päivässä
(12 arvostelua)

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 Lisää

250 $ USD 10 päivässä
(35 arvostelua)

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

500 $ USD 7 päivässä
(58 arvostelua)

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 7 päivässä
(14 arvostelua)

A proposal has not yet been provided

444 $ USD 5 päivässä
(11 arvostelua)

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 Lisää

555 $ USD 10 päivässä
(3 arvostelua)
555 $ USD 10 päivässä
(6 arvostelua)

A proposal has not yet been provided

722 $ USD 7 päivässä
(13 arvostelua)

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 Lisää

380 $ USD 15 päivässä
(8 arvostelua)

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 10 päivässä
(4 arvostelua)

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 Lisää

500 $ USD 10 päivässä
(4 arvostelua)

Hello,Sir please visit our team site:[url removed, login to view] 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 Lisää

555 $ USD 10 päivässä
(1 arvostelu)
750 $ USD 10 päivässä
(0 arvostelua)

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 Lisää

555 $ USD 10 päivässä
(0 arvostelua)

A proposal has not yet been provided

666 $ USD 15 päivässä
(0 arvostelua)

I can help you

555 $ USD 10 päivässä
(0 arvostelua)