Queries can be made on the system for example multiple or simple searches. This will help to identify the people that are only needed to find.
- I will have a validation rule to minimise errors in the database. E.g. presence check or a formula checks in the system.
Validation rules have been entered to reduce the amount of errors occurring in the database system In order to keep the records correct and up to date.
- The system must be able to have a print button and save the work quickly and easily I will have a print or save button.
The system I have created will have a print button on it.
- 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 recent.
Records on the table are able to be stored deleted and kept up to date on the recent data.
- Include a menu page for the system to make it easy to navigate from page to page and this should help get us easily from page top page.
My system has a menu page in order to help to ease the use of navigation
- Include a primary key to give clients in the system a unique 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 key has been put on the booking ID field because this is recognised to be the key field.
- To have a back up strategy in case the system is hacked into or is lost or damaged so the back up program 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 any data or memory loss.
- To have tables and then link the tables together by relationships and this should make it easier for the 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.
- I will create a form that will make it another 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 using 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 carry out the task as a whole more efficiently and to make sure it has appeared on my database the way I have wanted it to turn out. Testing made sure that all the specification points were all able to be fulfilled and achieved but at the same time realistic in order for me to carry them out efficiently.
The new database system can now carry out some new and amazing 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 that’s been created has hardly and errors and is functioning 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 each customer.
Samia Ahmed 11T/GA