Database Window: The database window was changed to accommodate the new objects exposed in Access 2000, to enhance usability and to be consistent with the new user interface metaphor used throughout Office 2000.
Name AutoCorrect: This new feature automatically resolves the common side effects that occur when a user renames a database object. For example, when a user renames a field in a table, the change is automatically propagated to dependent objects such as Queries and Forms so the user can continue to work with the application.
Conditional Formatting: Conditional Formatting provides support for negative and positive numbers, and values that can be expressed as less than, greater than, between, or equal to. In addition, users will be able to format based on user-defined functions. Based on the value, the user can set font, styles, banners and colors.
Subdatasheets: Subdatasheets provide a picture-in-picture view to focus on and edit related data all in the same window.
Drag and Drop to Excel: Users can now export data from Microsoft Access to Microsoft Excel simply by dragging and dropping Access objects (tables, queries, etc.) from the database container to Microsoft Excel. This allows a fast way to export data into Excel quickly for further analysis.
Form Enhancements: Now it’s even easier to make changes, such as colors or fonts, to fields directly from within the Form view.
Form Enhancements: Now it’s even easier to make changes, such as colors or fonts, to fields directly from within the Form view.
Print Relationships Wizard: Access now offers the ability to print a visual diagram of the Relationships window, which makes it easier for users to see how the database is structured.
Control Grouping: This functionality allows users to group controls as a single unit to make form design easier.
Report Snapshot: Users can create snapshots of Access 2000 reports that can be distributed to a disk, printer, Web page or e-mail.
Compact on Close: Access 2000 automatically compresses a database when the file is closed if the reduction in disk space is significant. This ensures that Access databases are as small as possible. Users can set the disk space reduction threshold.
Northwind Sample Database: For users who need advice about a particular feature or just want to see an example, the Northwind database — a fully functioning database — ships with Access and provides several examples of the latest features for users to see or copy.
Data Access Pages: This feature allows users to extend database applications to the corporate Intranet by creating data-bound HTML pages quickly and easily. This will help users share information faster and more efficiently than ever.
Grouped Data Access Pages: This provides the ability to view and manage related information, such as sales by region and sales from a particular sales representative. The data appears in a collapsible hierarchical format when creating Data Access Pages.
Data Access Pages Toolbox: A toolbox is provided in the Data Access Page design environment for creating controls. Users can easily drag and drop each tool as needed.
Field List: The Field List enables users to easily add information to a Data Access Page view simply by dragging and dropping the field names from an easily accessible list. Each field is bound to the data by maintaining a direct live link to the data from the Data Access Page.
Hyperlink Handling: Access 2000 offers an improved hyperlink interface to make it easier to create, edit, follow and remove hyperlinks in databases.
Integration of Shared Components: Access takes advantage of the new Office Web Components and COM controls that reside within the browser to provide users with several ways to view and analyze data.
Microsoft SQL Server Interoperability: Microsoft Access 2000 supports OLE DB, allowing users to combine the ease of use of the Access interface with the scalability of back-end enterprise databases, such as Microsoft SQL Server.
Microsoft Access Project: The Access interface can create a new file type (.adp) that connects directly to the integrated store available in Office, SQL Server 6.5, or SQL Server 7.0. This makes it simple for Access users to create true client/server applications using the familiar interface in Access.
Microsoft Access Project Wizards: Many popular Access wizards have been updated to support the new Access Project tasks, such as creating a new database, report, or form.
Microsoft Access Project Design Tools: When working in a Microsoft Access Project file (.adp), new design tools allow users to easily create and manage server side objects including tables, views, stored procedures and database diagrams.
Microsoft SQL Server Administration Tools: Microsoft Access 2000 allows users to perform and manage common Microsoft SQL Server 7.0 administration tasks, such as replication, backup and restore, and security.
Advantages
Relationships can be created between tables, linking fields and eliminating redundant data and inconsistency.
The package is fully customised.
Disadvantages
Filemaker Pro
File maker is a system designed by Claris. It allows a user to create a database that can be shared and used by other workstations or in usage with an application. It allows a variety of options to be selected such as limiting user accesses and has a variety of ‘time saving devices’ that allow users to quickly, create, modify and correct any databases used.
The system also allows the database to be designed with macro scripts and an import and export system, where files from other programs can be integrated into the system with ease and convenience.
Lastly the system is compatible with the earlier versions of the software such as FileMaker 5.Xm, this shows that the system will be easy to upgrade and convert previous files on a computer system.
Price: £250.00
Features
GATHER DATA
Gathering data is easier than ever with FileMaker Pro 6! Convenient import options, plus added support for data exchange standards, open a new world of connectivity to desktop applications and corporate data sources.
Enhance Your Solutions with Multimedia
Bring your solutions to life with digital images and other rich forms of data (such as JPEG, MOV and MP3). Capture images and their related data directly from your digital camera, or import multiple image files directly from your desktop.
Universal Data Exchange
With support for such standards as ODBC, JDBC, and XML, FileMaker Pro 6 allows you to gather many types of data from a virtually limitless number of applications and data sources.
Import a Folder of Files
With just a few clicks, import a folder of files into your FileMaker Pro databases—this feature simplifies the storage of a variety of files, including text files, images, sound files, QuickTime movies and more.
Convert Excel Spreadsheets
Drag and drop Excel spreadsheets into FileMaker Pro 6 to instantly create functional, modifiable databases.
MANAGE DATA
With powerful new data handling tools, FileMaker Pro 6 is ideal for tracking and managing people, projects, images and information. From a simple contacts database, to a powerful digital photography/video storage and cataloguing solution, FileMaker Pro 6 is the flexible information management tool for novices and professionals.
Get Started Quickly with New Templates
Be instantly productive with more than for business, education and home. Or use the Layout/Report Assistant to quickly and easily create your own reports and summaries.
Data Handling Features
Use the new Global Find and Replace feature to easily change specific text throughout your database. The Constrain and Extend Found Set feature allows for more sophisticated Finds without a series of complex steps. Take advantage of the new Field Context Menu Sort feature for a more intuitive way of sorting a record set in Form view.
Visual Design Tools
Use the comprehensive graphic tools built into FileMaker Pro 6 to make your information look the way you want. The new Format Painter lets you copy and apply the visual design attributes of a text block or object for swift creation of stunning solutions. Layout Themes help you create a consistent appearance for your corporate reports.
Author Sophisticated Solutions The relational capabilities in FileMaker Pro 6 allow you to enter data just once, then use that data throughout your databases by creating one-to-one, one-to-many and many-to-many relationships between files. Use the ScriptMake feature to automate routine tasks and menu commands —anything from dialling the phone, to opening URLs, to sending e-mail.
Customisable Dialogs
Developers can create more intuitive solutions by providing users with dialogs containing custom and dynamic titles and messages -- useful for creating customised error messages. Custom dialogs can also accept input from users.
Accessibility with FileMaker
Intuitive interface design, support of keyboard shortcuts, and compatibility with assistive technology applications help make FileMaker accessible to those with disabilities.
SHARE INFORMATION
FileMaker Pro 6 gives workgroups even greater connectivity with each other, and with the corporate data they need. Share information across diverse platforms, over a network, or over the Web -- FileMaker Pro 6 includes robust security features that allow you to share with confidence. With support for XML and other standards, FileMaker Pro 6 can exchange information with a virtually limitless number of desktop applications and corporate data sources.
XML Export
With new XML support, developers and power users can export XML data from FileMaker Pro 6 and transform that data into a text-based format by applying the appropriate XSLT style sheet. That data can then be shared with a virtually limitless number of other applications (including Excel, Rich Text Format, and Scalable Vector Graphics).
Share Over a Network or publish on the Web
Convert a single-user database into a multi-user-networked solution in one simple step. Or instantly publish your databases to your Intranet, giving up to 10 authorised users direct access to your databases. Authorised users can search, edit, delete and update records using most popular Web browsers.
Share Information Securely
Security features in FileMaker Pro 6, give administrators control over corporate data. With the Record-Level Security feature, administrators determine browse, edit and delete privileges at the record level for each user. The Disable New Database menu item prevents users from creating new databases on their own. Limit access to Web-enabled databases by filtering IP addresses.
Work across Diverse Platforms
FileMaker Pro 6 is "Designed for Windows XP" and Windows 2000 logo certified. It also supports Mac OS 8.6 through 9.2.2, and Mac OS X. Broad platform support makes FileMaker Pro 6 ideal for workgroups in multi-platform environments.
Advantages
- The system is simple to use.
- It has a large amount of built in task wizards.
- It is upgradeable and back copy compatible.
- Files from other programs, such as pictures for catalogues, can be integrated into the database
Disadvantages
Filemaker demands a lot of training from both designer and user, with so many functions built in a lot of attention to the detail of the system is required. This therefore puts doubt onto the system as Mr. O’Riordan already has very limited technical skill and is unwilling to spend a lot of time learning to use a system.
Filemaker is an expensive system, regarding training and purchase of the product, though it is a unique system that does fit a lot of the specifications Mr. O’Riordan requires, it is unfortunately out of Mr. O’Riordan’s price range.
Oracle
The Oracle database is a state of the art relational database. It has received many awards from prestigious magazines such as PC Magazine. It has been voted the Number one on Linux. It incorporates the most ‘scalable and fully featured’ database tools available. It is compatible with large user networks and has multiple security systems as well as the ability to still have access to the data if the network was to fail.
Price: £10,291.00
Features
Transaction Processing
Row Level Locking
In general, multi-user database require that data is "locked" to prevent destructive interaction between different users or programs accessing or updating the same data at the same time. Other databases lock the entire table when users access the data, thereby making all other transactions wait. With Oracle9i Database, only the individual row that contains the data in question is locked. The result is that many users can access data from the same table and can be assured of fast, accurate results.
Materialised Views
Materialised views are used to pre-compute and store aggregated data such as a sum of monthly sales figures. The result of storing pre-computed results is that the database server can deliver dramatically improved performance for common queries because it does not have to re-compute these results every time.
Data Partitioning
Partitioning allows tables and indexes to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Partitioning can provide tremendous benefits to a wide variety of applications by improving manageability, performance, and availability. It is not unusual for partitioning to improve the performance of certain queries or maintenance operations by an order of magnitude.
Query Optimisation
Query optimisation is of great importance for the performance of a relational database, especially for the execution of complex SQL statements. A query optimiser determines the best strategy for performing each query. A good query optimiser is not developed in a laboratory based on purely theoretical conjectures and assumptions; instead, it is developed and honed by adapting to actual customer requirements. Oracle’s optimiser is perhaps the most proven optimiser in the industry.
Reliability
Database Clusters
Oracle9i Real Application Clusters (RAC) is the only clustered database available that can transparently scale and protect packaged applications with literally no changes necessary for the application or the organisation of its associated data. Additionally, RAC can scale your application at any price point, whether you are running small Linux or Windows servers, or large scale UNIX servers of mainframes. RAC also provides superior data protection with hot failure in less than 30 seconds..
Complete Data Protection
Oracle9i Database features Oracle Data Guard, a complete data protection scheme that can quickly recover from all manners of failures, from site failures and data centre disasters, to human error and data corruptions. The Web interface makes the creation of standby databases easy and error-free, saving untold time and money over traditional, more error prone approaches.
Online Data Evolution
System downtime due to human error or server failures can be frustrating, but downtime due to maintenance can be just as costly. With Oracle9i Database, virtually all standard administrative tasks can be done without interrupting system operation. Creating, deleting or moving tables, changing system parameters, reorganising the database can all be done without making data unavailable to applications. This is a huge benefit as many mission critical applications can costs thousands of dollars in lost revenues per minute of downtime.
Self Service Error Correction
The flashback query feature of Oracle9i Database allows application developers to build in error correction capabilities into their applications so that end users mistakes can be corrected without having to do a recovery operation on the database. With flashback query, an application can view data "as of yesterday" or as of any period of time you specify. The Oracle9i Database can then reconstruct the data as it was at the requested time.
Data Warehousing
Integrated OLAP
Oracle9i OLAP provides valuable insight into business operations and markets using features previously found only in specialised OLAP databases. Because Oracle9i OLAP is fully integrated into the relational database, all data and meta-data is stored and managed from within Oracle9i providing superior scalability, a robust management environment, and industrial-strength availability and security.
Data Mining
Oracle9i Data Mining allows companies to build advanced business intelligence applications that mine corporate databases to discover new insights, and integrate those insights into business applications. Oracle9i Data Mining embeds data-mining functionality into the Oracle9i database, for making classifications, predictions, and associations.
Data Warehousing Extraction-Transformation-Loading (ETL)
For Data warehouses, data is typically gathered from a variety of transactional systems and data streams. The data from these various information sources must first be extracted, then transformed into a single, consistent view and then finally loaded into the data warehouse. By having these key operations built-in to Oracle9i Database, greater flexibility and huge time savings can be achieved by running various ETL processes in parallel.
Security
Single Sign-On
Oracle Advanced Security
Oracle Advanced Security offers enhanced PKI-based single sign-on to Oracle9i through the use of interoperable X.509 (version 3) certificates for authentication over Secure Sockets Layer (SSL), the standard for Internet authentication. In addition to strong user authentication, SSL also provides network data confidentiality and data integrity for multiple types of connections: LDAP (Lightweight Directory Access Protocol), IIOP (Internet Intra-ORB Protocol), and Net (formerly known as Net8).
Selective Data Encryption
The ability to natively encrypt data in the Oracle9i Database enables applications to guard their sensitive data, even if unwanted intruders gain access to the server. Oracle9i offers server-based encryption (and decryption) using industry-standard Data Encryption Standard (DES) in exportable key lengths and Triple-DES (3DES).
Secure Data Sharing
Oracle Label Security is a powerful row level security solution based on labelling concepts used by government and defence organisations to protect sensitive information and provide data separations. Traditional information systems have not allowed data to be separated into different sensitivities within a single database. Oracle9i Label Security mediates access to data by comparing a sensitivity label assigned to a piece of data with label authorisations assigned to an application user.
Management Tools
Intelligent self-managing and tuning
One of the key areas of focus in Oracle9i Database has been to enhance the database manageability by automating routine DBA tasks, reducing complexity of administration and making it more self-tuning and self-managing. A number of new features have been added to streamline space, memory, and resource management as well as other day-to-day database administrative tasks.
Manage the entire stack
Oracle Enterprise Manager provides a comprehensive management framework designed to support multiple, heterogeneous environments. It offers real-time monitoring for events; unparalleled scalability; distributed database administration; collection and analysis of performance and availability data; automated tuning of the Oracle environment, and well-integrated reporting capabilities.
Pinpoint diagnostics
The Oracle Diagnostics Pack provides the tools required for monitoring the Oracle environment, including: databases, host systems, web servers and Oracle applications. It covers the key facets of Oracle diagnostics: lights-out monitoring and notification, real-time diagnostics, historical data analysis and web-based reporting.
Database resource management
The Oracle9i Database resource manager to enable the prioritisation of database operations by applying system resources according to business priorities defined by the database administrator. It enables administrators to allocate CPU resources among database users and applications as well as limit the degree of parallelism of any operation. It can also automatically detect long running operations and limit their resource consumption thereby preventing system wide performance degradation.
Data Integration and Messaging
Message Queuing
Oracle Advanced Queuing is the unique integrated message queuing feature of Oracle9i Database. Message queuing functionality allows applications on to communicate asynchronously via messages in AQ queues. Integration with the database brings unprecedented levels of functionality, operational simplicity, reliability, and security to message queuing. It offers unique message management functionality - such as auditing and tracking - to the message queuing applications.
Database Replication
Replication is the process of copying and maintaining database objects, such as tables, in multiple databases that make up a distributed database system. The same data is available at multiple locations. Oracle Advanced Replication is designed to support a wide variety of applications. It can support mass deployment configurations as well as server-to-server applications integrated into a single distributed computing platform.
Legacy database data gateways
Oracle provides two connectivity solutions to address the needs of disparate data access, generic connectivity and transparent gateways. These gateways provide seamless access to non-Oracle data sources such DB2, Sybase, Ingress and many more. The generic solution accesses these data sources using standard ODBC mechanisms while the transparent gateways use native operations for selected legacy databases.
Content Management
Intelligent File System
The careless storage of critical documents on network file servers has resulted in a costly, relatively low-value method of manage critical information assets. The Oracle9i File System provides a scalable central repository for critical electronic documents and an easy web-based interface to manage them that requires almost zero user training. Companies can now save millions of dollars by consolidating their scattered file servers into a central, intelligent repository, allowing unprecedented searching, indexing and data mining capabilities.
Manage all content types
Oracle Inter-Media provides an array of services to develop and deploy traditional, Web, and wireless applications that include rich media. Multimedia content can be managed directly in Oracle9i under complete database control. Alternatively, Oracle9i can store and index meta-information together with external references that enable efficient access to media content stored outside the database.
Powerful text processing and search
Oracle Text uses standard SQL to index, search, and analyse text and documents stored in the Oracle database, files and on the Web. Oracle Text can analyse document themes and gist’s; search text using variety of strategies including full-text: Boolean, exact phrase, proximity, section searching, misspellings, stemming, wildcard, thesaurus, word equivalence, and scoring and a host of other advanced capabilities.
Out of the box search engine
Oracle Ultra Search provides uniform search-and-locate capabilities over multiple repositories - multiple Oracle databases, IMAP mail servers, HTML documents served up by a Web server, or files on disk. Ultra Search is an "Out-of-the-Box" application that enables a "Portal" search across the content assets of an organisation, bringing to bear Oracle9i core capabilities of scalability and reliability. Ultra Search uses a "Crawler" to index documents; the documents stay in their own repositories, and the crawled information is used to build an index that stays within your firewall in a designated Oracle9i database.
Location based services
Oracle9i provides location-based services that support a wide range of applications -- from automated mapping/facilities management and geographic information systems (GIS), to wireless location services and location-enabled e-business. Oracle Spatial and Oracle Locator make location a native type within the Oracle9i Database. Oracle Locator provides spatial object type storage, indexing, and operations, to support a variety of location-based services (LBS) and 3rd party GIS solutions. Oracle Spatial provides advanced spatial features to support high-end GIS and LBS solutions.
Advantages
Disadvantages
A Hideous cost for a small business
Requires unique user training, it may involve heavy costs to learn the system alone
Has heavy system requirements
It is not simple to use
IBM, DB2 Universal Database
IBM's DB2 database software is the worldwide leader in ‘evolution of the relational database’. DB2 is the industry's first multimedia, Web-ready relational database management system delivering leading capabilities in reliability, performance, and scalability. DB2 is the database of choice for customers and partners developing and deploying critical solutions. There are more than 60 million DB2 users from 400,000 companies worldwide relying on this IBM data management technology. There is a ‘Family’ of DB2 Systems, the specific one displayed here is the IBM DB2 V.8.1
Price: $25,100.00, approximately £15,000.00
Advantages
The ‘Innovative manageability’ system allows the database to run by itself, it has many ‘predetermined’ configurations that it automatically accesses to manage the information. This means that once bought the end user would not have to devote much time to looking after the system.
New levels of integrated information functions allow the database to broadcast it’s information over the internet and XML. It allows programmers to easily incorporate broadcast data into the system.
Robust e-business foundation the system is a reliable and high performance system. Enhancements to the original system provide versatility on ‘unparalleled levels’ by removing the 85% of the disruptions normally associated with database maintenance. Mr. O’Riordan would therefore be able to keep the database active as long as he wanted without risk to the data.
Disadvantages
As with most international business databases, specialist training is required. Mr. O’Riordan would end up paying out a lot of money on both the system itself as well as training required to operate the system.
The system is very high priced and designed for large businesses rather than one off individual businesses such as Mr. O’Riordan’s.
The system requires a very specialized setup, Mr. O’Riordan’s home computer would not suffice to operate the program.
SQL Anywhere Studio
Anywhere Solutions, Inc. introduces SQL Anywhere Studio 8 – claimed to be the next generation of its market-leading enterprise data management and synchronization solution. Featuring major performance, security and developer enhancements, this new version is optimised for larger scale mobile, embedded and workgroup environments.
Price: $399.00, approximately £240.00
Advantages:
E-Business solutions anywhere: SQL is highly compatible with IExplorer and other web browsers and it’s data can easily convert from an onscreen database to a worldwide website.
“Always Available” Solutions Ensure Access to Enterprise Information: Regardless of connection or application type, SQL Anywhere Studio ensures “always available” access to data allowing users such as Mr. O’Riordan to use and gain access to the information whenever she wishes. The system also features Data synchronisation technologies that enable the exchange of new information in a timely manner, and minimise the amount of data that needs to be sent over a wireless or dial-up connection which would allow Mr. O’Riordan to quickly transfer their data via the internet with the minimum amount of time and effort.
The Power of the Enterprise in a Small Footprint DBMS: SQL Anywhere Studio features “Adaptive Server Anywhere”. This small ‘footprint’, powerful database server is optimised for use on workgroup servers, laptops and handheld devices, and supports both single-user and multi-user implementations. The system is also designed for maximum resource and energy efficiency allowing Mr. O’Riordan to use a mobile device such as a palm top and it’s other functions while still being able to use her database system to process orders ‘on the fly’.
Extending the Enterprise Anywhere with Advanced Synchronisation: SQL Anywhere Studio includes a comprehensive set of technologies for scalable, bi-directional synchronisation of e-Business information between enterprise and remote systems. SQL Anywhere’s synchronisation technologies are optimised for both occasionally connected and near real-time environments. These technologies support the secure communication of information for remote and mobile users over a wide variety of synchronous, asynchronous, wireless, dial-up and Internet protocols.
Easy to Use, Easy to Administer: Adaptive Server Anywhere delivers new levels of usability to end users and database administrators (DBAs). Adaptive Server Anywhere is self-administering and self-tuning, requiring minimal DBA involvement. SQL Anywhere Studio also includes a graphical administration tool that offers easy-to-use administration of the database and the synchronisation environment, on both PC and UNIX platforms. The added benefit of event handling and scheduling enables a DBA to set up an Adaptive Server Anywhere server to execute a set of actions at predefined times or when certain events occur, such as the disk reaching 90% full.
Performance and Scalability: Adaptive Server anywhere is designed to offer strong out-of-the-box performance. A high-performance, self-tuning query optimiser determines the most effective way to access information, improving performance and eliminating the need for expert tuning. Adaptive Server Anywhere also provides symmetric multiprocessor (SMP) support to take advantage of multi-CPU machines, ensuring top performance for larger databases and greater numbers of connected users.
True End-to-End Security: SQL Anywhere Studio includes 128-bit strong encryption options, resulting in true end-to-end security that meets the needs of customers in privacy-conscious industries such as healthcare and financial services. Communications encryption protects the confidentiality and integrity of packets as they pass between the client device and the server (or communication between the local device and enterprise system). Strong local data encryption and authentication requirements protect information even if the device is lost.
Multi-Platform Support
SQL Anywhere Studio supports a wide range of operating systems, including Windows, Novell and UNIX; popular handheld platforms, such as Microsoft Windows CE and the Palm Computing Platform; and real-time platforms, providing the highest flexibility in deployment. Adaptive Server Anywhere database files are binary compatible, enabling developers to simply copy the file to multiple operating systems.
Reliable and Easy to Use SQL Anywhere Studio’s synchronisation is designed to be easy to use for both database administrators and end users. A large number of remote users can be set up and managed easily. Administration duties are significantly simplified with all administration functions being carried out at the consolidated database. Reliability is ensured through guaranteed message delivery. In the event that a network connection is lost or a message becomes corrupted during transmission, messages are automatically re-sent.
Support for Subsetting of Data SQL Anywhere Studio’s synchronisation includes the ability to subset data, partitioning both horizontally and vertically, to ensure that remote systems are only getting the customised data relevant to their job function. This allows companies to put data where it is most needed, while overloading a remote user’s database with rarely used information. This also reduces the communication time, thus decreasing communication costs.
Advanced Conflict Detection and Resolution If the same data set is updated at more than one site, a conflict can arise. SQL Anywhere Studio includes proven, easy to set up conflict detection and programmable resolution to ensure that data is kept consistent throughout the company. Because the master copy of data is stored in the consolidated database, all conflict resolution is carried out at the consolidated site, thus ensuring consistent enforcement of business rules for all updates.
System Requirements and Supported Platforms
- Windows 95/98/Me, NT, 2000, XP
- Windows CE (Pocket PC/Handheld PC)
- Novell NetWare
- Solaris/SPARC
- Linux
- Deployment options for HP-UX, IBM AIX, Compaq Tru-64
- Requires a minimum of 4 MB RAM and 4 KB per client connection (8 KB for UNIX)
Possible Solution
For creation of this database system I have decided to use Microsoft Access. My decision for this is due to a number of reasons, these are as follows:
- All of the computers that I will be using already have Microsoft Office installed so both the cost of buying this program and the training will not be a factor.
- After looking at filemaker and SQL I have decided that the advantages that these systems offer do not compensate for the disadvantages.
- The more advanced programs such as Oracle and DB2 although offer some advanced features that would benefit Mr. O’Riordan are far too expensive for a small business.
- Mr. O’Riordan already has some minimal experience with Access and so training for Microsoft Access would be a minimum.
- Apart from a BeSpoke Microsoft Access would be the best for meeting Mr. O’Riordan’s end user requirements.
Test plan
Implementation
Testing
Test Results
User Testing
User documentation
Evaluation