Custom Search
 


What is Northwind Traders database



Northwind Traders Access database is a sample database that shipped with Microsoft Office suite. The Northwind database contains sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. You can use and experiment Access with Northwind database while you're learning and developing ideas for Access.

Northwind trader Access database switchborad

For example, you may want to experiment designing queries using the Orders and other related tables for trend analysis (in conjunction with MS Excel PivotTable) since these tables contain enough records to produce meaningful results over three years period.

Northwind sample database consists many Access functionalities, including tables, forms, queries, Reports, Macros, VBA Modules, etc. By using these objects, you can build database applications that can span from simple data storages to real world complex database applications with rich user interface support.

Northwind is like a real world application but the names of companies, products, employees, and any other data used or mentioned do not in any way represent any real world individual, company, product, etc.

You can use Northwind to explore nearly every important aspect of a Microsoft Access application.

Where to find Northwind Access database on my computer?

If you have installed Microsoft Access, you should be able to find northwind in its default location.

File Name Northwind.mdb
Size 2.108 MB
Default Location C:\Program Files\Microsoft Office\Office\Samples\
More info If for any reason you can't find Northwind on your computer, check out Microsoft article here.

What is the best way to learn Northwind?

The Northwind database includes a Help file called Show Me that documents the main features in the database. So The best way is to use the Help system that comes with Northwind.

How to location the Help system of Northwind?

  1. Copy Northwind.mdb and paste to a different folder. Highly recommended. Always keep an original version so that you can refer back to it at any time.
  2. Double click Northwind.mdb
  3. Click OK when you see the pop up window.
  4. On the menu bar, click Show Me button which is located at end of the bar.

    Northwind trader Access database menu bar

    Then, the Help system displays Overview of Northwind window.

OK, now go ahead and try it out by yourself.

More Access sample applications:

You probably will find these Access sample databases in the sample directory.

C:\Program Files\Microsoft Office\Office\Samples\

  • Address Book application Use this application to manage addresses and other information for individuals, families, and companies. With the database, you can save address and phone information for every member of a family, remind yourself when it's time to send birthday cards, print address labels, and export your address list to Microsoft Word.

  • Contact Management application Use this application to manage your personal and business contacts. With this database, you can save information on your personal and business contacts, record the time and subject of phone calls, send e-mail to any contact, set reminders, print labels or envelopes, and export your contact list to Word.

  • Household Inventory application Use this application to keep track of important possessions in your home. With this database, you can record serial numbers and purchase and replacement information; list items donated to charity for tax purposes; and import and export information from other applications.
Want more from Access Northwind database? You probably are learning relational database theory and need a sample database to explore the various concept. Northwind is a good learning database in this regard. Check out the following articles for Northwind in MySQL.



Copyright© GeeksEngine.com



Other Recent Articles from the MS Access category:

1.Examples of MS Access DateDiff function used in query and VBA code
2.MS Access DateDiff function
3.How to find out your computer name and username by VBA
4.Examples of MS Access DatePart function
5.MS Access DatePart function
6.Examples of MS Access DateAdd function
7.MS Access DateAdd function
8.IIF function basics - the CASE statement of MS Access
9.MS Access Date Expression
10.Solved: MS Access error "The text is too long to be edited"
11.Create MS Access Combo Box essential properties by VBA code
12.Create MS Access Combo Box essential properties manually
13.How to do text search in MS Access programmatically
14.Solved - the size of the Access query result is larger than the maximum size of a database (2 GB)
15.How to easily get a list of field names in MS Access
16.How to count distinct records in MS Access
17.How to do transaction based processing in MS Access
18.How to open a document (local/network file or web page) from MS Access
19.How to use ADOX to create unique composite index - the VBA approach
20.How to do cross-table update queries in MS Access - the right way
21.Three efficient ways to get the number of records by using VBA
22.How to create a composite unique index (not as a primary key) in MS Access
23.Use VBA to get the correct number of records in a Recordset object
24.Disable Access Prompt when a record is changed, table deleted, or action queries run
25.How to hide and unhide a MS Access object
26.How to return multiple values from a VBA function (Part 3)
27.How to return multiple values from a VBA function (Part 2)
28.How to return multiple values from a VBA function (Part 1)
29.Three ways to programmatically duplicate a table in MS Access by VBA
30.Create a DLL by CSharp or VB.Net for VBA
31.How to correctly reference and call a DLL
32.How to register a C# or VB.Net DLL
33.Email address validation by Regular Expressions using VBA
34.Fix MS Access error: Query must have at least one destination field
35.How to unselect radio buttons in MS Access after it has been selected
36.How to Change Query Timeout Value for MS Access SQL Queries

Copyright © 2024 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.

 
Home | Feedback | Terms of Use | Privacy Policy