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.
- 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)
8 freelance font une offre moyenne de $136 pour ce travail
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