Topics Search

Download sample databases

Download sample databases
Views: 60
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:

More topics

 

Add an Audit Trail to your Access Database

Preview
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.
 

HTML + Access databases

Preview
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.
 

Document 1000,s Access DBs automatically

Preview
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, vb.net sample code that will get me at least part of the way to what I need
 

Image Fade Download

Preview
Image Fade Demo

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

MS Access 2000 Tutorials and Documentation

Preview
Some of the following tutorials are available as .PDF files which you can download and print. Others can be run from the Web. In that case, a sample Access database is usually available for download from the first page of the tutorial.
 

Grouping in Reports

Preview
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

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

Introduction to Data Sheets

Preview
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.
 

MS Access Tutorials and Examples for versions 2000, to 2007

Preview
This page is dedicated to listing all of our MS Access Tutorials and Examples. All Listings include written descriptions and some images. In the Table below you will find the MS Access Listings and a very brief description about what it covers. The VBA Examples do include sample databases for download and code snippets online to copy/paste right into a module.
 

Expression Error On Database Startup

Preview
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.