COMPUTER STUDIES ICT JSS 3 FIRST TERM LESSON NOTES PLAN
FIRST TERM E-LEARNING NOTES
JSS 3 (BASIC 9)
SUBJECT: COMPUTER SCIENCE
SCHEME OF WORK
WEEK TOPICS
Second period: (c) Uses of Search Engines
First & Second Period: Practical uses of search engine
make all the search engines diagram in this week)
First & Second Period:(a) Concept of digital divide
(b) Database Terminologies (i) Fields (b) Records (iii) File (iv) Database (v) Key etc
c) Forms of Database: (i) Flat file (ii) Hierarchical (iii) Relational etc
DATABASE PRACTICAL (MS ACCESS)
Starting and opening and existing database
Sub-Topic 1: PRACTICAL
Starting MS Access
Unlike a word processing or spreadsheet document, which you can name after you have started or completed it, a database has to be named before any work is started on it.
- Click on the Start
- Select All Programs.
- Select Microsoft Office and then Microsoft Office Access.
- Check for New Blank Database and then click on ‘Blank database’.
- Type a name for your database into the ‘File Name’, box.
- 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:
- Datasheet view
- Design view
- Table wizard
Creating a table in Datasheet view
- Open the database.
- Click Create
- Click Table Design Tab
- Enter Field Names and Data Type g. Surname, Middle name, Last Name etc
- Save table,
- (A prompt for primary key pops out, click No for now)
- Click View
|
- Select Datasheet view.
Am a dedicated educator with a passion for learning and a keen interest in technology. I believe that technology can revolutionize education and am committed to creating an online hub of knowledge, inspiration, and growth for both educators and students. Welcome to Edu Delight Tutors, where learning knows no boundaries.