Topics Search

Download sample databases

Download sample databases
Views: 61
Free Access 2007 database applications that you can download. These files are in .zip format and you have to extract them before use.
Sponsored Links:

Similar posts...


Add an Audit Trail to your Access Database

Add an Audit Trail to your Access Database Icon
My Access tutorials are designed to help people learn about building databases and how to add functionality to their databases with VBA programming. If you are just looking for some code to copy then skip down to the relevant code listings and help yourself to whatever you need. But if you want to learn something so that maybe next time you can figure it out for yourself, I urge you to read the accompanying notes that explain how I have come to the decisions necessary to fulfil the task at hand. I believe that in addition to telling people what to do, it helps to explain why they are doing it so my code listings are accompanied by explanations of what the code does, how it works and why it is necessary. I have also included two ready-made sample databases using the code shown here which you can download using the link at the bottom of this page.

Document 1000,s Access DBs automatically

Document 1000,s Access DBs automatically Icon
I've been able to find a few tools out there that will document a database nicely or compare a couple of databases. But I've got about 400,000 databases so I need a tool that I can point at a folder and it will loop through databases (and subfolders of databases) and document each one.

Does such a tool exist?

If not then do you know of a vb, vba, sample code that will get me at least part of the way to what I need

HTML + Access databases

HTML + Access databases Icon
I'm designing a website. Well I guess you can't call it a website because its only a series of html pages all thrown on a shared drive for employee's to be able to access.

However, here at the company we have multiple access databases we use daily, and one of the objectives is to be able to access any of those databases from this series of webpages.

but when I made the link to them, I was prompted with the box asking if I wanted to download them.

we don't want to download them every time, nor do we want to have a dozen shortcuts on our desktop.

Image Fade Download

Image Fade Download Icon
Image Fade Demo

More on this demo can be found in the Sample Databases Forum.

Grouping in Reports

Grouping in Reports Icon
The way my reports keep grouping using the report wizard is as follows:

Sample 1
________Sample 2
________________Sample 3
________________________Sample 4 Sample 5 Sample 6
________________Sample 3
________________________Sample 4 Sample 5 Sample 6
________Sample 2
________________Sample 3
________________________Sample 4 Sample 5 Sample 6

Is there a way to make it more staggered like this:

Sample 1
___Sample 2
______Sample 3
_________Sample 4 Sample 5 Sample 6
_________Sample 4 Sample 5 Sample 6
______Sample 3
_________Sample 4 Sample 5 Sample 6
___Sample 2
______Sample 3
_________Sample 4 Sample 5 Sample 6

Ultimately I am trying to tighten things up to allow more room.

employee details

employee details Icon
MS Access Sample Databases: Here is sample employee database for your use...

Introduction to Data Sheets

Introduction to Data Sheets Icon
Many techniques allow you to create a database, the fastest of which consists of using one of the provided examples. Microsoft Access 97 shipped with 22 sample databases while Microsoft Access 2000 ships with 10. Furthermore, the 97 version allowed to provide sample data into the database. This is not available with the 2000 release. The databases that ship with Microsoft Access can help you in two main ways: they provide a fast means of creating a database and you can learn from their structure.

View Users Currently Logged In Sample Database

View Users Currently Logged In Sample Database Icon
I recently down loaded this sample database and tried to use it using Access 2007. I was not able to get the database to work. It would not allow me to click on the Browse button. I kept getting a debug error, and it highlighted the first line of code behind the button. I manage several databases for a department of 30 plus people and this tool would be extremely useful for me, if it would work in 2007.

Predefined sets

Predefined sets Icon
I have created access database for laboratory sample evidence and now I would like to use it to collect analysis results. The information about sample is stored in one table (sampleid, samplename, date, .)

One of the possibilities is to create another table, only for the results, and create one-to-many relationship between the tables (one sample can be analyzed for more different parameters) but for each sample multiple parameters should be entered manually or from drop down-list. However, I would like to create predefined sets of parameters and used them for the specific samples. For example, for the sample 1 Ill use set 4, for the sample 2 set 1, for the sample 4 set 1, .

Expression Error On Database Startup

Expression Error On Database Startup Icon
I downloaded the Desktop Northwind 2007 sample database.accdb several times and when I open it and click the Login button I get this error

"Microsoft Office Access can’t find the field “I” referred to in your expression."

Then it opens the Home form.

What is going on? Did I do something to Access? What does this mean?

I have used it several times in some training and it did not do this before. Now no matter how many times I download it I get the same error so I suspect I did something to Access but what.

Can't remember doing anything to change the database especially expressions and I have downloaded it several times with the same error. Since it is a sample database, how come the errordoesn't go away when I replace the database with a new download.