Developing Ideas

Solutions:

The easiest solution would be to create a database on Microsoft Access as this will allow them to interact with the data tables easier. It is extremely efficient as it is easy to input data using the data forms that are quite user friendly. The queries make it easier to select and view sets of information grouped by common criteria. This allows for selecting and moderation of information easily and without searching for information. The results of queries can be printed out as a professional report, allowing for easy access of the data as a hard copy.

The other method, involves using Microsoft Excel to create tables and this is less user friendly and does not include the ability to create data entry worksheets and query reports.

The solution that would be the easiest would be to use the Microsoft Access as it has a user friendly interface for the client to use and allows them to create reports of query that they can run.

Gantt Chart:

Step 1: The Learning of Access will begin by experimentation, to understand the many different aspects of it. This will allow self-exploration to figure out how to enter the tables and data into the program.

Step 2: The creation of the tables will take a long time as we have many fields that need to be entered, there will be two tables one for the distributors or sellers and one for the suppliers. One table will keep track of all the sales made by the company using the cashier as the person to input data every time that there is a sale. The other table will keep track of all the supplies that are brought in weekly or monthly, the table will contain data about the suppliers and the stock. 

Step 3: Data input can be implemented by the data entry form which will allow ease of input of data and this will allow me to input the data easier.

Here are my plans for the tables