access database

Completed Posted May 8, 2012 Paid on delivery
Completed Paid on delivery

I want someone to finishto build a very classic and simple access database. I have already done the table and fields. I just want to complete it with forms and information displays.

If you speak Spanish it would be an advantage. I want the work to be done before Thursday night .

You will find some instructions about the project below:

It is a provider database for food products in different countries.

4 tables:

- proveedores(providers): with the contact details of the providers

- Tipo producto: products family (ex cheese, fish etc)

- Productos: more detailed products Ex: cheddar cheese, Blue cheese

- Grupo: sometimes providers are part of an exporting group with other providers; it will contain the details of the group.

Relationship between tables:

- Each Group contains one or more providers but a provider only can be in 0 or 1 group

- Each provider sells one or more type of products

- Each provider sells 1 or more products (which can be of different type)

- A product type or products can, of course, be sold by several providers.

- Each type of products contains 1 or more products. A product is always attributed to 1 and only 1 group

I have already made the tables and relationships, but you can change it if you find better possibilities, and dimension it better because I didn’t do it.

What I would like:

- The main page have to put the list of provider and a way to search them by country type of products and products (list box). And a link to a form to add a new provider.

- When I click on a provider of this main page, it will show the page of the provider, with all his details (table proveedor), but also the type of products and products he sells, and the group he belongs to, if he has one. To modify the details of this provider with a form.

- By clicking to his group name, it will show the page of the group, with all the details of the group (table grupos), and all the providers who belongs to it

- In the form to add a provider or modify one, don’t forget a section Products to put the type of products and products he sells, and group to put the group of this provider if he has one. There will be short subform popup to add new products or a new group if they don’t exist yet.

- You will see that the tables “proveedores and “grupo” have a champ with attachment in order to attach file (pdf, doc etc). These files also have to appear in the page of each provider (if they can open when clicking on it it will be nice) and also in the forms (champ add files)

Database Administration Microsoft Access Visual Basic

Project ID: #1618254

About the project

8 proposals Remote project Active May 10, 2012

Awarded to:

hubert17

Hi. I am a newbie here in Freelancer, a Filipino. I have resigned from my academic world and starting to embrace the online job industry. I am a hardcore Microsoft Access Developer, more than 10 years of experience, wi More

$50 USD in 2 days
(1 Review)
1.8

8 freelancers are bidding on average $136 for this job

srinichal

Let us discuss further details

$180 USD in 4 days
(29 Reviews)
5.5
infoshree80

Greetings! Expert in access and VB. Ready to start immediately. Pls check Pm

$250 USD in 10 days
(22 Reviews)
5.2
oasys1

Greetings, I am fully qualified for this work having been programming in Access since version 2.0 (DOS). Please check pmb for more info..

$100 USD in 2 days
(0 Reviews)
0.0
edwarp

Hola Señor Yo Soy ingeniero de sistemas por casi 8 años, tengo muy buena experiencias trabajando con vb6, vb.net, Access, Ms sql, asp.net, c# entre otros... Estoy seguro que puedo realizar este proyecto sastifactoria More

$175 USD in 2 days
(0 Reviews)
0.0
nnethajireddy

hello sir please give me a chance to work for your project. i will do it. thank you

$45 USD in 6 days
(0 Reviews)
0.0
shamasrehman

I am fully qualified for your job. I will Finish your job very quickly. Regards, Shamas ur Rehman

$90 USD in 2 days
(0 Reviews)
0.0
Steponitgal

I am a South Africa Access / MySQL developer with my own small business, which has been running for approximately 16 years. I have built up skills in a range of disciplines, with my systems running in schools, legal ag More

$250 USD in 30 days
(0 Reviews)
0.0
MARCOELIAS

The term is rather tight bearing in mind that it is still necessary to examine the database, however it is possible to accomplish. I do not speak Spanish yet quite understand because I am Portuguese

$200 USD in 2 days
(0 Reviews)
0.0