Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Thomas Burt/Lab 2.1

Create a new blank database

 * Office Icon (upper left of window) -> New -> Blank Database
 * Change the File Name to "Inventory"
 * Click "Create"

Create new fields

 * First Name
 * Last Name
 * Email
 * Phone Number
 * Postal Code
 * CityID


 * Save the table
 * CTRL-S
 * Change the name to "Customers"

Create "Products" table

 * Select the "Create" tab from the menu at the top of the screen
 * Click "Table"


 * Add the following fields
 * Name
 * Price
 * Quantity in stock


 * Save the table
 * CTRL-S
 * Change the name to "Products"

Create Cities and Provinces table

 * Select the "Create" tab from the menu at the top of the screen
 * Click "Table"


 * Add the following fields
 * Name


 * Save the table
 * CTRL-S
 * Change the name to "Cities"

Table Relationships
Question: Why did we create a table for Cities? Why didn't we just create a "City Name" column in the Customers table?

Add relationships to the tables
http://pages.cpsc.ucalgary.ca/~teburt/relationship1.JPG
 * Click the "Database Tools" tab -> Click the "Relationships" button
 * Add all the tables
 * Double click the 'City ID' field in the Customers table
 * Click the "Create New..." button on the right side of the dialog
 * Select the following fields:


 * Click "OK" and then click "Create"

Forms
Now lets create a forms so we can enter customer data into the database.


 * Click the "Create" tab -> "Forms" pane -> "More Forms" pull-down menu
 * Click "Form Wizard"
 * Select the "Customers" table
 * Select all the fields except for Customer ID
 * Choose a layout and a style, or just click finish

It should look something like this: http://pages.cpsc.ucalgary.ca/~teburt/customers_form.JPG