System Architecture¶

Application Type¶

All Forms is a split Microsoft Access application.

User
|
|
v
All_Forms_fr.accdb
|
| Linked Tables
|
v
All_Forms_be.accdb

Front-End Components¶

The front-end contains:

Object	Count
Forms	26
Reports	40
Queries	34
VBA Modules	5
Macros	4

Forms¶

Forms provide user interaction and management tools.

Examples:

Order Generator
Manage Attendance
Select Cadets
Checkout

Reports¶

Reports generate official documentation.

Examples:

Cadet Orders
Company Reports
Chain of Command
Certificates

Queries¶

Queries provide data filtering and calculations.

Examples:

Cadets
Company
Platoon
Hours
Orders

Application Components¶

flowchart TD
    User --> FrontEnd[All_Forms_fr.accdb]

    FrontEnd --> Forms[Forms]
    FrontEnd --> Reports[Reports]
    FrontEnd --> Queries[Queries]
    FrontEnd --> VBA[VBA Modules]
    FrontEnd --> Macros[Macros]

    FrontEnd --> Backend[All_Forms_be.accdb]

    Backend --> Tables[Data Tables]

Startup Process¶

The application uses the autoExec macro to run startup tasks.

Startup components include:

Initialization
Environment setup
User interface preparation*