Main Page

Design

• Naming Conventions
• Patterns
  • 1:1
  • 1:n
  • m:n
  • Unique number in multi-user environment (SettlementId)

SQL

• Well Formed SQL Statements

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

• VBA Coding Conventions
• VBA Code Snippets
• Code Management

Architecture

• Front End
• Back End

Special Objects

• System tables
• Temporary tables (~sq_f*)
• OLEDB-Queries