Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Database Solutions Studio | Elance
 
176985602337900
Last Sign-in: Feb 5, 2014

Database Solutions Studio

MS Access Design And Development, SQL Coding
   United Kingdom
  |   Stoke On Trent, Staffordshire
  |  7:04 pm Local Time

Overview

Minimum Hourly Rate $22

Data engineer/data analyst/SQL Server 2005/Integration Services 2005/MS Access And Excel report writer.
7+ years experience in the use of above technologies for the development of bespoke reporting for the public and private sectors.
MS Access Database Report Designing, Creation And Generation, powered by SQL Server or MS Access tables as database backend.
MS Access Database Designing And Implementation, powered by SQL server database backend. MS Access VBA coding.
MS Excel Competent/Data Analysis/Pivot Tables/Charts.
Data analysis,...

Read More »

Portfolio

Screen Shots Of Demo Project
Student enrollment database for training firm.

Skills (4)

Tested
Microsoft Access Programming
Microsoft SQL Server Programming
Microsoft Excel
Microsoft Excel 2003 Test
My Score
avg
Microsoft Access Administration
Microsoft Access 2003 Test
My Score
avg
Microsoft Access 2007 Test
My Score
avg

Service Description

Will design and create MS Access databases according to your specified criteria.

The database will be set up for single or multi user environments as specified by you the user. This setup can have in-built user logins if you so require.

Database will be split into a front end and a back end system. This front end will contain the objects that receive and manipulate data while the back end stores the information. This separation methodology protects the business critical data and makes disaster recovery easier.

The front end will make use of forms to capture data from the user and to navigate the project space. The data captured will reside in back end tables and will be displayed using forms or reporting tools such as Access, pdf or word reports as the user determines. The reporting can also be expanded to utilise MS Excel powered by data exports from MS Access.

Extensive use of VBA / DAO coding will be employed in the front end system to manage the tables residing in the back end system and to ensure ease of use and robustness.

If your job is data analysis or engineering MS Access and MS Excel will be used to produce your final dataset.
MS Access will be employed for automations and extract, transform and load operations while MS Excel will be used for summaries, charts and pivots if you so require.

I aim to complete most jobs within a week, more complex scenarios will take longer.



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

Keywords

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
Private
Private
Total
Per Client
Identity
Username
DatabaseSolnStudio
Type
Individual
Member Since
October 2013
Elance URL
Verifications
0
Groups
Database Solutions Studio | Elance

Database Solutions Studio