Updateable Bound Forms with Denormalized Data with Pat Hartman

Can you display and edit properly normalized data in a form which resembles a spreadsheet? Although it sounds impossible, it can be done with the right technique. Pat Harman shares her method.

She will show us the sample database containing two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is actually updateable. The technique uses a separate query for each column,  then a master query to join all the “column” queries into a single recordset. It is limited but works well for 12 months. Using her downloadable sample databases as templates, you can expand the technique in your own applications.

Sceenshot of calender in an Acess Form

Prepare for the presentation by downloading the files Pat will demonstrate and discuss.

Join us for a lively presentation and follow-up Q & A. We often range beyond the topic of the evening’s presentation, so plan on sharing your own ideas and experiences with your colleagues.

Please join us for our Monthly Chapter Presentation , at 6:30PM Pacific (UTC -8)

(Please verify your Time Zone offset with World Time Buddy as Daylight Savings changes are coming up soon.)

Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.

Add AUG Pacific meetings to your Outlook Calender


Please prepare ahead of time by downloading Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, join the meeting from here:

Join Zoom Meeting

If you are asked:

Meeting ID: 861 2395 1916
Passcode: AUG_AP1!

Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: AUG_AP1!
Find your local number