REVIEW V1.1 Released: March 26, 2011
REVIEW V1.1 Released: March 26, 2011
Module 4 - Table Inheritance (Lab Manual)
Microsoft Confidential - For Internal Use Only
This training package content is proprietary and confidential, and is intended only for users described in the training materials. Thiscontent and information is provided to you under a Non-Disclosure Agreement and cannot be distributed. Copying or disclosing all or any portion of the content and/or information included in this package is strictly prohibited.
The contents of this package are for informational and training purposes only and are provided "as is" without warranty of any kind, whether express or implied, includingbut not limited to the implied warranties of merchantability, fitness for a particular purpose, and non-infringement.
Training package content, including URL and other Internet Web site references, is subject to change without notice. Because Microsoft must respond to changing market conditions, the content should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannotguarantee the accuracy of any information presented after the date of publication. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should beinferred.
Copyright and Trademarks
© 2011 Microsoft Corporation. All rights reserved.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents,trademarks, copyrights, or other intellectual property.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose,without the express written permission of Microsoft Corporation.
For more information, see Use of Microsoft Copyrighted Content at http://www.microsoft.com/about/legal/permissions/.
Microsoft®, Internet Explorer, and Windows® are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Microsoft products mentioned herein may be either registeredtrademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are property of their respective owners.
About the Authors |
Author: | Becky Newell |
Table of Contents
Lab: Table Inheritance 1
Challenge Yourself 1
Step by Step Instructions 3
Create a Base Table 3
Create Two Derived Tables 3
Create a Derived Table thatExtends Another Derived Table 4
Perform Inserts into a Table Hierarchy 4
Select Records from a Table Hierarchy 5
Perform Updates in a Table Hierarchy 6
Perform Deletes in a Table Hierarchy 7
Add a Derived Table as a Data Source to a Form 9
Add a Base Table as a Data Source to a Form 9
Lab: Table Inheritance
In this lab, you will implement table inheritance. You will also performcreate, update, select and delete statements against tables that are in an inheritance hierarchy. Lastly, you will add the tables you implemented to a form and manipulate the data through the form.
1. Create a base table called Shoe.
2. Set the SupportInheritance property to Yes and create an InstanceRelationType field on the table.
3. Add the following fields to the...