A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Does anyone have a Grants Tracking Database in Access to share?



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2007, 08:00 PM posted to microsoft.public.access.tablesdbdesign
ADRouse
external usenet poster
 
Posts: 3
Default Does anyone have a Grants Tracking Database in Access to share?


  #2  
Old September 24th, 2007, 11:04 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Does anyone have a Grants Tracking Database in Access to share?

Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...



  #3  
Old September 25th, 2007, 03:52 AM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default Does anyone have a Grants Tracking Database in Access to share?

okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


"Jeff Boyce" wrote in message
...
Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If

so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...





  #4  
Old September 25th, 2007, 05:49 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Does anyone have a Grants Tracking Database in Access to share?

On Tue, 25 Sep 2007 02:52:34 GMT, "tina" wrote:

okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


As a spouse of a former professor... you're Very Lucky That You Have No Need
to Know. g

Academic research is funded by grants (government or sometimes private). The
granting agencies' accountants make Ebenezer Scrooge look like Santa Claus,
and require that every speck of dust on the grant application be accounted
for.

John W. Vinson [MVP]
  #5  
Old September 25th, 2007, 03:53 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Does anyone have a Grants Tracking Database in Access to share?

tina

My day job is with a state agency, which both pays contractors and receives
(and re-distributes) grant monies. Grant AND Contract Tracking is a way to
manage the process from initial drafts through "end-date"/final payment.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"tina" wrote in message
...
okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


"Jeff Boyce" wrote in message
...
Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If

so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...







  #6  
Old September 26th, 2007, 08:03 AM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default Does anyone have a Grants Tracking Database in Access to share?

okay, guys, thanks for the info. but i have to say, what a letdown. here i
was, envisioning some kind of ultra-cool tracking system dreamed up by an
uber programmer named - of course - Grant!!


"Jeff Boyce" wrote in message
...
tina

My day job is with a state agency, which both pays contractors and

receives
(and re-distributes) grant monies. Grant AND Contract Tracking is a way

to
manage the process from initial drafts through "end-date"/final payment.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"tina" wrote in message
...
okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


"Jeff Boyce" wrote in message
...
Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If

so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...









  #7  
Old September 26th, 2007, 04:07 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Does anyone have a Grants Tracking Database in Access to share?

tina

That would be way too general/generic ... tracking what?

Nope, the real (behind the curtain) explanation is that this is a tracking
system, much like the radio collars for big game, used in keeping tabs on
Grant.

Right now, this is easily managed, as his location is fairly fixed and he
doesn't get out much.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"tina" wrote in message
...
okay, guys, thanks for the info. but i have to say, what a letdown. here i
was, envisioning some kind of ultra-cool tracking system dreamed up by an
uber programmer named - of course - Grant!!


"Jeff Boyce" wrote in message
...
tina

My day job is with a state agency, which both pays contractors and

receives
(and re-distributes) grant monies. Grant AND Contract Tracking is a way

to
manage the process from initial drafts through "end-date"/final payment.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"tina" wrote in message
...
okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


"Jeff Boyce" wrote in message
...
Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application?
If
so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...











  #8  
Old September 26th, 2007, 06:36 PM posted to microsoft.public.access.tablesdbdesign
ADRouse
external usenet poster
 
Posts: 3
Default Does anyone have a Grants Tracking Database in Access to share

As a non-profit we search foundations to receive grants to fund our programs.
THis can be a long process. First you reserach and see if you qualify, then
apply nad wait for a response. If your application is approved you are
awarded the grant. In some cases it may not be the same amount you asked for
and sometimes they require a progress report to show what you did with the
money you got. Of course all of this has deadlines and we apply between
150-200 grants per operationg year. And there are also time we get denied and
we want to make sure we track that so we don't ask that foundation again.

"tina" wrote:

okay, i'll expose my ignorance - because curiosity is killing me! g
Jeff, what the heck is Grants Tracking?


"Jeff Boyce" wrote in message
...
Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If

so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...






  #9  
Old September 26th, 2007, 06:40 PM posted to microsoft.public.access.tablesdbdesign
ADRouse
external usenet poster
 
Posts: 3
Default Does anyone have a Grants Tracking Database in Access to share

I have and I worked with the Customer services DB in Access and changed it a
bit but it's missing some elements like tracking funds requested and funds
awarded. I know I can make it work, I just wanted to avoid the many hours
updating and changing reports, forms and tables.

Thanks though

"Jeff Boyce" wrote:

Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...




  #10  
Old September 26th, 2007, 07:46 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default Does anyone have a Grants Tracking Database in Access to share

In addition to searching for Grant Tracking, you may consider searching on
Fund Accounting.
Fund Accounting is an accounting application specifically configured for Non
Profits to track donations (grants), expenses, etc.

BTW, Grant is not that great a programmer
--
Dave Hargis, Microsoft Access MVP


"ADRouse" wrote:

I have and I worked with the Customer services DB in Access and changed it a
bit but it's missing some elements like tracking funds requested and funds
awarded. I know I can make it work, I just wanted to avoid the many hours
updating and changing reports, forms and tables.

Thanks though

"Jeff Boyce" wrote:

Have you tried the Microsoft.com website for templates?

Have you tried using an online search engine?

Are you looking for a "ready-to-use" "Grants Tracking" application? If so,
how do you know that what someone else has designed for their specific
situation comes anywhere close to your needs?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ADRouse" wrote in message
...




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.