SS3 First Term Computer Studies Lesson Note – Database II

The content is just an excerpt from the complete note for SS3 First Term Computer Studies Lesson Note – Database II. Check below to download the complete DOCUMENT

WEEK 9                                                                      

DATABASE (Cont’d)

CONTENTS

• Creating database
• Basic Operation

Sub-topic 1

Creating Database

A new database can be created in two ways:

• By using the DBMS wizard
• By creating a blank database using the DBMS tools.

Using the DBMS wizard

Load MS Access from the start button. The new file task pane will be displayed as shown below:

1. Click on the Start
2. Select All Programs.
3. Select Microsoft Office and then Microsoft Office Access.
4. Check for NewBlank Database and then click on ‘Blank database’.
5. Type a name for your database into the ‘File Name’, box.
6. Click Create and you are in Access environment

When working in Access, you make use of tables. Tables are the most important object in the database.

To create a table, you can use any of the following methods:

1. Datasheet view
2. Design view
3. Table wizard

Creating a table in Datasheet view

1. Open the database.
2. Click Create
3. Click Table Design Tab

To gain full access to the note: DOWNLOAD FILE