 |
| Consultancy Team |
|
| IT Consultancy
Anthony Rose Consulting Services is a crucial part of the support we provide to businesses, ranging from online support and advice, through to placing consultants in-house.
All consultants are professionally trained, qualified and often they are leading experts in the fields the operate.
|
MS Access / SQL Server Database Projects
Microsoft Access was utilised with the following organisations to assist with the management and control of centralised data. In most cases the applications were built for departmental multi-users, with easy to follow GUI forms and comprehensive reports.
The technologies applied range from ODBC, ADO, OLEDB for database connectivity through to Remote Automation for the control of MS Office products such as Outlook, Word, Excel and PowerPoint. Each application was bespoke designed to achieve the goals and productivity as required by the departments involved.
|
This project started in 2003 with a reques to advise on how to speed up the existing database held in the NHS. The Database is used to to track the ongoing training and education of Consultants in Kent, Surrey and Sussex.
The database was initially held within Access, but soon it was upsized to SQL Server with a lot of the local queries being moved to Stored Procedures and Views held wihtin SQL Server, with ODBC links back to the Access Front End. The project involved re-writing a lot of the internal scripts and codes to obtain maximum effciency in the client- server architecture.
Support for this project is on-going.
|
Masonic Trust for Boys & Girls (MTGB)
MTGB raises charity money for the support of the children of past and present Masons who face financial difficulties regarding schooling and education. Our involvement with this organisation was in the assistance in optimising the performance of an Access database monitoring and tracking the donations from Lodges and individuals.
Royal Masonic Benevolent Institute (RMBI)
RBMI raises charity money for the support of the retired Masons and their wives in numerous benevolent homes through the UK. Our involvement with this organisation was in the assistance in migrating the RMBI database into a format suitable for the business needs of RMBI. Having succesfully moved the database across, we are still providing ongoing technical support and training to staff.
|
Team Spirits
Initially a small database for the managment and control of staff resourcing at Heathrow, Gatwick, London City airports among others. The system tracks the availability and roster of personnel, and automates MS Excel and MS Word for output reports. The database utilises file server technology, with Replication for design management. Support for this application is on-going.
EMG Accountancy
EMG use Access for the tracking and control of partner timesheets for billing purposes, integration with SAGE Line 50 and SAGE Sovereign, and the integration with HMG Tax offce database systems. The application was designed with file server architecture, with the Remote Automation of MS Office applications.
|
This application was developed to replace using multiple Excel spreadsheets created by many members of the HR department.
The objective was to develop a stand alone shared client database connected to a central data store, where members of the team could all work on the same data at the same time with no conflicts, errors or locking preventing the smooth control of the underlying data. It also had to produce accurate reports in Excel and also in Access.
The first prototype was very successfully presented to the department heads, and subsequently rolled out in May 2008, within the time and budget constraints in place at the time.
|
|
