Find Jobs
Hire Freelancers

Access Database Tables and Basic Queries

$10-30 USD

Cancelled
Posted over 8 years ago

$10-30 USD

Paid on delivery
DATABASE REQUIREMENTS: PHASE 1 This project is phase 1 of a larger project; I'm still working on the Database requirements. For this phase, there are no reports or multiple table queries. They are coming. PROBLEM Need Project Start Date, Project End Date, and Fiscal Year for all project numbers; Level 1 is critical; Level 1 must have the earliest and latest dates of all Project numbers below level 1; "Create a column indicating ""Closed"" for any records that don't have any Total Funding at AND below level 1; Projects should indicate ""Closed"" for any projects dated prior to FY2002; the rest of the projects should indicate the project as ""Active"" NOTE: I should be able to add projects and the system will indicate if the project is ""Active"" or ""Closed""" SIMPLE QUERIES Create query tables showing each of the projects broken out by Fiscal Year. "Tables should contain all columns through ""Subctr Id"" If you need any of the other columns, you can keep them, but hide them" See attachment for a screen shot of the Access Database. SIMPLE QUERIES Create query tables showing each of the projects broken out by Fiscal Year. "Tables should contain all columns through ""Subctr Id"" If you need any of the other columns, you can keep them, but hide them"
Project ID: 8458461

About the project

18 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $39 USD for this job
User Avatar
Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 3+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I used to develop systems using latest adaptive technology such as 1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions) 2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations) I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss project in details. Thank you.
$24 USD in 1 day
5.0 (106 reviews)
8.0
8.0
User Avatar
We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame so would you be kind enough to message me so we can have a fast and understanding agreement.
$100 USD in 1 day
5.0 (26 reviews)
7.1
7.1
User Avatar
Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and provide you our comments & suggestions. ARITY INFOWAY is leading growing company in outsourcing business. We are having 15+ members with expertise in various technology. Web Designing :- HTML5/PSD to HTML/CSS3/JS/Angular JS/Node JS/jQuery/Responsive Web Designing/UI Development/Frontend Development/Logo Designing/Theme Integration/AJAX/Web Services PHP:- MySQL/Core PHP/Magento/Joomla/Wordpress/CMS/Blogs/Codeigniter /Smarty/Moodle/Symfony/Yii/Drupal/eCommerce/OSCommerce/Shopping Cart .NET:- ASP.NET/VB.NET/C#/MVC/ Umbraco/Entity Framework/BioSecure Software/SQL Server/HSQL DB/Kendo UI/Telerik Control/Azure Storage/CDN Storage/WCF/WPF/Web API/HRM Integration/Desktop Applications Mobile Applications:- Android/iOS/Windows JAVA:- J2EE/JSP Servlet Payment gateway Development & integration:- PayPal/Avangate/Skrill/CCAvenue/WorldPay/Stripe Web Hosting:- (Linux/Windows) Hosting/Advance DNS Solution/Server Installation & setup/Mail Server/Router Configuration/Switching & VLAN/VPN/Cloud Server/Critical Data Recovery/Remote Server Support/Server Security/Web Security/Computer Help We never Place any GENERIC BID so we frequently contact you to meet you expectations. We love to spread SMILES :-)
$28 USD in 1 day
4.9 (48 reviews)
6.5
6.5
User Avatar
Sir Having 8 + years experience in MS Access, SQL Server , ASP.Net and willing to start the work immediately .
$35 USD in 1 day
4.7 (125 reviews)
6.3
6.3
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
$55 USD in 1 day
5.0 (88 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
4.7 (29 reviews)
5.9
5.9
User Avatar
Hi Im an expert in .Net and sql server technologies with over than 20 years of experience in banking sw development. For a robust system i recomend you to use SQL Server instead of MS Access. Regards Carlos
$25 USD in 3 days
4.8 (64 reviews)
5.9
5.9
User Avatar
Hello, I have good experience in MS SQl server. Could you please let me know the exact schema of your table. You can send me the script to create the table on SQL server. Regards, Vikas
$30 USD in 3 days
5.0 (25 reviews)
4.9
4.9
User Avatar
Dear client, I have a lot of experience with VBA and Access. Send me a message for more information. Kind regards, Rens Slenders
$30 USD in 1 day
4.8 (17 reviews)
4.4
4.4
User Avatar
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble Ashish Seth
$35 USD in 1 day
4.7 (11 reviews)
3.6
3.6
User Avatar
I am database expert having experience of 3 years.I will complete your work as per your requirement and deliver it on time.
$37 USD in 1 day
4.9 (14 reviews)
3.5
3.5
User Avatar
I have very good command over ms access and vba macros. this will be easy job for me. Do consider my bid. thanks
$30 USD in 3 days
4.7 (5 reviews)
2.1
2.1
User Avatar
hi Sir, I am project developers for more than 8, during that time I have done several project: big or small, using vb6, access databases and the .net developers tools. I am agree with you using Sql server, the free version (sql express) support 8 GB the sql express 2008. Sir, I can complete this project without any problems. Wishing working on this. My Best Regals.
$30 USD in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
Hi, I have 10+ years of experience in access vb vb.net sql server development, I can do it for you. If you want you can send me access databse with some records in it (as your screen shot shows).
$25 USD in 1 day
0.0 (0 reviews)
2.4
2.4

About the client

Flag of UNITED STATES
Gambrills, United States
5.0
7
Payment method verified
Member since Aug 6, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.