Step 1 - Analyse
Step 3 - Convert & Build
Step 1 - Analyse
1. We analyse and document your existing MS Access system(s) by looking at...
- Your existing Access databases
- Existing database user interaction
- Existing Data flow (manual and automated)
- Existing Access forms and validation
- Existing Access Data storage and existing ADO/DAO data connections
- Existing Access data retrieval requirements (queries and reports)
- Existing Dashboards, Management Information, pivots, charts, filters etc.
- Existing Access calculations and any custom functions
- Existing Macros, Add-Ins and VBA
- Existing Forms and underlying VBA
- Existing Security in place
- Also we can provide an MS Access query to SQL Server query conversion online
Free onsite consultancy available to discuss your requirements
Step 2 - Discuss
Step 3 - Convert & Build
Step 1 - Analyse
2. We discuss converting your MS Access system(s) to SQL server + ASP.NET to give you...
- Rich screens built to your exact requirements with enhanced validation and user guidance.
- All the benefits of SQL Server such as unlimited storage (access all historic data), quick and efficient data retrieval, Stored Procedures, User Defined Functions, Triggers etc.
- Dashboard based Management Information customised to your exact requirements.
- Pivots, grids, charts used to simplify/enhance your data gathering and data presentation
- Reports can be amended by end-users and saved
- Full security model with auditing
- Automated feeds to or from other systems
Free onsite consultancy available to discuss your requirements
Step 3 - Convert & Build
Step 3 - Convert & Build
Step 3 - Convert & Build
3. We Convert and Build
- We design your new data model and structures based on your requirements with an eye on any future needs
- We convert your existing Excel data to SQL Server, including any historic data as required
- We build your screens and reports
- Includes configuration screens so you can make most changes in-house
- Includes on screen help, themed and branded user guides and documentation.
- Can include branded end user training course (CBT or classroom)
- Full telephone support included
- Includes free on-site consultancy day(s)
- If required we can also provide full source code
Free onsite consultancy available to discuss your requirements