Scribd
Upload
70 views2 pages

Exercises Exercise1: Create Table by Using Wizard (p.3 The in Handout) Guide

The document provides instructions for three database exercises: 1) Creating a "Students" table using a wizard to select fields including StudentId, Name, and School. 2) Designing a "Division" table with fields DivisionId and Division. 3) Entering sample data into the Students, Grades, and Division tables, including student names and IDs, subject grades, and division names.

Uploaded by

Anonymous PcPkRpAKD5
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
70 views2 pages

Exercises Exercise1: Create Table by Using Wizard (p.3 The in Handout) Guide

The document provides instructions for three database exercises: 1) Creating a "Students" table using a wizard to select fields including StudentId, Name, and School. 2) Designing a "Division" table with fields DivisionId and Division. 3) Entering sample data into the Students, Grades, and Division tables, including student names and IDs, subject grades, and division names.

Uploaded by

Anonymous PcPkRpAKD5
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

EXERCISES

Exercise1: Create table by using wizard (p.3 the in handout)

Guide
1. Select Business (default) for the Table Category
2. Choose Students in the Sample Table Box
3. Select the following fields in the Sample Fields Box: StudentId, FirstName, MiddleName,
LastName and Address.
4. Rename the Address field to School.
5. Name the table Students.
6. Choose No, I’ll set the primary key.
7. Choose Numbers I enter when I add new record

Exercise2: Create table in Design View

1. Create table Division in Design View with the following fields and corresponding Data
Type: DivisionId : Autonumber and Division : Text.

2. Create table Grades with the following fields and corresponding Data Type:
For the fields TLE1 to TLE4 set Field Size to Double and Format to Fixed
Exercise3: Entering Data (p.4 the in handout)

1. Enter the following data in table Student ( Created using table wizard)

2. Enter the following data in table Grades (Created in Design View)

3. Enter the following data in table Division

You might also like