This folder contains samples and scripts for chapter 4.

4-001 -- Not included: Access does not support INTERSECT
4-002 -- Contained as query Listing 4-002 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-003 -- Not included: Access does not support EXCEPT
4-004 -- Contained as query Listing 4-004 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-005 -- Contained as query Listing 4-005 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-006 -- Contained as query Listing 4-006 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-007 -- Not included: non-executable code snippets
4-008 -- Not included: non-executable code snippets
4-009 -- Similar query saved in SalesOrdersSample.accdb (in the Sample Databases folder)
4-010 -- Not included: Not possible to emulate the sample CASE statement in Access.
4-011 -- Contained as queries Listing 4-011 and 4-011a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-012 -- Contained as queries Listing 4-012 and 4-012a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-013 -- Not included: Access does not support Functions.
4-014 -- Contained as queries Listing 4-014 and 4-014a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-015 -- Contained as queries Listing 4-015 and 4-015a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-016 -- Not included: Access does not support Functions.
4-017 -- Contained as query CustomerProducts in SalesOrdersSample.accdb (In the Sample Databases folder)
4-018 -- Contained as queries ProdsOfInterest and ProdsOfInterestLIKE in SalesOrdersSample.accdb (In the Sample Databases folder)
4-019 -- Contained as queries Listing 4-019 and 4-019a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-020 -- Contained as queries Listing 4-020 and 4-020a in SalesOrdersSample.accdb (In the Sample Databases folder)
4-021 -- Contained as query Listing 4-021 in Item27Example.accdb (in the Sample Databases folder)
4-022 -- Contained as query Listing 4-022 in Item27Example.accdb (in the Sample Databases folder)
4-023 -- Not included: no real equivalent to Access
4-024 -- Contained as query Listing 4-024 in Item27Example.accdb (in the Sample Databases folder)
4-025 -- Contained as query Listing 4-025 in Item27Example.accdb (in the Sample Databases folder)
4-026 -- Contained as query Listing 4-026 in Item27Example.accdb (in the Sample Databases folder)
4-027 -- Contained as query Listing 4-027 in Item27Example.accdb (in the Sample Databases folder)
4-028 -- Contained as queries 
            Listing 4-028a: CREATE TABLE, 
            Listing 4-028b: CREATE INDEX ixEmpFirstName, 
            Listing 4-028c: CREATE INDEX ixEmpLastName, 
            Listing 4-028d: CREATE INDEX ixEmpDOB and 
            Listing 4-028e: CREATE INDEX ixEmpSalary 
         in Item28Example.accdb (in the Sample Databases folder)
4-029 -- Contained as query Listing 4-029 in Item28Example.accdb (in the Sample Databases folder)
4-030 -- Contained as query Listing 4-030 in Item28Example.accdb (in the Sample Databases folder)
4-031 -- Contained as query Listing 4-031 in Item28Example.accdb (in the Sample Databases folder)
4-032 -- Contained as query Listing 4-032 in Item28Example.accdb (in the Sample Databases folder)
4-033 -- Contained as query Listing 4-033 in Item28Example.accdb (in the Sample Databases folder)
4-034 -- Contained as query Listing 4-034 in Item28Example.accdb (in the Sample Databases folder)
4-035 -- Contained as query Listing 4-035 in Item28Example.accdb (in the Sample Databases folder)
4-036 -- Contained as query Listing 4-036 in Item28Example.accdb (in the Sample Databases folder)
4-037 -- Contained as query Listing 4-037 in Item28Example.accdb (in the Sample Databases folder)
4-038 -- Contained as query Listing 4-038 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-039 -- Contained as query Listing 4-039 in SalesOrdersSample.accdb (in the Sample Databases folder)
4-040 -- Contained as query Listing 4-040 in SalesOrdersSample.accdb (in the Sample Databases folder)


