Hardware and Software

This brings me to my first disadvantage with Data Power. This is that Data Power is a very competent programme but it’s very outdated. Many pieces of software available are now more advanced and contain more features than Data Power. As a result of its age, many new computers are not compatible with the data power programme. This could increase the cost of hardware and limit the functionality of the programme.

Data Power is also avoidably difficult when it comes to searching. It uses much of the outdated and widely unknown computer language. This means that the users of such a programme will have to have limited knowledge of computers. Also searches are very wide and on large databases may not be practical.

Excel

Excel is a number-processing piece of software. It uses spreadsheets and equations to calculate and test different situations imposed on figures and how they may affect each other. Excel is good for balancing books and stock control as well as a minor model tester. It also has the ability to be used as a database. It has filter functions and limited search functions. It can be easily applied to word mail merge function giving one advantage over other packages. As well as this, it is also found on most computer systems. It is a relatively up-to-date system and is compatible with most systems.

Excel also offers very complex queries. These queries allow you to search a number of things up at once. This is much better that the data powers basic query functions. It has lookup functions. However excel has only one user interface option. in addition to this it has no reports function or forms function.

Word

The purpose of word in this database is to use mail merge. This allows me to fulfil part of the criteria that says that the hotel needs to be able to send special offers to its customers. Word allows you to construct formal letters and files that can be used by mail merge to create personalised files. This would make it easier for administrators to send out special offers.

Chosen Software  

 I have chosen to use access. Access adaptable. You can make your own user interface designs as well as it being compatible with a lot of computer formats. Other reasons for my choice of excel is that I have access to access so it will be easier for me to make the database on access. Another reason for this choice is that access offers a wide range of query functions. These will allow me to set up the complex queries that are needed to perform the task the database was made for.