Former marine wasnt made to design access

[VeteransVillageSanDiego]

Hey Guys, So I volunteer for Veterans village of San Diego which help veterans. Being a former Marine infantryman myself I am little out of my element creating an access database. I have posted the link to Google docs to show what i have so far. I’ve done a majority of the graphical layout and basic programming but some of the more complex features I have no idea how to go about doing. If any one has some free time and expertise in access I would be very appreciative for any help you could lend. Thanks




Database is here, it’s a little big sorry:


https://docs.google.com/leaf?id=0B9mdwEkZMipINjI4Mzg3YjAtMjhiYS00MTRlLThlN TYtMjc5NzYyYmNlMzQz&amp;hl=en">https://docs.google.com/leaf?id=0B9mdwEkZMipINjI4Mzg3YjAtMjhiYS00MTRlLThlN TYtMjc5NzYyYmNlMzQz&hl=en</a>

[tomvvsd]

Cannot see your Google file. Please contact me ASAP tom.mitchell@vvsd.net

[Access_Blaster]

Hi VeteransVillageSanDiego,

Use the "Attach" button it looks like a paper clip.


Richard

[NoellaG]

Hi,

herewith you find an example of your database with the following changes:

Used standard naming
· Using prefixes
· removing all spaces from the names
Structure:
· Clients and closed clients can be in 1 table, just added the indicator fields “cltsClosed” and cltsClosedOn”
· All WW tables are in one table: tblFunds with a lookup field for the type
· Fields can only contain one and the same information, so you can’t have a field with “age or year of birth”, just store the year of birth, the age can be calculated. This way it will always be correct.
· Removed duplicate fields
· Split tables where necessary, I think there’s a many to many relation between clients and referrals to a fund, so I set up the table with clients, a table with funds and a connecting table tblclientrefferals to connect them
Beware:
Validation texts are only shown when using a validation rule and entering a wrong value

Hope this example helps, but beware that it's only that: an example
NG