The FRAMEWORK Database is a complete Microsoft Access application that can be used to create other Access applications easily, quickly and consistently. It also has a number of predefined screens and routines, so that someone who is just learning Access can use this database as an example of a professional looking database application.

As a complete application, FRAMEWORK displays a Main Menu, Reports Menu and a Maintenance Menu. It has the screens and table structures to maintain a list of Database Users and a list of Database Issues. In the Reports Menu is the "Database Issues Report." This report uses a parameter form that prompts the user for reports. The parameter form can also be used for data entry screens.

The FRAMEWORK Database also includes a table to keep track of releases and a System Parameters table to keep track of the name of the application, a description and the developer credits. This information can be displayed from the custom menu bar at the top of any screen in the application.

FRAMEWORK Database is made up of a Data Database, DFrame.MDB, a Front-End Database, FFrame.MDB and a Database Maintenance database, MFrame.MDB. The Data Database has only the table structure and any defined relationships between the tables. All other parts of the application, queries, forms, reports, macros and modules are all in the Front-End Database. This is necessary so that Front-End upgrades, which are the most frequent, can be done by simply replacing the FFrame.MDB file. This split database design allows the application to be easily migrated from an Access only application to a Client / Server application. With very few steps you can replace the Data Database with a SQL Server database connected via ODBC.

To View FRAMEWORK Screens, click here.

To Purchase FRAMEWORK, click here.

Hosted and Designed by

Dan's Consulting. Questions or comments send to Dan Bur at Dan's Consulting.