You'll find free demos and sample Access Databases here.
If you have questions or comments about any of my free Access sample databases,
please post your comments and questions at
Feel free to suggest ideas for additional samples or demos.
You can also
begin a conversation
Access 2013 web apps
|GPC Home||About GPC||Blog--GPG On Access||More Free Access Stuff||Resources & Links||Access Test Bed||Tip of the Day||Contact GPC|
|Ask me how to migrate your obsolete spreadsheets or Access databases to modern Access Web Apps|
MS Access MVP Awardee:
My 10th Year as an MVP
Blog: GPG on Access
Grover Park George On Access
Why You Might Need This Free Access Database
Before deploying your brand-new Access database into a production environment, wouldn't you like to know whether it will stand up to a heavy load? Here is a tool that can help in avoiding situations where you deliver your database and two months later the client is complaining that it takes FOREVER to get anything done. Is Access really that bad, or is it your code?
Where the Data Came From
Most of us like to conduct tests prior to releasing our applications for normal use, but it always isn't meaningful to test on only a handful of rows of data. Recently, one of my colleagues, MVP Ben Clothier , who goes by the screen name BananaRepublic at Utter Access , and Banana, at Access World Forums , decided to do something about that problem. He made available this testing database with several millions rows of data to his fellow Access Developers.
This free sample database was developed by Patrick Crews and Giuseppe Maxia. It contains six tables and approximately 4 million records. Banana took their existing sample database and adapted it for Microsoft Access.
While it may not answer every question, it can be useful in answering questions that require a dataset consisting of more than ten rows of data.
The database can be useful in assessing:
There are three versions: one for A2000 , one for A2002-2003 and one for A2007 . Each of the three zipped files is approximately 69MB. The downloads are free to anyone who wants the data. The data is licensed under a Creative Commons license The downloads are also available at two or three other mirror sites.
NEW for 2016. SQL Server tables as a bacpac.
You can now obtain the Employee database tables and data as a bacpac, ready to import into your own SQL Server or SQL Azure instance. Download it here