Access App development to help run a small business -- 2

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

We need to hire you to develop an app to help us run our business. We are just a team of 2 but the day-to-day operation is getting harder because of our lack of resources and organization.

Therefore we need an App to help us run our business.

NOTE: WE WERE THINKING ON ACCESS, BUT IF YOU KNOW OF ANYTHING MORE EFFICIENT THAN ACCESS, WE ARE OPEN TO SUGGESTIONS. We "upgraded" from excel to access after reading some opinions on the web...

Anyway, here is what we need (PLEASE READ CAREFULLY!):

We need to have a welcome window with 8 buttons:

- New customer

- New project

- Prepare Estimate

- Prepare Purchase Order

- Customers

- Projects

- Import Price Lists

- Back Up / Restore DB

Each button will take us to different functions:

1 • [NEW CUSTOMER] ← Form:

- business name

- email

- phone

- Business address

- Ship to address

- main contact

- other contacts

- other emails, etc

2 • [NEW PROJECT] ← Form:

- Project name

- specifier

- Location

- Brand

- Est shipping date

- Order submission date

- Payment date

- Deposit payment amount

- Balance

- Completed / closed

3 • [PREPARE ESTIMATE]

Based on the loaded EXCEL PRICES LISTS (see above) have a window where I can add a markup amount (any percentage I type) and automatically generate the prices for this form.

The form will have this drop-down windows:

CLIENT (choose from a drop-down window with all pre-loaded clients)

Project (will fill automatically Project Name, Specifier, Location)

Date

Bill To

Ship To

Reference number

Revision Number

Currency

Estimated turnaround

Terms

and then a form to generate this estimate which will load info from the imported EXCEL docs:

BRAND | CODE | QTY | DESCRIPTION | UNIT PRICE | EXTENDED PRICE | TOTAL

At the bottom of the form:

TAX (I decide the percentage) | SHIPPING FEE | GRAND TOTAL

Print button

4 • [PREPARE PURCHASE ORDER] A form with the following things:

Project (will fill automatically Project Name, Specifier, Location)

Date

Bill To

Ship To

Reference number

and then a form to generate this estimate which will load info from the imported EXCEL docs WITH NO MARKUPS:

BRAND | CODE | QTY | DESCRIPTION | UNIT PRICE | EXTENDED PRICE | TOTAL

At the bottom of the form:

GRAND TOTAL

Print button

5 • [CUSTOMER LIST] ←- to show a list of clients

6 • [PROJECTS BOARD] ←- to show a pipeline of projects. It would be nice to see the open orders, the stages they are with checkmarks (I decide which stages to add).

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

WE ARE ALREADY BEHIND SCHEDULE AS WE "HIRED" SOMEONE HERE AND LEFT US HANGIN' FOR 3 WEEKS ALREADY!

Programación de bases de datos Excel Microsoft Access

Nº del proyecto: #18214555

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

wikkipk

Hi, My bid is to deliver this all in 7 days. I suggest to better have a custom web application for your needs which I will build on laravel with an easy to use and nice interface. You are going to need web hosting f Más

$350 USD en 7 días
(3 comentarios)
3.7

7 freelancers están ofertando un promedio de $200 por este trabajo

kevivu

I am based out of NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https:/ Más

$222 USD en 3 días
(72 comentarios)
5.9
reedsystems

Hi there, how are you today? I read your project description and I understand that you intend to upgrade from ms excel to microsoft access database which will be able to track customers, projects and estimates. Más

$250 USD en 7 días
(6 comentarios)
3.5
azmatakhtar

Hi we already had a chat discussion about this on your last project but was no agreed on price. keeping in view future opprtunities i am ok to start this and complete end to end with good UI and automation on 280USD. r Más

$30 USD en 3 días
(2 comentarios)
2.6
sayanprogrammer2

HI I am Xpert P. I am senior Developer and I am Expert in Database Programming, Excel, Microsoft Access. I have completed 200+ based projects in programming with 100% client satisfaction .I have Working experiences of Más

$100 USD en 3 días
(0 comentarios)
0.0
boyalieviskandar

Hi, there! I am very interested in your job. I read your job description carefully and now I am very clear about your requirements. I've been working as a full stack web developer for 7 years and I have a rich exper Más

$200 USD en 3 días
(0 comentarios)
0.0