Flattened Forms

[tempk]

Hi everyone,
I have an interesting problem at hand.

Assume that I have a normalized table with the following structure:
Pk
fkDept
fkAcct
Mth
Details
Amt

But...in order to cater to spreadsheet users and also to allow data to be seen at a glance while being entered(as opposed to opening a form), how would I go about designing the form etc?

I have done something similar but it is using a denormalized structure and feel like further improving my design. How the underlying table looks like:
Pk
fKDept
fkAcct
Details
Mth1
Mth2
...Mth12

Amount is entered under the month. I have understood and realised some drawbacks by using the aforementioned structure.

But it seems like for the normalised structure, it is rather hard to make a similar looking form. And yes, I have read up on normalisation and searched on the forum. What I'm looking for is perhaps a solution to the form problem?
I decided to embark on the normalised structure because there will be occasions where complex functions are needed to look up for a particular sum of an acct on a particular month. A simple query will solve the problem if I used a normalised table.

Thanks.

 

[Mile-O]

This is where subforms come into play.

 

[godofhell]

If you are looking for a spreadsheet style of data entry use the Datasheet sheet view properties on the form. Using a form as a Datasheet view will allow you to customize the headers so that you don't show the field names that are used on your table and will also grant you more options only available to forms.