Developing Ideas

Solution:
I would prefer to use Microsoft Access to create database as I am comfortable using it and it seems to be the easiest option available to me. It is easy as I can create queries and forms based on the table with no difficulty.
Queries can make it easy for customers to select views that concerns them. As this will be less time consuming than going through the whole table.
Forms can make the order for the delivery of the product easy and quick. I find making forms on Microsoft Access easy and understandable.

Global Context:
Scientific and technical Innovation - I am being innovative by finding and creating new ways of presenting data in an organised way for a company that is in the food/treat business.

Resource List (materials needed for my project):

• I would need to be provided with the fields required and the records to organize the data on a table where forms and queries can be derived from.
• Microsoft Access needs to be available for usage as I require it to form my database. 
• Gantt chart to be organized and be able to complete my work under a certain time limit.   

Gantt Chart:
This is a schedule for me to follow when I'm creating the database.

• For the first step I will need to download Microsoft Access to create the database
• Then I will need to review any existing records to help with the beginning of creation of the database.

Then I will begin using Access I would have to create a table consisting of fields and records to create queries and forms for clients.
I will be creating 2 tables one for the product and one for the supplier and from this I can create forms and queries for each.

Product Table:
Name of Fields

Identification code

Candy Name

Type of Candy

Number in Stock

Identification code - Text (1 letter followed by 4 numbers) Candy Name - Text Type of Candy - Text No. in Stock - Text
Supplier Table: Name of Fields Supplier Name of Candy Amount supplied Time frame between the supply of the product Supplier - Text Name of Candy - Text Amount Supplied - Text Time frame between production dates - Text Queries and Forms: Each database will include a form and 2 queries. Queries are question that the user may have that has been answered in the database. I have not come up with any queries for now but will do so when I create my data base. A form is an application in which the buyer of the product must give certain details if he/she may need the product delivered to them for example the candy type and flavour they wish to purchase and the amount of that candy they would like.  Plan Evaluation: I would need to begin with with the supplier table as we would need to organize the way the company buys their candy plus we would need the candy to sell. The production table won't take time as it is easier than the supplier table because you would not have to call anyone. The supplier table will be the hardest because I would have to call condy producers to confirm details and the name of the candy that my client would be buying from them. For the supplier table I would need someone from Trick 'o' Treat Candy Production to help me with the contacts, names and amounts which I'm sure I can find in one of the company's existing ways of keeping records.