Choice of software - I have decided to construct the system on Microsoft Access.

ICT DESIGN YASSIR ELAMIN

DESIGN

Choice of software

I have decided to construct the system on Microsoft Access. The software allows easy use and enables data and information to be presented in a clear straight forward way. This is due to a number of features contained within Access. By utilising some of these features, I will be able to construct a system, which is easy to understand as well as being user friendly. Access will allow me to construct tables by which data and information is recorded through the use of forms. This will allow the user to record data with the greatest of ease. There are a number of other key features, which will be used to construct the appointment system. These are as follows;

Macros: These will allow me to automatically execute an operation at the click of a button.

Queries: These provide an easy way of asking questions of the database and getting it to produce useful and relevant information to those questions.

Reports: This is a way of presenting data on the screen or in print format, for example generating a report on the progress of a job.

Protection: This feature will enable me to protect the system from unauthorised access to data and information stored on the system.

Data validation: This will help the user to enter the correct information at certain locations.

Formatting: This will allow the data and information stored in the database to be presented clearly and easily by the user.

Calculations: This will allow the system to automatically do any calculations, making it easy for the user to use the system.

Therefore by using Microsoft Access software it will enable me to meet all the requirements of the new system, that is, it will allow me to overcome some of the key problems of the old system.

System overview

When the system is opened, the main switchboard will automatically execute. This will give the give the user a number of options, for example adding a new customer. All the user has to do is to select an option and using the mouse click on the assigned button. At all times there is an exit button, along with a number of other options. If the user wishes to return to the main switchboard all they need to is to click the exit button. Depending on where the user wants to go, all they need to do ...