Access Programming

[jucream]

Hello,

I am new to these forums, and am an idiot in Access. i work for a small nonprofit and manage a project through our state Division of Rehabilitiation Services in providing Assistive Technology Services tp their clients (DORS is an agency which provides services to people with disabilities to gain meaningful employment, increase their independence or be successful in pursuing educational goals).

I have been trying to create a database to track the authorizations/clients I serve, some of them have worked but are a bit too complicated in which i am sure can be put together easier (more efficiently) and basically I am afraid to implement it as it would probably fail. Mainly a merger between a number of templates avaliable for free.

What my question is, is how much does it cost (in general) to hire someone to create the database for me. I am basically looking for a database that will be able to store client information (name, contact etc... information about their disability and their goals (employment, education etc...) who their counselor is and their contact information (multiple clients per counselor).

Now each client may have multiple authorizations (I.E. An Authorization for an Evalutation and then for training). So I need service records related to the specific authorization and then the ability to store invoices and reports related to that authorization as well. I would like it to link to a report as I create them in word and save them on a server. I would also like the ability to have the reports sent to the counselor via e-mail from the database.

Hope this makes sense, if anyone would have a generalized going price for somthing like this in terms of hiring someone to complete it that would be GREAT. Thank you,

Justin

 

[Vassago]

You'd be surprised how much help the people of this forum can give....for free. How about you give it a go, and we'll be happy to answer your questions along the way.

 

[Big2]

Could i ask where u are from? The company that i work for already have bespoke systems setup and the one you'd be looking for is called Asset. We provide a lot of software to the public sector and because they are bespoke it means the prices are not so high.

You could have a look at Asset and address any minor changes that you would like etc but that then would cost development, going rate would be around £50 / hour. The system itself you'd just buy a license for and im not too sure how much but its not anything more than £1k i dont think.

Anyway if you think your interested then private message me and i can get someone who works on that system to talk to you more.

Thanks

 

[Big2]

Or yeah as Vassago said there are a lot of people on this forum who would help for which ever problem you come across within VB, VBA, Access and then if your using an SQL backend you can also find help for that.

 

[MStCyr]

If you could put some specs together I'm sure we can get you started.

 

[jucream]

Thanks

Thank you to everyone who replied. I think I am going to take another crack at this thing, with everyones help but want to search around these boards a bit first so i can see if some of my questions are answered prior to asking the same thing before I start rambling off all my questions.

Thanks again for the replies.

Justin

 

[jucream]

I have put some thought into this, looked over the site, and couldnt apply any of the other situations to me, so I am hoping that someone can help clarify all of this for me, as I think my main problem with this whole Access thing is understanding relationships and the ID's. Below is a diagram of what I forsee my tables looking like Green is the table, blue is the feilds, and yellow is options under the main feild (i.e. someone may be referred for Training which would also include travel time).

Okay, so how this whole system works, is that a counselor refers a client to us, and provides an authorization (basically promissary note saying they will pay for the services - therefore everything revolves around the authroization).

Now i create a table with all of the headings in Green. There will only be 1 counselor and 1 client - but a counselor may refer more than 1 client, therefore I assume that is a one-to-many relationship. Between the counselor and client. So I take the Counselor ID (Primary Key) and drag that to the Client Table.

For Authorizations, since each authorization number is unique, I create that as the primary key. Now there is only 1 client per authorization, but there can be many authorizations per client, therefore that is a 1 to many relationship between the client and authorization, so I drag the Authroziation number to the clients table. Now the relationship between the counselor and authorization is that there can be many authorizations per counselor, but only 1 counselor per authorization so I again drag the authorization number to the counselor table.

Now in terms of Primary Keys, I would basically just do an autonumber with Counselor ID and so on, except for Authorizations because each authorization number is unique to begin with and for clients, each case number is unique to that client.

Does this sound like I am on the right track???????

Thanks.

Justin