Creating a New Database

(1)

Creating a New Database

A. Starting Microsoft Access 2000

1. From the Desktop, click the Start button to display its menu items.

2. Click to select Microsoft Access from the Programs menu.

B. Creating a New Database

1. In

the

Microsoft Access dialog box, click to select the Blank Access database

option.

2. Click

the

OK button.

3. In

the

File New Database dialog box, move to the desired directory (e.g., A:).

4. In

the

File name text box, replace db1 with ITClass.

5. Click

the

Create button.

1. Click the Blank Access database option.

2. Click the OK button.

3. Move to the desired directory (e.g., A:).

4. Replace db1 with

ITClass. 5. Click the Create

(2)

C. Creating a New Table

1. Click to select the Tables object if necessary.

2. Double-click

the

Create table in Design view option.

3. In

the

Table1: Table dialog box, enter StudentID in the first Field Name text box,

and then press the Tab key to move to the Data Type text box.

4. Leave

Text unchanged for Data Type.

5. Change

the

Field Size from 50 to 8.

1. Click to select Tables if necessary.

2. Double-click Create table in Design view.

3. Enter StudentID here.

4. Leave Text unchanged for Data Type.

(3)

6. Similarly, create two more fields with the structure below:

Field Name

Data Type

Field Size

Name Text

20 Class Text

2 7. Enter

ClassNo as the fourth field.

8. In

the

Data Type text box, click the Down arrow to display the drop-down list.

9. Click to select Number for Data Type.

6. Create two more fields:

Name and Class.

7. Enter ClassNo here.

8. Click the Down arrow to display the drop-down list. 9. Select Number

(4)

10. Change the Field Size from Long Integer to Integer.

11. Create five more fields with the structure below:

Field Name

Data Type

Field Size

Birthday Date/Time

-

Address Text

30 Hobby Text

50 SAMember Yes/No

-

Remarks Memo

-

10. Select Integer from the drop-down list.

11. Create the Birthday, Address,

Hobby, SAMember, and Remarks

(5)

D. Setting the Primary Key Field

1. Click on the box to the left of the StudentID field to select the entire row.

2. Click

the

Primary Key button on the Toolbar to set the StudentID field as the

primary key.

E. Saving the Table

1. Click

the

Save button on the Toolbar to save the Table.

2. In

the

Save As dialog box, replace Table1 with Students.

3. Click

the

OK button.

1. Click here to select the row.

2. Click the Primary Key button on the Toolbar.

1. Click the Save button on the Toolbar.

2. Replace Table1 with

Students.

(6)

F. Closing the Table in Design View

1. Click

the

Close box of the Students: Table window to close the Students Table in

Design View.

G. Entering Data in Datasheet View

1. Click to select the Tables object if necessary.

2. Double-click

the

Students table to open it in Datasheet View.

Click the Close box to close the Students: Table window in Design View.

1. Select the Tables object if necessary.

(7)

3. Click

the

Maximize box to expand the Students: Table window.

4. Enter the following data in the Students table in Datasheet View.

StudentID Name Class ClassNo Birthday Address Hobby SAMember Remarks 19980123 Andrew 4A 1 1986/04/23 Homantin Basketball, Eating No

19981034 Ann 4A 2 1986/07/11 Mongkok Reading, Sleeping Yes 19981031 Anthony 4B 1 1986/01/19 Homantin Running, Hiking,

Swimming Yes Monitor 19980029 Betty 4B 2 1986/12/13 Homantin Music, Singing,

Reading Yes

19980998 Carol 4A 3 1986/10/08 Mongkok Reading Yes Monitor 19980366 Catherine 4B 3 1986/03/14 Mongkok Roller skating,

Skipping

No 19980115 Jack 4A 4 1985/08/22 Tuen Mun Singing, Running Yes Prefect 19981002 Jacob 4B 4 1986/04/23 Homantin Eating, Reading Yes

19980333 Jane 4A 5 1986/10/29 Tsuen Wan Skipping, Eating Yes 19980246 Joseph 4B 5 1986/03/23 Shatin Cycling, Running,

Swimming, Reading Yes Prefect 3. Click the Maximize box to

expand the Students: Table window in Datasheet View.

The dates should be entered in the order of Year/Month/Day (e.g., 1986/04/23).

Click to put a check mark in the box to indicate the option Yes. Click again to remove the check mark.