Fermé

Access Database Tables and Basic Queries

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"

Compétences : .NET, ASP.NET, Excel, Microsoft Access, Serveur SQL Microsoft

Voir plus : at and t, membuat aplikasi visual basic database access, basic asset database access, tables chicken soup database access, database tables microsoft access, codeproject visual basic database access, backup database access restore visual basic, visual basic import data access database, linking visual basic 2005 forms access database, visual basic 2005 backup retore database access, visual basic 2008 query access database

Concernant l'employeur :
( 0 commentaires ) pune, India

N° du projet : #8462388

31 freelance ont fait une offre moyenne de 49 $ pour ce travail

mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several MS Access projects and able to complete successfully. As per your requirement, I can provide Plus

25 $ USD en 1 jour
(74 Commentaires)
5.8
Anuitex

Hello, Thank you for the opportunity to apply to your project. We are the team of IT professionals, who are passionate about what they do. Given our 7+ years experience and deep specialization in .NET developme Plus

25 $ USD en 1 jour
(5 Commentaires)
5.1
adicoman

Hi, I am very interested to work on your project: 'Access Database Tables and Basic Queries' As implementation offer, I propose implementing your queries as requested . I have 12 years experience in Excel, Plus

442 $ USD en 15 jours
(11 Commentaires)
4.8
waleedmalik

I am Certified SQL/PL SQL programmer and have extensive experience of designing views,scripts and analytical quires.

25 $ USD en 1 jour
(20 Commentaires)
5.0
Altantsetseg

Hello, From your project description, its the kind of job I had been experienced very well. I had been working as a senior programmer responsible for financial system developed in MS Access for over 6 years. I had Plus

20 $ USD en 1 jour
(8 Commentaires)
4.5
papon13

Greeting! My Name is Noor All Safaet and expert in Software and Web Development. I would love to have the opportunity to discuss about your project with you. I have professional 2.5+ years experience on ASP.NET, C# Plus

30 $ USD en 1 jour
(4 Commentaires)
3.4
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Plus

25 $ USD en 1 jour
(2 Commentaires)
3.5
aleator

I will help quickly and efficiently. The first result within 12 hours! Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, famili Plus

30 $ USD en 1 jour
(8 Commentaires)
2.6
JustDone

we are expert in SQL , we can implement your task lets chat for details what is your database type? thanks bye JustDone

25 $ USD en 5 jours
(4 Commentaires)
2.2
nithyarajeshg

I have done many work in SQL and in ACCESS database. I will give daily status update about the project and will get clarifications whenever it is required

20 $ USD en 2 jours
(10 Commentaires)
2.2
ithuang2014

A proposal has not yet been provided

49 $ USD en 1 jour
(3 Commentaires)
2.3
khp31

Sr. Software Developer with 5.6+ yr experience. Sr. Software Developer with 5.6+ yr experience. Sr. Software Developer with 5.6+ yr experience. ktanpatel31 is my skp id for further contact info.

188 $ USD en 5 jours
(1 Commentaire)
2.0
vinaysinghh

I am DBA having more then 5 yrs of experience in sql Oracle and mysql I can do this task easily... Where is attachment

25 $ USD en 1 jour
(1 Commentaire)
1.5
ufasoft

Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus

25 $ USD en 1 jour
(1 Commentaire)
0.8
Arctan

Hi. Take a look please at MS Access application in my portfolio. I would like to do this work for you. Wite me please which Office version do you yous and I'll send you a free draft of your project to prove my ability. Plus

20 $ USD en 1 jour
(1 Commentaire)
0.6
virvezfree

A proposal has not yet been provided

35 $ USD en 1 jour
(0 Commentaires)
0.0
amrutkarswapnil

A proposal has not yet been provided

28 $ USD en 2 jours
(0 Commentaires)
0.0
gehlotvishnu

A proposal has not yet been provided

20 $ USD en 2 jours
(0 Commentaires)
0.0
apacherai

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.4
Demal

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0