JFD Art - 2 - Setting Up Tables

The record card that JFD currently uses stores the following data:

• Name of painting
• Artist
• Age of artist
• Media
• Date of production
• Nationality (of artist)
• Value
• Size (width x height)

This information will be split into 2 tables as follows

Table 1 - Artist

Table 2 - Painting

STEP 1  -  Create a new blank database

• Create a new folder in your My Documents folder called 'Database Project'.
• save the new database as JFDART

NB.  Check that your new database is 2000-2003 compatible by clicking Tools > Options > advanced > default file format.

ARTIST TABLE

STEP 2 - Create a Table in Design View

STEP 3 - Setup basic field information

STEP 4 - Set the primary key

• Click on the Artist ID field name and EDIT, PRIMARY KEY
• You should now see a small key next to ArtistID

STEP 5 - save the table

• use the table name Artist

STEP 6 - set more complex field attributes

• Click on ArtistID
• This is a whole number - set Decimal Places to 0
• This is very important - make it Required (Yes)

• Click on ArtistName
• A name is unlikely to contain more than 30 characters to change the field size

• Click on ArtistAge
• There are no decimal places in an age
• Artists will be at least 10 years old and no older than 120 - set the validation rule below
• Provide text to the database user in case the rule is broken (validation text)

• Click on Nationality
• Nationalities will be comfortably stored in 30 spaces - change the field size

PAINTING TABLE

STEP 7 - Create a table in design view

• Set up the field names

Step 8 - Set Primary Key

• PaintingID

Step 9 - Save Table

• As Painting

Step 10 - Set more complex field attributes

• Painting ID - no decimals
• ArtistID - no decimals
• Media - Lookupwizard (see below) - this will give a list of choices for the database user to choose from

• Click on Finish

STEP 11

Scroll to the top of this page and use the information in Table 2 to set the field length and decimal places attributes on the height and width fields

You have now successfully setup your 2 database tables.  Now it's time to enter the data!