databasequery06

databasequery06 - Database Query Assignment: Performing...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Query Assignment: Performing Queries using Microsoft Access 1,2 WARNING This tutorial provides a detailed tutorial on using Microsoft Access, and an introduction to relational database & query concepts. You will need to apply what you learn in the tutorial in the exercises at the end of this document. You will submit your printouts resulting from these exercises to be graded as part of this assignment. There will likely also be questions on your exam relating to topics presented in this exercise. Pay attention to the information introduced and be sure you understand what you are reading & doing during each step. Simply following the steps without reflecting on how you are accomplishing tasks is a path to struggling with the exercises and missing points on the exam. Be sure you learn by doing. Good luck! Introduction The purpose of this exercise is to introduce you to techniques used for querying databases. As a manager, you're likely to want to query databases to turn data into information. The query tools in the Microsoft Access database management system provide a great environment for learning more about relational databases and query tools. The next few pages will introduce key concepts, provide you with some introductory exercises, and the final section will list problems to be completed as part of your homework assignment. Although you'll be using a database created by a particular product, Microsoft Access, the understanding of relational database concepts and query techniques that you'll gain in these exercises can be applied to a wide variety of database systems. In addition, although you're using Microsoft Access as the query tool, many other tools such as Visual Studio .NET and other third party products function very similarly. Your database contains tables for a fictitious food importer called 'Northwind'. Four of the tables contained in this database are shown in the diagram below (Categories, Products, Order Details, and Suppliers). 1 © Copyright John M. Gallaugher, Ph.D, Last Updated March 26, 2006. 2 Some of these exercises were in part adapted from the book " Visual Interdev 6 from the Ground Up " by Joseph O'Neil, published by Osborne Press.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
In this database, the Categories table lists information related to the categories of products that the firm sells. The Products table lists information on each product that the firm sells. The Supplier table lists information on each supplier that the firm deals with. The Order Detail table lists the detail of each order (i.e. a record for each item sold, like a line in a receipt). Like most databases that you are likely to encounter, this database is organized as a relational database . This means that the multiple tables in the database relate to one another via common fields (sometimes referred to as keys). The relations involving common fields are indicated in the diagram by the lines drawn between the tables. For example, the Products and Categories tables relate to one another on the common field
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/07/2008 for the course MI 02103 taught by Professor Gallaugher/sciore during the Fall '06 term at BC.

Page1 / 25

databasequery06 - Database Query Assignment: Performing...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online