Em Andamento

Simple 2 day project: Create a prototype, demo microsoft Access application with VBAcode

I am a developer with several years experience (C, C++, C#, Java, Python etc). I also have a lot of experience working with 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 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 unsuccesful 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 (Loan appl, collat reg) 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 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 code 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

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 proc check permission table and return boolean based on if user has role or not)

Note: Maximum bid for the project should be in the region of $100, as the project should not take more than 2 days to complete

Habilidades: Microsoft Access, SQL

Veja mais: working prototype, what is on a background check, what is in a background check, what is a search string, what is a background check, what a developer should have, vba access developer, string hash, sql developer postgresql, sql code oracle, simple prototype, search for the application, prototype how to, prototype forms, prototype create form, procedure sql oracle, parts database access, oracle sql documents, Oracle Database developer, my sql databases

Acerca do Empregador:
( 74 comentários ) United Kingdom

ID do Projeto: #5987763

5 freelancers estão ofertando em média $629 para esse trabalho


Hello, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could produce a functional and user friendly Mais

$2500 USD in 45 dias
(23 Comentários)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mais

$147 USD in 3 dias
(16 Comentários)

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 Mais

$277 USD in 5 dias
(1 Comentário)

Sir/Madam, Greetings. This is an IT person and an experienced MS Access database developer.I have done many such tasks with corresponding write ups . Send me the database and let me know your desired timeline & Mais

$120 USD in 2 dias
(5 Comentários)

hi from spain, its easy for us doing your Project, we are accustomed to make physics & Engineering projects, VBA, Access , SQl Server etc its easy for us, 2 days ts a lot of time : ) Our work is Quickly and with Mais

$100 USD in 2 dias
(0 Comentários)