I gang

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

Færdigheder: Databaseudvikling, Excel VBA, Microsoft Access, SQLite

Se mere: 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

Om arbejdsgiveren:
( 41 bedømmelser ) Ottawa, Canada

Projekt-ID: #15169651

Tildelt til:

Altantsetseg

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 Mere

$555 USD in 10 dage
(2 bedømmelser)
2.3

29 freelancere byder i gennemsnit $529 for dette job

fabest

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 Mere

$473 USD in 10 dage
(72 bedømmelser)
7.2
aanvikm

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 Mere

$833 USD in 20 dage
(29 bedømmelser)
5.7
zu02

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

$750 USD in 10 dage
(39 bedømmelser)
6.0
fuentro

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 Mere

$555 USD in 10 dage
(26 bedømmelser)
5.8
royalcalif

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 Mere

$250 USD in 10 dage
(34 bedømmelser)
5.3
fanninson45

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 Mere

$467 USD in 10 dage
(12 bedømmelser)
5.3
VladimirLilenko

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

$500 USD in 7 dage
(57 bedømmelser)
5.3
schoudhary1553

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 dage
(11 bedømmelser)
4.9
$555 USD in 10 dage
(6 bedømmelser)
3.7
abhinovpankaj

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 Mere

$555 USD in 10 dage
(3 bedømmelser)
3.6
AhmedHassan1122

A proposal has not yet been provided

$444 USD in 5 dage
(10 bedømmelser)
3.7
riccardopepe

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 Mere

$380 USD in 15 dage
(7 bedømmelser)
3.0
polarjin2017

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 dage
(4 bedømmelser)
3.3
gr8tech

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 Mere

$500 USD in 10 dage
(4 bedømmelser)
3.3
arcan08

A proposal has not yet been provided

$722 USD in 7 dage
(13 bedømmelser)
2.9
xiqian88

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 Mere

$555 USD in 10 dage
(1 bedømmelse)
3.0
wenjin211

hello,how are you. i read your bid carefully. i am c/c++, sqlite database, access database expert and have full experience for 10 years. c++ language is my top skill. i can provide most quality and high speed. if y Mere

$555 USD in 10 dage
(0 bedømmelser)
0.0
davidrudd

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 Mere

$277 USD in 5 dage
(0 bedømmelser)
0.0
$750 USD in 10 dage
(0 bedømmelser)
0.0
simontidon

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 Mere

$555 USD in 10 dage
(0 bedømmelser)
0.0