Create Microsoft Access database using multiple Excel files (monthly reports)

Budget N/A
Bids 65
Average Bid $408

I need to create a database from a monthly excel file.

Input Information - I have a monthly report that has fixed columns of data. This rows in the report are accounts. The columns represent information about each account. Some columns do not contain information I care about, and could be ignored. There are approximately 5 years of data I would need to import when the DB is set up. The files are text files, but come into MSFT Excel easily (comma delimited).

Output or Visualization - I need to be able to look at the data in two ways. First is to look at each account, and track changes in the values. The values will have single event changes (i.e. they do not change month to month). Changes themselves are the events I want to be able to find. Also, I need to be able to look at a column (i.e. a specific data point) to search for changes over time to those fields. I do not own MSFT Access, but could purchase for this project.

This is a personal project, so I have a budget. The "added value" of a freelancer is knowing what I am trying to do with the data, and creating easy ways to search and visualize the data (changes in data really) that help me with my larger project.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • NineGold Profile Picture

    NineGold

    Rockville,  United States

    -Editing (proofreading, revision, formatting) -Excel (tables, charts, formulas, data entry/analysis) -Content (research, statistics, summaries) -Persuasion (proposals, grants, business plans) -Basic Design (logos, graphics, brochures, layouts) -Translation (Spanish/English)

    Graphic Design, Translation, Logo Design, and Project Management

  • mikroplus Profile Picture

    mikroplus

    Ohrid,  Macedonia

    I am University graduated software engineer. Ready for new challenges and prepared to successfully accomplish any task

    Data Entry, Excel, Facebook Marketing, and Microsoft Access

  • MarlinSoftware Profile Picture

    MarlinSoftware

    Oswestry,  United Kingdom

    23 years of software development and database design. - Programming Languages: Visual C++, Objective C, Visual Basic, PHP, JavaScript, ASP, COBOL, 6510 / 68000 / 80x86 Assembly Language - Database: Microsoft Access, Visual FoxPro, MySQL, SQL Server - Web Design: HTML, CSS, osCommerce, OpenCart, jQuery, Sencha Touch, PhoneGap, JSON, AJAX, Google Maps

    PHP, ASP, Javascript, and Visual Basic

  • raffterr Profile Picture

    raffterr

    Rome,  Italy

    Java e .NET developer (Visual Basic and C#). I developed web, desktop and mobile application. I published application for Windows Phone 7 and Windows 8.

    Java, JSP, .NET, and Windows Desktop

  • ashokbhanderi Profile Picture

    ashokbhanderi

    Jamnagar,  India

    Over the last 7+ years and 1222+ oDesk Hours with 5 stars, I had developed a wide range of windows & web applications using V.B., VB.NET, C#. NET, Crystal Reports, MS SQL Server (2000, 2005, 2008, 2012 BI), SSIS,Oracle 9i, and MS Access with VBA and Macros, MS Excel application using pivot functions, macros, VBA Programming. Also developed websites using HMTL, DHTML, PHP, JSP, ASP.NET, DB2, MySQL, Wordpress and Google Sites including sites for start up companies and small businesses. My core competency lies in complete end-end management of a new windows application and website development project, and I am seeking opportunities to build windows application as well as websites from the ground up for you or your business. I also have experience in the following areas: DBMS, RDBMS, DDBMS, IT Infrastructure Management, Data Structure, Data Warehousing and Data Mining, Software Engineering, Information Systems, Artificial Intelligence and Knowledge Based Systems. Ajax, Google products, and software design and testing. Now also Managing SAP Business One with following core modules: ->Operations and Distribution: ----Sales and delivery, Purchasing, Inventory management, Production planning ->Administration and Reporting: ----Human resources management, Automatic alerts, Dashboards and reports, Drag and relate, Customization and integration -> Customer Relationship Management (CRM): ----Sales opportunity management, Microsoft Outlook integration. Customer service and support, Business partner management Profile: https://www.sites.google.com/site/ashokkbhanderi/ --------------------------------------------- "If you think, you can, you will".

    PHP, .NET, Excel, and SQL

  • qualifiedcoders Profile Picture

    qualifiedcoders

    NEW DELHI,  India

    Qualifiedcoders is a company having 67 professionals working in various domains. Our company follows complete software development life-cycle and has been developing huge web based and desktop based applications. Established in Year :2007 Number of Employees : 67(as of january'2011). Business Domain: Banking,Manufacturing and Production,Wholesalers,Telecom,IT Offshore Outsourcing. Few of the websites developed in different domains are listed below: Note: To avoid search engines to crawl this page, we are placing '*' and '&' symbols in the urls so please remove tehm from the URL before you navigate to any of the link. Social Networking 1)www.i*a*m*an*art*ist.com 2)www.t*h*ed*i*s*k.com/index.aspx 3)www.t*e*c&h*n&o*u&s*a.com/phpdone/facebooklearn/ 4)www.c*a*b*o*d*e*n*t.org 5)www.s*p*a*r*t*a*c*u*s*p*2*p.com 6)www.a*c*tiv*chal*le*n*ge.com 7)www.t*e*c*h*n*o*u*s*a.com/ajhub/ 8)www.5*m*i*n*u*t*e*s*a*w*a*y.co.uk 9)www.t*e*c*h*n*o*u*s*a*.com/socialnetworking/ And many more: Auction websites Pay per click website such as Swoopo 1)www.r*unlive*au*cti*ons.com 2)www.j*or*gi*t.com 3)www.i*ama*na*rt*is*t.com/l*ive*auc*tions/index.aspx Lowest unique Bid Auction 1)www.t*e*c*h*n*o*u*s*a*.com/phpdone/lowestbidauction/ Matrimonial Websites : 1)Clone of www.s*h*a*adi.com www.t*e*c*h*n*o*u*s*a*.com/shaadi/ 2)Clone of www.j*ee*va*ns*a*a*t*hi.com www.t*e*c*h*n*o*u*s*a*.com/demo/jeevansathi/ Real Estate Websites 1)Clone of www.r*e*d*f*i*n.com with google maps www.t*e*c*h*n*o*u*s*a*.com/realestate/home.aspx 2)Clone of www.i*n*d*i*a*p*r*o*p*e*r*t*y.com www.t*e*c*h*n*o*u*s*a*.com/property/index.aspx 3)Clone of www.m*a*g*i*c*b*r*i*c*k*s.com www.t*e*c*h*n*o*u*s*a*.com/phpdone/magicbricks/

    PHP, Perl, ASP, and C Programming

  • MattyM01 Profile Picture

    MattyM01

    Adelaide,  Australia

    I have 5+ years experience with FileMaker Pro, and have created solutions for many different purposes including CRMs, Stock and Inventory, Statistics, Sales, Invoicing, Marketing, Scheduling, Reservations and Hire, and everything in between. I have deployed solutions for a large variety of industries: - Arts - Construction - Distribution - Employment Services - Equipment Sales and Distribution - Health and Fitness - Manufacturing - Marketing - Medical - Music - Payroll - Real Estate - Retail - Textiles - Travel and Tourism All of my solutions are optimized for iOS, Mac, Windows and Web. I am a hard worker, have a very high attention to detail and strong communication skills. This means we can easily work together in order to create the solution perfect for your needs.

    Graphic Design, Excel, Microsoft Access, and FileMaker

  • operations808 Profile Picture

    operations808

    Richmond,  United States

    My Name is Christopher Bonner. I am a applications developer. I have many years of Access Development experience as well as SQL server experience. BACKGROUND SUMMARY: 15 years of experience in small applications development with programming languages ranging from VB, VBA , Classic ASP, MS Access and VBScript 5 years of Object Oriented development experience using VB.Net 5 years of web development experience using ASP.Net and 2 years of development experience with C# 8 Years of development and support experience with SQL Server, Versions Include 2000/2005/2008R2 PROFESSIONAL TRAINING: Microsoft Training MS2279: SQL Server 2005 MS2780: Implementing and Maintaining a SQL 2005 Database MS2543: Visual Studio 2005: Core Web Applications MS2544: Advance Web Application Development Cooperate Development Programs, University of Richmond How To Be A Better Consultant Effective Communication Business Writing UML Requirements Gathering EDUCATION: CompSci Degree

    PHP, Visual Basic, Excel, and SQL

  • kulhanekd Profile Picture

    kulhanekd

    Mcloud,  United States

    I can do almost any Administrative tasks. My specialty is Access Databases.

    Visual Basic, Data Entry, Excel, and SQL

  • Reza2012 Profile Picture

    Reza2012

    Dhaka,  Bangladesh

    I have more than 10 years experience in Database administration, Data Migration, Data Warehousing and Data minining as well as Linux server administration. System Analysis, design, Development and Implementation. - Project Implementation. - Development Reconciliation system from old to new system. - CIB Online Project Development and Implementation. - Training to the end-user.

    PHP, ASP, C Programming, and Java