1 / 0

Northwind – An Access Classic Lives On

Northwind – An Access Classic Lives On. Lisa Friedrichsen. Johnson County Community College, Overland Park, KS. Microsoft ® Access 2010: Illustrated Complete. New Perspectives : Portfolio Projects for Business Analysis. Today’s Session. Find and download Northwind

airell
Download Presentation

Northwind – An Access Classic Lives On

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Northwind – An Access Classic Lives On

    Lisa Friedrichsen Johnson County Community College, Overland Park, KS Microsoft® Access 2010: Illustrated Complete New Perspectives: Portfolio Projects for Business Analysis
  2. Today’s Session Find and download Northwind It’s all about relationships! Exercises for your students
  3. Why Northwind? A: It is the most popular relational database of all time! popular = educational Northwind provides a common language for database developers
  4. Links and Northwind Articles Northwind is the most popular relational database of all time! FIND and DOWNLOAD Access 2000 Tutorial: Northwind Traders Sample Database (From Microsoft) http://www.microsoft.com/download/en/confirmation.aspx?id=19704 (From cnet) http://download.cnet.com/Access-2000-Tutorial-Northwind-Traders-Sample-Database/3000-2251_4-10742880.html GeeksEngine.com What is the Northwind Traders database http://www.geeksengine.com/article/northwind.html How to export the Northwind Access database to MySQL Make Northwind a true relational database in MySQL Other articles CWN Research Custom Software and Database Development A Quick Microsoft Access 2000 Tutorial http://www.cwnresearch.com/resources/databases/access/tutorials/access2000/GettingStarted/GettingStarted.html 1st Contact Database Services Free 1 Hour interactive tutorial http://www.1staccesshelp.com/Northwind.html About.com Microsoft Access tutorials http://databases.about.com/od/tutorials/Tutorials.htm Educational videos – search at youtube.com http://www.youtube.com/watch?v=UdKVjHg1FSE
  5. New Northwind Templates Northwind 2007 sample database Customized Navigation Pane 20 tables Half baked “privileges” 4 of 5 stars (1029 votes) Northwind web database SharePoint connectivity 3 of 5 stars (9 votes) What was Microsoft thinking?
  6. Find and download classic Northwind Nwind.exe: self-extracting zip file provides Nwind.mdb, (Access 97 file format) If you open in Access 2010… No: Nwind.mdb: 97 file format File|Save & Publish to other formats such as 2000 or 2002-2003 (both of which are .mdb) Yes: Nwind.accdb: 2007 - 2010 file format
  7. Default Access database file formats Software file format extension Access 97 Access 97 .mdb Access 2000 Access 2000 .mdb Access 2002/XP Access 2000 .mdb Access 2003 Access 2000 .mdb Access 2007 Access 2007 .accdb Access 2010 Access 2007 – 2010 .accdb
  8. Clean up Issues Yes: Convert to .accdb Delete Conversion Issues table Unhide objects (Right-click|Object Properties) Database Tools|Relationships -- resize
  9. Relationships
  10. Relationships
  11. Relationships
  12. Relationships
  13. Relationships
  14. Relationships
  15. Relationships
  16. Explore Tables! Show subdatasheets Customers ~ Orders ~ Order Details Look for a field with each data type Discuss field properties: Descriptions, Field Size, Captions, … Order Details table Product field: Lookup properties Discuss mistakes Products table: QuantityPerUnit field
  17. Explore Queries! Show different query icons: Select, Crosstab, Union Select queries to learn new possibilities: Alphabetical List of Products: Products.*, Show check box Category Sales for 1995 based on another query Employee Sales by Country has parameter criteria Ten Most Expensive Products uses Top Values Alternate Row Color, FieldName:, Caption Create your own query, check SQL view
  18. Explore Reports! Alphabetical List of Products: show grouping Catalog: Show sections Employee Sales by Country: uses parameter query, Show On No Data event Invoice: just a beautiful report Products by Category: multiple columns Sales by Year: invokes Sales by Year Dialog (form) Summary of Sales by Quarter: date grouping options
  19. Explore Forms! Employees show different control types Categories subform in continuous forms view Bmp picture (compare to jpg in Attachment field) Customer Labels Dialog Show macros behind buttons Customer Orders Subform has a subform Main Switchboard (show command buttons) Orders (show calculations, preview vs. print)
  20. Northwind Exercises! Unit J: Analyzing Database Design Using Northwind Normalizing data Analyzing Relationships Evaluating Tables Improving Fields Using Subqueries Modifying Joins Analyzing Forms Analyzing Reports Microsoft® Access 2010: Illustrated Complete ISBN-13: 9780538747172
  21. Northwind Exercises! Project 1: Budgets Project 2: Income Statement Project 3: Balance Sheet Project 4: Cash Flow Project 5: Decision Support Project 6: Scenario Analysis Project 7: Breakeven Analysis Project 8: Projection and Trend Analysis Project 9: Linear Programming Project 10: List Management Project 11: Relational Database Management Project 12: Querying a Relational Database Project 13: Information Communication Project 14: Interface Design Project 15: Database Application Development New Perspectives: Portfolio Projects for Business Analysis ISBN-13: 9781133274773
  22. Thank you! Best wishes! Lisa Friedrichsen lisalfri@jccc.edu
More Related