Käynnissä

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

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

Projektin tunnus: #15169651

Myönnetty käyttäjälle:

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 [login to view URL] that make changes on coding /forms, reports/ Relevant Skills and E Lisää

$555 USD 10 päivässä
(2 Arvostelua)
2.3

27 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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

$473 USD 10 päivässä
(72 arvostelua)
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 Lisää

$833 USD 20 päivässä
(29 arvostelua)
5.7
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 Lisää

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

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

$750 USD 10 päivässä
(40 arvostelua)
6.0
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 Lisää

$467 USD 10 päivässä
(12 arvostelua)
5.3
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 Lisää

$250 USD 10 päivässä
(35 arvostelua)
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 Пред Lisää

$500 USD 7 päivässä
(58 arvostelua)
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 7 päivässä
(14 arvostelua)
5.0
AhmedHassan1122

A proposal has not yet been provided

$444 USD 5 päivässä
(11 arvostelua)
3.8
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 Lisää

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

A proposal has not yet been provided

$722 USD 7 päivässä
(13 arvostelua)
2.9
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 Lisää

$380 USD 15 päivässä
(8 arvostelua)
3.1
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 10 päivässä
(4 arvostelua)
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 Lisää

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

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

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

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)
0.0
vivirain

A proposal has not yet been provided

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

I can help you

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