Jam.py
Jam.py Application Design Tips
Development Checklist
Application Design
“How-to” guides
How was Demo built?
MS Access migration
MS Access migration
Top Migration Questions
Where from here?
Now what?
Some migrated examples
Acknowledgements
Jam.py
»
MS Access migration
MS Access migration
Here we touch base on Access migration to Jam.py.
MS Access migration
Top Migration Questions
1. Complacency
2. VBA?
3. Excel?
4. Queries
5. Primary Keys
6. Deployment
7. Compile Error
8. Cannot open the database
Conclusion
Where from here?
Notes/Issues
Terms and Conditions
Now what?
Tables
Using UTF8
Field Captions
Reserved Words
Deleted Flag
Primary Keys
Foreign Keys
Indexes
Users table
Some migrated examples
Personal Account Ledger
Overview
Lookup List
A little code
Validation
Master/Detail
API
index.html
Northwind Traders
Overview
Virtual Table
Slow Virtual Table?
Using a DB Views
Master/Details Edit
Master/Details View
Lookup Lists
Analytics
Bulk update, insert or delete
Inventory transactions