Beginner Advice for a Family Database

[newaccess user]

Mihail,

Thank you very much for your help. I have had a good look at the DB and it is very good.

The reports are very good and when I start to use it with the correct unit names and personal details i am sure I will get all I need from it.

I have saved all versions of the DB, to enable me to get a better understanding of what it is you have done.

Excellent work, Thank You.

 

[Mihail]

Finally (well... almost)

Unzip in C:\ . You will have troubles if will put this in other folder.
Create a shortcut on desktop for Welfare.mdb
Rename the shortcut as you need.
Enjoy.

Good luck !

 

[Geotch]

@Everyone
In this DB I have a report rptChildrenByArea based on query qryChildrenByArea (see Reports -> Child/Ages/Areas) that is hard coded.
I hate to do this (to hard code) but I don't know other approach.
Are you so kind to take a look and to give me some solutions/ideas ?
Thank you !

Create a cross reference table where you have min age, max age, report group. For example min age 0 to max age 3 = 0-3 year olds. Then use this cross reference table in the query to determine which group the children end up. If the 0-3 ever needs to change to 0-4, no big deal to change if the data is in a table.

Hope that helps

 

[Mihail]

Thank you for the answer, Geo, but, sorry, I don't understand what you mean.
Can you teach me what fields should I have in that table ?
Thank you.

 

[Geotch]

Thank you for the answer, Geo, but, sorry, I don't understand what you mean. Can you teach me what fields should I have in that table ?

I added a table called tblAgeRanges. If you use a similar table and put this into a form, the users can then change the criteria for the groupings and it doesn't require them to know Access. Check out the new query (qrtChildrenByAreaWithGroups) I've uploaded so you can see how it works. Hope that helps.

 

[Mihail]

@Geo
Thank you !
That is.

 

[Mihail]

@NewAccess
You should replace the old file with this one.
Note that your data will NOT be affected.
Only the interface will be improved.

 

[newaccess user]

@Mihail, Geo,

Thank you both.

I will now spend the time over the Christmas Break populating this DB, what a thrilling life I lead!

Kind Regards.

 

[Mihail]

@Mihail, Geo,

Thank you both.

I will now spend the time over the Christmas Break populating this DB, what a thrilling life I lead!

Kind Regards.

You are welcome anytime.

For sure you will find some bugs and/or you will have more requirements.
If you will make any change in the interface, upload your new interface when you will ask for more. This way your changes will not be lost.

Good luck !