Access+Bonus+Assignment

Access+Bonus+Assignment - Access Bonus Exercise (3 Bonus...

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

View Full Document Right Arrow Icon
Access Bonus Exercise (3 Bonus Points) Due at the Beginning of Class Monday, November 21, 2011 1. Copy the practice database “Class Example” posted on Niihka under “Resources” in the Database folder. 2. The database is based on the following entities, relationships, cardinalities, and attributes. (1,1) (0,M) (1,M) (0,M) Inventory Purchase Order Purchasing Agent 2. The Inventory, Purchase Order, and Purchasing Agent tables have been created for you. Begin by opening the Purchasing Agent table and changing Jim Mills name to your name. Create the PO/Inventory Details table. Click on “Create” tab, then select “Table.” This table will have a two-key primary key (PO Number and Inventory ID#) and the attribute Quantity Ordered. Make sure the PO Number has the same data type and field size as it does in the Purchase Order table. Make sure the Inventory ID# field has the same data type and field size as it does the Inventory table. To set up a two-key primary key, select both fields at the same time and click the gold key in the toolbar. After setting up the primary keys, check the field properties for each of the two primary keys. Look for the “Indexed” field. If it is not showing “Yes, Duplicates OK,” click in the box and look for a menu arrow. Open the menu and select “Yes, Duplicates OK.” Next, open the “Relationship” window. If all of the tables do not appear, click the right mouse button and select “Show Table” from the menu. Select the tables that were not in the relationship window. Create the relationships between the PO/Inventory Details table and the Inventory and Purchase Order tables. To create the relationships, click on PO Number in the Purchase Order table and drag it to PO Number in the PO/Inventory Details table. Click on Inventory ID# in the Inventory table and drag it to Inventory ID# in the PO/Inventory Details table. Enforce referential integrity and click on “Cascade Update.”
Background image of page 1

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

View Full DocumentRight Arrow Icon
Also, create the relationship between Purchasing Agents and Purchase Order. Enter the data shown in the table below into your PO/Inventory Details table. PO/Inventory Details PO Number InventoryID# Quantity 101 BSB201 12 101 BSKB101 36 102 FTB301 144 103 FTB301 500 104 BSB201 50 105 BSB201 100
Background image of page 2
3. Now run the following queries. Create the queries in design view. Click on “Create” tab, then select “Query Design.” a)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/19/2012 for the course ACC 361 taught by Professor Eighme during the Fall '10 term at Miami University.

Page1 / 12

Access+Bonus+Assignment - Access Bonus Exercise (3 Bonus...

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

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