Microsoft Access Front End
General
The front end of an application is the only way for a user to manipulate data.
Accessibility
The front end usually offers the following measures of accessibility:
It is possible to provide the whole functionality in a single front end, while in larger systems it is wise to follow the "one task, one front end" paradigm, which means that all forms and the underlying business logic is bundled in one front end for each task.
The navigation is facilitated my providing
- menues,
- toolbars and
- shortcuts.
Key Bindings
The key bindings throughout the front end must be consistent and should accelerate the typical usage of the front end. This encompasses
- navigation and
- usage
Menues
The menues provide the most traditional way of offering functionality. They can be used for
- navigation and
- initiating actions
Depending on the complexity of the user operations and the design of the user interfaces, context menues can be a good choice too.
Tool Bars
Tool bars provide a more visual kind of offering functionality to a user. They offer navigational and functional accessibility but must not be overloaded by too much functionality.
User Interface
The user interface can be tightened and simplified further by disallowing to show the database window, disabling the Microsoft Access special keys, namely F11 and Alt+F11 amongst others. Converting the front end into a compiled version (.mde), protecting the code and digitally signing the code project adds additional security.
Startup
Sanity Checks
- References
Auto Start / Auto Exec
- Default settings
User Login
- Access Control Lists
- Messages
- Task List
Logging
- Log in / log out
Timer
- Log out active users on demand
Maintenance
- Compact and repair back end databases
- Back up back end databases
- Update data by SQL statements
- Update front ends
- Run automated tasks like
- fetching data
- sending mails
- running external automated tasks
Usage
User Forms
User forms are provided for all main tasks of the front end.