Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Andy Couch | Elance
 
176985602337900
Last Sign-in: May 13, 2014

Andy Couch

Access/SQL Server Guru - Access MVP
   United Kingdom
  |   Knutsford, Cheshire
  |  12:39 am Local Time

Overview

Minimum Hourly Rate $87
  |  
Watch Video

I specialize in developing/converting Access applications linked to data in SQL Server. Expert in VBA programming and writing TSQL, and have been awarded Microsoft Most Valuable Professional status for the last 7 year (my MVP profile can be viewed on the Microsoft MVP Site), written and acted as a technical author for Microsoft Press on several books.

Most of the systems I work on use an Access front-end application, I also construct .net web interfaces and use SSRS for some clients. I use a product called the Migration Upsizing SQL Tool,...

Read More »

Skills (9)

Tested
VB.NET
SQL Programming
Visual Basic
SQL Server
SSRS
Microsoft Access Programming
Microsoft Access Web App
Microsoft Access
Author

Service Description

Access data conversion to SQL Server
As the volume of data and number of users in an Access database increases, then to get better reliability and performance it is a great idea to move the data into SQL Server. The existing Access desktop database, can then be re-linked to the data in SQL Server. Having converted over 50 systems in the last 10 years, I can offer a great deal of expertise in over-coming difficulties when migrating data, planning security and using schemas to improve the manageability of the design.

The services that I offer are based around Microsoft Access and SQL Server. Some of these services are based around using a product called the Migration Upsizing SQL Tool (MUST), which has been successfully sold internationally to over 200 companies, www.upsizing.co.uk

Access SQL Server performance tuning
A key selling feature of MUST (www.upsizing.co.uk) is the products ability to convert queries in Access to SQL Server views and stored procedures. I can offer a service where I will perform the conversion, also handle VBA global variables and VBA functions, converting these to SQL Server functions. As part of migrating an Access database to SQL Server, converting the queries and batch processing can be very important in obtaining satisfactory performance.

Access report conversion to browser based SQL Server Reporting Services
Converting Access reports to rdl reports which utilize SQL Server Reporting Services (SSRS), allows the reports to be viewed in a...

Read More »
Overview  |  Job History  |  Resume/C.V.

Keywords

Access
SQL Server
VBA Programming
Access Web App
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
AndyCouch
Type
Individual
Member Since
May 2014
Elance URL
Verifications
0
Andy Couch | Elance

Andy Couch