Скачать или смотреть AEU41: Faking ‘Non-Normal’ User Interfaces with Normal Data (Pete Poppe)

In this presentation, Pete discussed several techniques to build “non-normal” interfaces while keeping the data normal. This included features such as:
• Use of temp tables
• Use of cross tabs for interface
• ADO in memory recordsets
• Custom unbound forms to act as a user control
• Treeviews
• Advanced sub data sheets

Download a PDF of the slides and other files used in this presentation from https://www.isladogs.co.uk/aeu-41

TIMES
0:00:00 Colin - welcome to the Access Europe User Group and this month's presenter Pete Poppe
0:00:46 Pete - intro, background & use of Access
0:03:37 Problem Statement
0:04:49 Common Problem Areas spreadsheet design / scheduling / surveys / checklists / calendars / hierarchical data
0:06:57 Objectives
0:08:09 Common Techniques and Tools - crosstab / preload records / in-memory ADO recordsets etc
0:09:32 Agenda
0:10:00 Scheduling Problem - use of 'pseudo grid control' - use of temp table
0:14:07 DEMO - Room Booking
0:14:38 Another Pseudo Grid - use of in-memory ADO recordset
0:16:28 Spreadsheet Style Interface
0:17:26 Use of Table As Grid vs Unbound Form
0:19:17 Unbound Form e.g. calendar
0:20:29 Calendar Year View
0:21:41 Crosstab as Grid
0:23:11 Crosstab as Popup
0:24:44 The Checklist - almost always Many-Many relationship with junction table
0:27:12 Many variations (but all similar)
0:27:45 Typical code flow - Clear old selections / Load new selections
0:28:36 Checklist DEMOS (x4) - subform / multiselect listbox / in-memory ADO recordset / crosstab
0:30:57 Create In-Memory Recordset
0:31:47 In-Memory Recordset Code
0:32:51 Cascading Combo Dilemma
0:34:38 Solution: don't cascade; use a popup
0:36:05 Hierarchical Data and Treeviews - previous AEU presentation on YouTube    • AEU30: Using Treeviews with Access (Pete P...  
0:37:22 Benefits of tree views - common examples - usage in standard form / report / listbox
0:38:08 Challenging to clearly present hierarchical data without treeview
0:41:13 Tree view examples - promote / demote /add / delete level
0:44:11 Fake tree examples in forms and reports
0:45:06 Graphical interface / 'Geolocate' - 3 examples
0:47:25 Mapping
0:48:40 Links (mainly to AWF threads):
Item Genie: https://www.access-programmers.co.uk/...
Tree views: https://www.access-programmers.co.uk/...
Schedule Grid: https://www.access-programmers.co.uk/...
Calendars: https://www.access-programmers.co.uk/...
Risks: https://www.access-programmers.co.uk/...
Restaurant: https://www.access-programmers.co.uk/...
Ship Tasks: https://www.access-programmers.co.uk/...
Non-Normal Forms presentation (Pat Hartman):    • AP:  Updateable Bound Forms with Denormali...  
0:49:42 Questions
0:49:57 Survey topic feedback - several interested in this topic for future presentation
0:50:22 Tim F - asked why use ADO for in-memory recordsets - not available in DAO, Faster than retrieving data from table & no bloat
0:51:15 Ade - explanation of how to raise hand in Zoom to provide feedback
0:52:40 Lex - asked about differences between a tree view and a network. Lengthy discussion
0:57:33 2 people asked how ADO recordsets are bound to a form - exactly like any other recordset
0:57:47 Domenico - compared tree view examples to an MIS he had used.
0:58:13 Pete - several tree view controls available both free & paid
0:58:48 Summary & thanks to Pete for an excellent presentation. Link to presentation slides & downloads
1:00:04 Next month (Wed 6 Aug) Colin Riddington - New & Forthcoming Features in Access
1:02:15 Sept: Adam Waller - Version Control for the Sole Developer
1:02:38 Domenico - update on support files from his July presentation: https://www.thesoftwaremaestro.com/si...
1:06:09 Final comments - see you all next month
1:06:24 End