Difference between revisions of "Main Page"
Jump to navigation
Jump to search
(→Coding) |
|||
| Line 18: | Line 18: | ||
* [[Microsoft Access Code Management|Code Management]] | * [[Microsoft Access Code Management|Code Management]] | ||
* [[Microsoft Access Options|Options]] | * [[Microsoft Access Options|Options]] | ||
| + | * [[Microsoft Access Database Properties|Database Properties]] | ||
=== Architecture === | === Architecture === | ||
Revision as of 18:07, 4 July 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, "Microsoft Access" will henceforth be used synonymously for the "Jet Database Engine".
Coding
Architecture
- Front End
- Back End
Special Objects
- System tables
- Temporary tables (~sq_f*)
- OLEDB-Queries