Implementation of ict project

Authors Avatar

Tarif Talukdhar

 

This is the main screen of my database; from this screen the user can access all the pages from this menu. I have assigned a macro to each button to take the system to the correct place. I will be accessing the order sheet from the main menu screen below.

As you can see I have accessed the order sheet from the main menu screen.

This is a screen shot of my stock sheet data it shows items which I have in stock, shown above. The sheet includes a macro which allows the user to return to the main menu.

This was the current weekly sales made sheet, there are few errors on the sheet. For example the sheet is not named also there is not a price column, without this the total sales cannot be worked out. Also there are no macro buttons, or drop down lists.

This is the new weekly sales made sheet and is all up to data. The sheet above includes three macros, these are print screen. This allows the user to print out the weekly sales sheet. So he can keep it as a transaction of what he has brought. Another macro added on the sheet is save sheet, this allows the user to save the sheet so he can view it later. This is an improvement to the system as it wasn’t in the User requirements. I have added it because this data will need to be saved so that the user can look at what is selling well over some time for example. Other macro buttons added are main menu this allows the user the user to go back to main screen, to access any other page.

 

   

   

   

 

 

The weekly sales sheet also uses data validation, in the form of a drop list. This means users cannot enter any data except what is being shown from the stock database.

The sheet above shows my supplier sheet; on the sheet is the data which I have entered via add new supplier. The end user can then add more suppliers to this sheet, using add new supplier sheet. Also on the sheet is a main menu macro which allows the user to go access any page from main menu.  

The problem with this order sheet is that it does not have a print screen button. This button allows me to print of the sheet and show what I have brought. Another macro button needed is update stock; this button allows me to update the stock I have brought to the main stock data base. Also missing from the sheet is a main menu button, which allows the user to access other pages. There is no validation shown on the page so users can enter anything they want. The new updated order sheet is shown below:

As you can see on the sheet all three macro buttons are on, these allow the end user to achieve what it wants in the user requirements. Data validation has also been added to the sheet, this means the user can select items without having to type them in. This also means the user cannot type in any erroneous data thus saving time.

Join now!

The screen shot above shows my add new supplier worksheet. As you can see the sheet includes three fields these are suppliers name, phone and email. The end user enters information in these field manually, then uses the add supplier macro to transfer this data to the supplier sheet database. Also on the sheet is a main menu macro button.

The add new stock sheet allows the end user to enter data in the fields above, the user can enter one size or a variety of sizes. The information the user enters is transferred ...

This is a preview of the whole essay