Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Business Data Answers | Elance
 
176985602337900
Last Sign-in: Aug 26, 2013

Business Data Answers

Acess, VBA, SQL, Datamarts, Advanced Forms
   United States
  |   Boise, ID
  |  3:44 pm Local Time

Overview

Minimum Hourly Rate $39

Specialties:
Access/VBA/SQL

Datamarts - tables created on the fly that brings together the results of multiple logically related queries.

Advanced Form Design - Forms that will build queries/reports on the fly based on input from the user. I provide drop down boxes for the users to choose their parameters based on data in the database.

Database Design/Redesign - In order to get valuable information out of your database you must first be able to put the information into the database.

Optimize existing VBA code for...

Read More »

Portfolio

This form builds a new custom query on the fly giving it a name based on the parameters...
The user chooses the Budget Type, Sale Year, Date Range, and options for Products,...

Skills (3)

Tested
Microsoft Access 2000 Test
My Score
avg
Microsoft Access 2007 Test
My Score
avg

Service Description

Step 1
Gather requirements for reports from all the stakeholders. Determine what business questions must be answered.

Step 2
Database already Exists?
Yes - Review the database design. Do any redesign neccessary to meet new requirements.
No - Design and build database including forms to enter data.

Step 3
Build forms that will build the needed basic queries and reports on the fly.

Step 4
Build datamarts to address advanced reporting needs

Step 5
Build forms to run the datamarts based on user input

Ongoing:
Optimization of existing code to make it run faster and more efficiently as needed.

Read More »
Overview  |  Job History  |  Portfolio  |  Team  |  About the Company

Keywords

Access
VBA
SQL
Datamarts
Optimization
Advanced Form Design
Company 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
ExecInfoMgmt
Type
Company
Member Since
March 2011
Elance URL
Verifications
0
Groups
Business Data Answers | Elance

Business Data Answers