Create a prototype, demo microsoft Access application with VB extension in C#

I am a developer with several years experience (C,C++, C#, Java, Python etc). I also have a lot of experience designing databases (MySQL, PostgreSQL, Oracle and some Sybase). I come from a strong Linux background, but have also used Microsoft products (Access, Visual Studio etc) in the past.

I need to quickly develop a Microsoft Access (2010 or later) database application. I have already started the application development, but need someone who is more experienced in with Access/VBA/C# to put together parts of the application that would otherwise require me to do a lot of reading, trial and error etc to implement my self.

I have designed the database schema for the application - you will be provided with the schema. The schema is for a SQL Server database. The project involves a backend database (SQLServer), and a frontend consisting of forms, reports and GUI which will be designed in Access.

The point of this project is to provide cookbook type instructions (via implementation) for functionality that I need in the application but will require a lot of reading/experimenting etc (i.e. time), if I were to implement it myself - so I need someone who will be able to pickup from what I have done so far, and implement the parts that I need, so I can learn how to do this (by looking at their example).

The project functional requirements are listed below:



1. Starts up and displays modal login dialog box

* Password stored as hash in backend database

* After N unsuccessful logins user logged out, admin user has to unset user

* On successful login Application starts, no Access Ribbons, menus or toolbars etc -

the application looks like a standalone application, with no indication that it was built using access

2. Demonstrate how to call stored procedure from VBA (passing arguments from VBA)

* stored procedures with the following prototype specifications:

i. accepts the following simple data types (int, bool, string, double, double[])

ii. separate procedure with the following return types

a. returns int

b. returns bool

c. returns string

d. returns double

e. returns double[]

f. returns Table (i.e. Recordset)

3. Create 2 MS Access forms that are equivalent to provided MS Word documents

i. One of the forms will require to be implemented via wizard (because of multiple fields)

ii. Demonstrate loading picture to form (picture to be stored on file path, NOT in database)

iii. CRUD and search functionality for objects created from forms

4. Create 3 Access reports (disbursement, client registration receipts, cash register) that are equivalent to provided MS Office documents

5. VBA extension library in C# which will provide the following functionality:

i. Database connection

ii. Running stored procs and returning results

iii. Running queries and returning results

iv. User permissioning layer

user permissions are implemented through database tables (see db schema)

i. allow role change

ii. enforce permissioning (either throw Exception from Db server or have stored procedure check permission table and return boolean based on if user has role or not)

Note: The maximum acceptable bid for this project is $100. Bids above this will be automatically rejected, because if nothing else, it shows a lack of attention to detail.

The existing Sybase schema, access application and Office documents will be provided to bidders, once I have established that you are capable of implementing the project as specified.

Færdigheder: C# Programmering, Microsoft Access

Se mere: what shows up on a background check, what is vba programming, what is python programming used for, what is on a background check, what is java programming used for, what is in c programming, what is in a background check, what is a string in programming, what is a search string, what is a library in programming, what is a background check, what i need to develop with java programming, what do you need to learn java programming, what can you do with python programming, what can you do with java programming, visual programming python, vb note, vba access developer, string search in c, string library in c, string library c, string in c programming, string hash, sql developer postgresql, simple prototype

Om arbejdsgiveren:
( 74 bedømmelser ) United Kingdom

Projekt-ID: #5983493

4 freelancere byder i gennemsnit $489 for dette job


i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communication skills Mere

$773 USD in 3 dage
(2 bedømmelser)

Hi, when is your deadline? Also, why do you need that developed in Access (with all the limitations of vba) and not in Visual Studio as a standalone application?

$100 USD in 15 dage
(5 bedømmelser)

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli Mere

$833 USD in 10 dage
(0 bedømmelser)

Thanks for the opportunity to bid on your project. I have read your bid and understand your requirements. I shall bring over 20 years experience in the software industry with very strong VB/VBA and Microsoft Access Mere

$250 USD in 10 dage
(0 bedømmelser)