create Marketing console

Completado Publicado Apr 28, 2009 Pagado a la entrega
Completado Pagado a la entrega

We need a person to help create a system that would consist of the tables and forms for the marketing department's control console. This piece of the system would be used to enter all marketing items/literature into the appropriate tables supporting the system. The programmer needs to be able to create the tables (which we have designed) and the forms populated with grids, combo boxes, text fields etc - that would be used to input the data about the marketing literature into the system.

You will need to use mysql or msaccess or microsoft sql for the backend and visual basic 6 or vb.net for the programming language.

## Deliverables

The program would be utilized by numerous departments. The ad material would be inputed into the system by the marketing department. Once the material is in the system the sales staff would be able to view it on a new popup window in their system that would allow them to select items from the listing and add it to a media order to ship to the client.

An order would be make with the appropriate details from the sales person efforts and then the shipping department would ship the order to the client.

The first part of the system is the tables and form in the console that the marketing department would use to enter all the marketing items into the system.

The first grid would contain the following info and the date and time entered should be taken from the system clock when the item was entered in the form

| Brochure Name | Description | Qty | Date

Counted | Item ID | Date Entered | Company |

| | | | | | | |

| | | | | | | |

The item id should be an auto-number assigned to the entry from the database engine.

The tables/table supporting the form that this grid is on would be:

MarketMaterial

ItemID autonumber

Company text 35 would be selected from a populated company combo box.

Itemname text = 80

ItemDescr text = 200

Qty long

Datecounted date automatically offer the date using a calendar object

DateEntered timestamp entry into the database

The marketing department also desires to take the items that are entered into the above described (table and grid) and create/design packets of marketing material. These packets would also have names and be displayed in a very similar grid as discussed above. The packets would be created by creating a name for the packet and then double clicking on the appropriate items in the first grid which would copy the info over to the second grid that defines the informational packets.

PacketTable

PacketID autonumber

Company text 35 would be selected from a populated company combo box.

Packetname text = 80

PacketDescr text = 200

Qty long

Datecounted date automatically offer the date using a calendar object

DateCreated timestamp entry into the database

ExpireDate date

PacketItems

PacketID Long = the packetid that is being defined

ItemID Long = the item id of the marketing literature that is a part of this packet

DateCreated timestamp entry into the database

The database behind the program could be MS-Access or mysql for making the program.

We also need this table which will associate certain products with appropriate literature.

ProductAssociatingTable

ProductID

ItemID

PriorityValue

.NET Ingeniería Microsoft Microsoft Access MySQL PHP Arquitectura de software Verificación de software SQL Visual Basic Windows Desktop

Nº del proyecto: #3844199

Sobre el proyecto

12 propuestas Proyecto remoto Activo Apr 30, 2009

Adjudicado a:

zech77

See private message.

$127.5 USD en 10 días
(19 comentarios)
4.7

12 freelancers están ofertando un promedio de $301 por este trabajo

ashutosh9910

See private message.

$131.75 USD en 10 días
(42 comentarios)
5.4
designbasket

See private message.

$212.5 USD en 10 días
(27 comentarios)
4.7
priyadarshinitec

See private message.

$408 USD en 10 días
(12 comentarios)
4.8
qualitysoftdev

See private message.

$102 USD en 10 días
(7 comentarios)
4.2
tfxthegreat

See private message.

$85 USD en 10 días
(6 comentarios)
3.6
cliffbesley

See private message.

$255 USD en 10 días
(10 comentarios)
3.3
plam0711

See private message.

$85 USD en 10 días
(3 comentarios)
2.3
dkalexm

See private message.

$127.5 USD en 10 días
(4 comentarios)
0.8
collectorinspain

See private message.

$297.5 USD en 10 días
(1 comentario)
0.2
garchin

See private message.

$85 USD en 10 días
(0 comentarios)
0.0
gigilorian

See private message.

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