ICt coursework evaluation

Evaluation

In my evaluation, I am going to evaluate my all objectives (General, Qualitative and Quantitative objectives) as I have done in my design stage of Specification for the new system. I will describe how I have met all this objectives and after that, I am going to tell about some limitations and improvements for the new system.

All Objectives:

The system must be computerized.

I have met this objective by creating the system by using relational database system rather than manual based system. As I have used different features of the database such as tables, report, queries, etc. this shows that the system is more computerised.

The system should have password to protect it.

I have met this objective by using a security password. It controls unauthorised access into the system without the password. Although, the system is protected by a password, all forms do not have password to protect it. If the system is left alone by entering the password, other can access through it easily. Hence, it is only protected at the beginning.

The database should be able to locate any records, which are relevant quickly and efficiently as when end user requires it.

I have met this objective. I have fulfilled my end user’s requirement by setting up the relationship between tables. Once, the record is changed in one location then it will automatically change through out the system. So, there will not be any problems like duplication of data, etc.

It should be relatively easy to add, delete or make new records. For example, add or delete, a customer form the database. Also make simple ...

This is a preview of the whole essay

The database should be able to locate any records, which are relevant quickly and efficiently as when end user requires it.

It should be relatively easy to add, delete or make new records. For example, add or delete, a customer form the database. Also make simple changes in the database, such as correcting the name of a customer.

I have met this objective. I have fulfilled this requirement by creating macros and command buttons on all the forms. I have added macros like add, delete, and add new record, print, etc on all the forms so that it will make the user easier and friendly. Also it can able to make changes or correct the records of the customer by using the macros.

d. Data entry should be quick.

I have met this objective. As I have created 3 forms i.e. customers form, product form and order details form. it will be quicker for the end user to enter the data on the system through the form and I have created and added macro on all the forms so it will makes more easier and faster for the end user to enter data quicker.

f. A main menu should be located automatically when the

database is loaded and the whole system should be menu

driven.

I have met this objective. As I have done start up for the main

Menu so it will located automatically when the database is

Loaded and all forms, reports, etc are opened through menu

Main so, the whole system is menu driven.

The system should automatically calculate the total after discount and add VAT each product.

I have met this objective.

j. The new system should able to record up to 1000 details.

This system has capability to record up to 1000 details.

It should be possible to input new customer, new product, etc in less than 30 seconds.

I have met this objective. As I have created forms for customer and product. It will easier for the end user to input new customer details and product details in less than 30 seconds.

It should be possible to provide reports in less than 1 minute in each in the following.

∙ Customer details.

∙ Total sales by customers.

∙ Total amount of the Sales.

→ This system will give relevant information in the form of

report in less than 1 minute.

l. It should create invoice and show past sales history in less

than 30 seconds.

I have met this objective. This system will able to create

updated invoice of each customer whatever they have

purchased so far and their past history of purchased in less

than 30 seconds.

Limitation of the database:

When I go through my database then I found out limitations of the new system,

In this database, customer will not able to buy 2 different products at the same time so they need to buy each one at different time. This may be limitation which takes longer time both for seller and customers while purchasing 2 different types of products.
I don’t have password for each form..
Limited validation checks- as my system couldn’t ensure correct validation for ‘E-mail’ field.
Less use of macros

Future development for the system

If I could have little more knowledge on database, I would have made the following improvements in my system.