Categories: Lesson Notes

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

Sunday

Share
Published by
Sunday

Recent Posts

List of Universities Offering Veterinary Medicine in Nigeria

Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…

3 months ago

List of Universities Offering Anthropology in Nigeria

Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…

3 months ago

List of Universities Offering Sociology in Nigeria

Sociology is the scientific study of human society, culture, and behavior. It examines the social…

3 months ago

List of Universities Offering Social Work in Nigeria

Social Work is a profession dedicated to helping individuals, families, and communities to cope with…

3 months ago

List of Universities Offering Religious Studies in Nigeria

Religious studies is an academic discipline that explores the beliefs, practices, and history of various…

3 months ago

List of Universities Offering Public Administration in Nigeria

Public administration is the field of study and practice that focuses on the organization and…

3 months ago