O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix E SQL Script to Create the Tables in This Book

This appendix provides the SQL script to create and populate 16 of the tables used in the examples throughout the book. To create and populate a single table, run the Create Table script. Next, delete the Create Table script and copy, paste, and run each INSERT statement one at a time.

Note: In Microsoft Access, each time you insert a new record, a message will display telling you that you are about to append one record. Click Yes in response to this message.

Create and Populate the Activities Table

CREATE TABLE Activities(ActivityID NUMBER CONSTRAINT ActID PRIMARY KEY,ActivityName CHAR (50) NOT NULL,StartDate DATE,EndDate DATE);INSERT INTO Activities (ActivityID, ActivityName, StartDate, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required