Difference between revisions of "Main Page"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
* [[Microsoft Access VBA Code Snippets|VBA Code Snippets]] | * [[Microsoft Access VBA Code Snippets|VBA Code Snippets]] | ||
* [[Microsoft Access Code Management|Code Management]] | * [[Microsoft Access Code Management|Code Management]] | ||
| + | * [[Microsoft Access Options|Options]] | ||
=== Architecture === | === Architecture === | ||
Revision as of 17:04, 19 June 2010
Design
- Naming Conventions
- Patterns
- 1:1
- 1:n
- m:n
- Unique number in multi-user environment (SettlementId)
SQL
Microsoft Access
Technically speaking "Microsoft Access" is a front end for the "Jet Database Engine". For the sake of simplicity and as many people do not know the difference, the database will henceforth be called "Microsoft Access" too.
Coding
Architecture
- Front End
- Back End
Special Objects
- System tables
- Temporary tables (~sq_f*)
- OLEDB-Queries