Free Microsoft Access Database Download
We have made available for free two Microsoft Access databases. You can use the database to manage projects or to manage meeting minutes, agendas and action items. For those developing Access database applications, they are in .accdb format so you can see how various functions work. You can even “borrow” the code although we would appreciate you keep the reference to the original source.
The applications are no longer supported so you are on your own if you use them. We have extensive documentation on how to use them and both applications were used and supported for nearly a decade. The bugs have mostly been worked out.
Project Administrator.
Project Administrator is a comprehensive application to manage one or multiple applications. It records project details, benefits, scope variations, risks, issues, actions, resources and much more. It can be used by one or multiple people.
The application was developed around 2000 and sold to over 50 countries. We decided not to continue with the application some years ago, as most PM software was moving to the web, which would have meant a complete redevelopment. As we said, it is no longer supported.
THE ADMINISTRATOR LOGIN IS SET TO USERNAME: sysop and PASSWORD: sydney
From a developer perspective, we have used VBA for some interesting features in Microsoft Access.
- Using and managing logins
- Capturing the history for each user, including when they were logged in and what transactions they performed.
- Automatic updates from a website
- Setting screen options such as full screen, scroll bars etc.
- How to set read, add, delete and update for each screen
- Switching between form and datasheet view
- Emailing reports
- A complete help system built in Access
- Integration with Microsoft Access (you may need to set references in the Code window)
- Managing distribution lists
- A basic Gantt chart function
- Setting up traffic lights to measure project performance
Meeting Administrator
Meeting administrator allows you to set up a meeting and pick from a list of people to attend and venues. You can start by creating an agenda from scratch or by taking a previous agenda, duplicating the agenda, and modifying the items. After the meeting, you create the minutes, which list all the agenda items and allow you to make comments and add Action Items. These items go into a pool so any person can see all the action items outstanding from multiple meetings. There are various reports to monitor outstanding actions.
THE ADMINISTRATOR LOGIN IS SET TO USERNAME: sysop and PASSWORD: sydney
For a developer, this application has a range of administrative functions:
- Linking a database of tables
- Displaying a logo
- Setting the paper size for reports
- Setting up distribution lists
- Using a login for the application
- Managing user access
Download files
Each application has multiple files in a zip file.
- The main application
- A set of tables of example data
- A blank set of tables to use for your own environment
- Instructions in PDF format
You need to connect a set of tables. I suggest you connect the example tables first to understand how to use the program and its available functions. The Instruction book will explain the functions. When you are comfortable with the program, disconnect the example tables and connect the blank tables. The connection is carried out in the Administration section of the program, accessible from the home screen using the provided username (sysop) and password (sydney).
When this was a commercial program, the files were compiled (.accde). The files provided in this download are not compiled (.accdb).
We provide no support as the files are provided on a free basis for the interest of Microsoft Access developers.
As an uncompiled application, the code can be amended by users, hence any error can be caused by changes to the code, either intentional or accidental.