ICT Specification for a spreadsheet for the Hairdressing business

The specification points ar very useful because they are like a shopping list and divine service us to seduce sure we follow a list of requirements that are important in order for us to ensure that the arranging that we entrust create exit be able to do certain things in the list below. To slang a list of specification points so that when it comes to planning and creating the spreadsheet it will be much easier for us. The list below is extra support and a useful list to guiding me when I create the spreadsheet for the Hairdressing business.1. Allows creating a conflict system for warning an aristocratical way to organise all the clients in a useful way for example in alphabetical order.The qualification system is able to keep and organise the clients details in alphabetical order this can be done by left clicking travel order.1. The system should be allowed to create queries such as multiple criteria or simple search criteria search. To overhaul find for only certain clients that I choose to find for example if I there is a usher out on womens haircuts so then I will need to identify only females in the system.Queries can be do on the system for example multiple or simple searches. This will assistance to identify the people that are only needed to find.1. I will commence a validation rule to minimise errors in the selective informationbase. E.g. carriage check or a formula checks in the system.Validation rules convey been entered to reduce the amount of errors occurring in the database system In order to moderate the records correct and up to date.1. The system must be able to ask a photographic print button and nonwithstanding the work quickly and slow I will have a print or save button.The system I have created will have a print button on it.1. I should be able to edit for example to delete old clients and store details and keep record of the data and keep record up to data and late(a).Records on the table are able to be stored deleted and kept up to date on the recent data.1. Include a menu page for the system to attract it easy to navigate from page to page and this should help get us slow from page top page.My system has a menu page in order to help to ease the use of navigation1. Include a primary let out to give clients in the system a uncomparable number so it will be easy to find him or her with reference to that specific unique number that is supplied to them in the system.The primary cardinal has been put on the book ID field because this is recognised to be the key field.1. To have a pricker up strategy in show window the system is hacked into or is lost or damaged so the back up syllabus is a USB or a CD containing the program/system on it and their details.The information has been stored on my USB and that there is anti-virus is stored to prevent either data or memory loss.1. To have tables and then link the tables unneurotic by relationships and this should mystify it easier for th e user to navigate from page to page quickly.Relationships have been attached to both the tables the Customer details table and the Appointment booking table.1. I will create a form that will make it another(prenominal) way of presenting the information to the user or the receptionist.Forms will be created to help make the reading of the details and the information easier for the person use it.The testing that we had previously carried out helped to improve my system and the evaluation has helped to make sure that all the criteria of the specification points have been met. The specification points have helped me to exculpate out the task as a whole more efficiently and to make sure it has appeared on my database the way I have precious it to turn out. Testing made sure that all the specification points were all able to be fulfilled and achieved but at the same cadence realistic in order for me to carry them out efficiently.The new database system can now carry out some new and awe-inspiring functions it can now make the spreadsheet function well. For the database I have made macros/ navigation buttons to help make moving from one table to another much more simpler and easier. The Database will help me to store my information and store the data precisely in ascending order.There have not been many problems that have occurred from the database that I have created because the database thats been created has hardly and errors and is mathematical operation well it seems to be making good progress. The database has been made with the purpose to help to make sure that the new Hair Salon will be able to function properly. The two tables that I have created will help me to quickly find out which appointments have been appointed for which person and which person and the customer details have been sorted to keep them safe and in a more reliable way. This also makes it easier to view the information for severally customer.