form with dropdown button and input boxes

[Zarrukh]

Hi guys,

I am new to Microsoft Access and I need a help from a guy with black belt in MS access. I have attached a kinder model of my database.
I have tried to create a relationship and query, but it did not work (seems like creating a relationship with a girl is easier ).
I want to create a form with two drop down boxes: one for choosing a country and one for choosing Year with Quarter.
The remaning part should just be boxes with demographic data. Say, "AGE1 -Age group 0-29" and right next to it a box where one can input/change data for AGE1 -Age group 0-29.



kinder model.zipkinder model.zip

Be kind with help and get 10 points of Karma to your personality

Thanks

[orange]

In plain English what is the business and processes involved?
You have told us how you have tried to solve something.
What exactly is that something? Plain English, no jargon, no database..

[Zarrukh]

thanks for your valuable time.
In simple words, this is the data on factors that influence chinese tourists to travel to different countries. These are demographics factors like year, age, education and gender. These data are available for each country and for several year on a quarterly basis.
To sum up, there are many countries with the data on the same demographic factors.
So I want something that unites all these countries and demographic factors accross different quarters and enables me to input the data in an easy way so that I would not need to go each table, search the right cell and input the data.

Thanks

[orange]

What do you want as output from this? Seems the design/set up is very dependent on the availability of data (the atomicity/summary level of available data). Some factors tourist attractions, season, weather, foreign exchange rate...

I found this online Chinese Tourists to Canada, it may be helpful as to outputs/summaries.

[ssanfu]

I've looked at your dB and see several problems that concern me.

You shouldn't use spaces in object names.
You have "ID" as a PK field name in every table.
You have calculated fields.
You have a look up FIELD
You have DATA as field names.
I don't see where the demographic data fits into the table(s).

I think the biggest problem is normalization. I would suggest you need to read up on normalization starting with
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html

Work through the tutorials at
http://www.rogersaccesslibrary.com/forum/forum46.html

A major problem with your table structure is that to add 2017 data, you will have to modify your table structure, queries, forms, reports and possibly some code. You would have to do this every year. With a properly designed table structure, you just add records (data).



-----------------------------------
Other things to read:
Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp

Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers

[orange]

Zarrukh,
Depending on what your demographic info source contains, you may have to extract portions of that data into your tables via some sort of query or loader function.
It would be helpful if you showed readers a sample of the raw demographic info you have.

Here is a generic model with some demographic info (I don't know how relevant this may be for you).