This folder contains samples and scripts for chapter 1.

1-001 -- Contained as query Listing 1-001 in Item02Example.accdb (in the Sample Databases folder)
1-002 -- Contained as query Listing 1-002 in Item03Example.accdb (in the Sample Databases folder)
1-003 -- Contained as queries in Item04Example.accdb (in the Sample Databases folder)
            Listing 1-003a  (Create table)
            Listing 1-003b  (Insert first row)
            Listing 1-003c  (Insert second row)
            Listing 1-003d  (Insert third row)
            Listing 1-003e  (Insert fourth row)
         in Item04Example.accdb (in the Sample Databases folder)
1-004 -- Contained as queries in Item04Example.accdb (in the Sample Databases folder)
            Listing 1-004   (Reconstruct original unnormalized view)
            Listing 1-004a  (Drop table)
1-005 -- Contained as query Listing 1-005 in the SalesOrdersSample.accdb file (in the Sample Databases folder)
1-006 -- NOT included - specific to SQL Server
1-007 -- NOT included - indexing on calculated column is not supported
1-008 -- NOT included - indexing on calculated column is not supported
1-009 -- Contained as query Listing 1-009 in the SalesOrdersSample.accdb file (in the Sample Databases folder)
1-010 -- Contained as queries in the SalesOrdersSample.accdb file (in the Sample Databases folder)
            Listing 1-010a  (Create Orders table)
			Listing 1-010b  (Define FOREIGN KEY constraint)
1-011 -- NOT included - Access does not support defining a FOREIGN KEY constraint in a CREATE TABLE statement.
1-012 -- Contained as queries in the Item07Example.accdb file (in the Sample Databases folder)
