Difference between revisions of "Main Page"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
== Microsoft Access == | == 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, | + | 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 === | === Coding === | ||
Revision as of 17:06, 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, "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