free simple database to download

[samipm]

Dear Sir/Madam

Does anyone has a simple order, library, invoice or student results database example that I can download

God Bless
Sami

 

[sheetspread]

Have you looked at Northwind? It was included with previous Access versions, hopefully still is.

 

[samipm]

Thank you for your prompt response.
I am after a very simple example

 

[sheetspread]

Try here:

https://www.youtube.com/results?search_query=ms+access+sample+database

Many of them have files you can download as well as web pages of even more examples and lessons.

 

[Joe4]

Cross-posted: Example of a simple access 2010 free download

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

 

[samipm]

Try here:

https://www.youtube.com/results?search_query=ms+access+sample+database

Many of them have files you can download as well as web pages of even more examples and lessons.

After examining 15 pages of the suggested site, it did not find any free database to download.
I am trying to help someone on how to use access but I do not have any simple example.
It would be nice if someone could help

God Bless
Sami

 

[Joe4]

As was mentioned earlier, Access usually comes with a free database sample, the Northwind database.
It appears that you can also download it from here: Download northwind microsoft access templates database and examples

 

[sheetspread]

I glanced over several of the youtube videos and they're very good for learning the basics: building a table, form, report, and query. You're right, none of them seem to offer a sample to download though I originally thought so because of a link that was included. Still, try to build what you see in the videos, I think it's worthwhile.


Here's 1 with files I found through google but haven't tried: Microsoft Access 2010 downloads for database development

I do not have any simple example.

You're right, Northwind is a bit much to learn the basics, but look at the components anyway in design and normal view. It's not hard to scale down.

For instance, in the Invoice query, scroll to the right in design view, and note Extended Price, in which after right clicking and choosing Build you can see a formula similar to Excel's. You don't need most of the other fields to create something like that. You can just write [Field1]+[Field2] as a simple formula, and work your way up from there.