Annulé

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 : database tables microsoft access

Concernant l'employeur :
( 7 commentaires ) Gambrills, United States

N° du projet : #8458461

20 freelance ont fait une offre moyenne de 38 $ pour ce travail

illuminesoft

ID : 8458461 Greetings, We are interested to work on this project, please find my comments inline with yours, 1.DATABASE REQUIREMENTS: PHASE 1 This project is phase 1 of a larger project; I'm still working on the Plus

35 $ USD en 2 jours
(218 Commentaires)
7.3
agilepksolutions

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 u Plus

24 $ USD en 1 jour
(22 Commentaires)
6.5
gkalish

Sir Having 8 + years experience in MS Access, SQL Server , ASP.Net and willing to start the work immediately .

35 $ USD en 1 jour
(136 Commentaires)
5.7
jawadaman

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 a Plus

55 $ USD en 1 jour
(42 Commentaires)
5.2
logicpowered

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 a Plus

100 $ USD en 1 jour
(7 Commentaires)
4.9
fuentro

A proposal has not yet been provided

35 $ USD en 1 jour
(16 Commentaires)
4.7
AlexandrK1

please send the full list of fields i can complete it within 1-2H .

30 $ USD en 1 jour
(17 Commentaires)
4.9
waleedmalik

I have designed and implemented various analytical reports in the database systems. sure to deliver the quality product as per your defined requirement.

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

Hello I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: http://89.38.210.110/myfiles/MS_Learning_Transcript.pdf With work I could start immediately. If needed I wi Plus

30 $ USD en 1 jour
(6 Commentaires)
3.9
slenders13

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 en 1 jour
(7 Commentaires)
3.3
rashmisingh2990

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 en 1 jour
(7 Commentaires)
3.3
carlosperezit

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 en 3 jours
(4 Commentaires)
3.0
arityinfoway

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 prov Plus

28 $ USD en 1 jour
(3 Commentaires)
3.1
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

25 $ USD en 0 jours
(8 Commentaires)
2.6
codevikas

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 en 3 jours
(6 Commentaires)
2.3
ithuang2014

A proposal has not yet been provided

50 $ USD en 1 jour
(3 Commentaires)
2.3
SWAPANCHOWHAN

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 en 3 jours
(4 Commentaires)
1.9
ekajgho

Over 15 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience incl Plus

111 $ USD en 2 jours
(10 Commentaires)
2.1
ashishseth1988

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 Plus

35 $ USD en 1 jour
(4 Commentaires)
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 3 jours
(1 Commentaire)
0.8