Download sample databases

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:

Related Topics

Add an Audit Trail to your Access Database
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
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
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

Image Fade Download
Image Fade Demo

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

MS Access 2000 Tutorials and Documentation
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
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
MS Access Sample Databases: Here is sample employee database for your use...

Introduction to Data Sheets
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
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
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.

View Users Currently Logged In Sample Database
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
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, .

How to run this code?
Let me just start by saying, I am completely lost when using VBA.
I am heavily relying on sample codes and databases, but I do not understand how to test the following

Populating checkbox options from combobox choice
I'm currently working with a team of scientists in the field. We have a number of transects each of which have a varying number of sample sites along them. I would like to create a data entry form that allows the choice of transect number to generate checkboxes for all the sample sites on that transect (with accompanying sample site name).

So for example, if transect A has 4 samples sites, B has 7 sample sites etc, in the form if the user were to choose transect B 7 check boxes would appear to allow them to choose which sample sites were actually sample

Best Practices Question
Please see my sample DB, sometimes my verbiage is off and a sample may help. My DB has 2 sample tables. I want to know why one way is better than the other.
I am specifically dealing with the way I link the company name to the employee.

Sample 1 Is a direct drop down from one table to the other.
Sample 2 Is a link to the ID of the company via the combo drop down. So technically it is only showing the company, but storing the ID.

In all of the samples I find online Microsoft seems to go with the second sample style. So my question is this:

From a design element why is the second option so much better than the first?

I know the second option is better when a record such as company name changes you would not have a ton of orphan records tied to a company that no longer exists in tbl_COMPANY, but it also makes queries harder to write. See query sample1 and query sample2. So why is the second option the way to go

sample template customers and products
I would rather just copy/modify a sample database than try and program one from scatch
I am looking for a
customer main table
When I select a customer I can assign certain products to that customer and the main table and form will work out the total price
table of customers
name addresss.
product code, description, price . etc

I want to be able to search for a string ie which would included in the product description maybe using some wildcard code *samplestring*
Up will pop up all the likely products
I pick the product and these are assigned to the customer I have in the open table/form

There must be sample databases like that out there
I can customise it if I can work out how to do the data transfer from
product to customer
subform to main form

Microsoft Access help, tutorials, examples
Brief tutorials and help for novices and database developers. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download.

CSV vs XLS Import
I get data for one of my databases by downloading from an Oracle database. I can download in either CSV or XLS format. That database contains several date fields and the name field is first and last seperated by a comma.

I want to be able to import it into Access so that I can generate reports from it. If I download CSV it seperates the name into two fields so the rest of the fields are thrown off. If I dowload it as an XLS file, it converts the dates.

Is there a way to import the spreadsheet so that it will work with both? I am using Access 2003 at work

Appointment scheduler
I would like to add an appointment scheduler to my database. Can anyone help me with some tips or does anyone know where I can download a sample?

Access Forms: Custom Navigation Buttons
In this video I show you how to add a set of custom navigation buttons to an Access form. The video is recorded in real time from start to finish showing you just how easy it is to complete this task including writing the VBA code necessary to power the buttons. The video accompanies my tutorial Access Forms Masterclass #1: Custom Navigation Buttons where you can follow the fully illustrated written instructions, download a sample file containing the completed project, and download a printable PDF of the tutorial.