New Page 1

HITEK Computer Services - Setting Up Tables

This database will contain 3 tables storing the following information

customer information
computer specifications
warranty details

CUSTOMER TABLE

FIELD NAME	DATA TYPE	OTHER ATTRIBUTES
CustomerID	Number	Primary Key Required No duplicates
CustomerName	Text	30 Required
Address	Text	30 Required
Town	Text	30 Required
Postcode	Text	10
Telephone	Text	12 Required
Fax	Text	12
ContactName	Text	30

COMPUTER TABLE

FIELD NAME	DATA TYPE	OTHER ATTRIBUTES
SerialNo	Text	Primary Key Required No Duplicates
CustomerID	Number	Required
CPU	Text	Required
MemoryMb	Number	Required
PurchaseDate	Date/Time	Required Short Date Input Mask

WARRANTY TABLE

FIELD NAME	DATA TYPE	OTHER ATTRIBUTES
SerialNo	Text	Primary Key Required No Duplicates
Warranty Type	Text (Lookup)	Required Lookup (None, NBD, 4 hr onsite, 8 hr onsite)
Engineer	Text (Lookup)	Required Lookup (J Sykes, P Taylor)
Weekend Access	Yes/No

create a new database save it as HITEK
Create the 3 tables above - check that your attributes and data types are correct
Save the tables as Customer, Computer and Warranty
Look at JFD Art (click here) for a reminder of some of the key skills required for this task

How to create a short date input mask

An input mask is a technique in a database to make it easier for the user to enter information and very difficult to enter data in the wrong format. We want dates stored as DD/MM/YYYY e.g. 03/04/2005 (NB. Next task you will need to input all the dates to 2005).

Above is an extract from the computers table - can you see that when a new date is entered the / divisons appear automatically? This is how you do it!

STEP 1 - START THE INPUT MASK WIZARD

click on the PurchaseDate field
Click on the input mask control button (look at pink arrow)

You will be asked to save the table - choose YES

STEP 2 - CHOOSE INPUT MASK

choose the short date input mask
click FINISH

Introduction	Setting up tables	Inputting Data
Creating Relationships	Queries, Sorts & Calculations	Reports
Graphs