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

Cancelado Publicado May 24, 2014 Pagado a la entrega
Cancelado Pagado a la entrega

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:

Requirements

------------------

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.

Programación en C# Microsoft Access

Nº del proyecto: #5983493

Sobre el proyecto

4 propuestas Proyecto remoto Activo May 25, 2014

4 freelancers están ofertando un promedio de $489 por este trabajo

geogeorge2

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 en 15 días
(5 comentarios)
3.7
pnjadhav

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 Más

$833 USD en 10 días
(0 comentarios)
0.0
Pharoa

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 Más

$250 USD en 10 días
(0 comentarios)
3.6