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, "Microsoft Access" will henceforth be used synonymously for the "Jet Database Engine".

Coding

• VBA Coding Conventions
• VBA Code Snippets
• Code Management
• Options

Architecture

• Front End
• Back End

Special Objects

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