Introduction to Microsoft Access

Learning Outcomes: Students should be able to:

a. state the usage of application
b. list example which application of database is used
c. state the function of the features in database
d. create a new database

Knowledge and Skills:

a. Students known the meaning and usage of database
b. Start Microsoft Access 2003
c. Create, Name and Save database file
d. Open existing database
e. Exit database application

Module Summary:
At the end of the module, students should be able to open, name, save file and close database.

Activity Summary: Activities involved:

a. Starting Microsoft Access 2003
b. Naming and saving file database
c. Opening existing database


Activity 1: Starting Microsoft Access 2003

There are two methods to start / launch your Mircosoft Access 2003.

Method 1:

1. Double click on the Mircrosoft Office Access 2003 shortcut on the Windows desktop (see below).




Method 2:

1. Click-on the Start button, then click-on Programs, then click-on Microsoft Access
2003 (Figure 1)



2. The following Access 2003 Getting Started Task Pane will appear on the right side of your Access 2003 screen. (refer figure 2)

3. In the Open area of the Access 2003 Getting Started Task Pane, click the left mouse button on Create a new file.

Activity 2: To Name and Save Database File

1. The New File menu screen on the top will appear when you click the left mouse button on Create a new file.

2. Click–on Blank database. (Figure 3)



Introduction to Microsoft Access 2003

A File New Database menu screen, similar to the one below, will be on your screen. We’ll have to do several “things” to set-up this screen to save your database. ( Figure 4 )



3. Click-on the small down arrow on the right. Choose My Documents to save by double clicking on the folder. Your selection should now appear in the Save in : area. (Step 1)

4. Next click-in the area to the right of File Name. Type-in the word students profile as shown at the bottom of the above image. (Step 2)

5. Now click-on the Create button. (Step 3)

The following Students Profile: Database menu screen will appear.
( Figure 5 )

6. Click File and click Exit to end this session and to close Ms Access 2003.


Activity 3: Open Existing Access Database

There are two methods to open existing database.


Method 1:

1. Repeat Activity 1 to open Ms Access 2003. Once you have created a database, you will see your database in the Open portion of the Task Pane.

2. Click students profile. (refer Figure 6)

Method 2:

1. Click File in the Menu Bar, then click Open. (refer figure 7)

2. When the Open menu screen appears, click the small down arrow to the right of the Look in area and select My Documents.

3. Then click the name of your database (e.g. students profile.mdb) and then click Open.

Note:
You will notice in the Students Profile: Database menu screen, in the left border consist of objects bar: Tables, Queries, Forms, Report, Pages, Macros and Modules.

There are 4 important objects as stated in the table below.

Objects Bar Function
Table A collection of records that identify a category of data, such as Customers, Orders, or Inventory. Data inside a table is arrange by column name field and row named Record.
 Field – A single characteristic or attribute of a person, place, object, event, or idea.
 Record – A set of related field values.
Form Use to enter new information, to edit or remove existing information or to locate information.

Query Used to locate information, to view, change or analyze it in various ways. A select query retrieves data from one or more tables and displays the result in datasheet. A select query can be used to group record and calculate sums, counts, averages and other types of totals.

Report Typically used to summarize, organize and analyze information in order to express a particular point of view to specific audience.

4. Click File and Exit to stop this session.


At the end of this activities, you had learned how to:

i. Create a database
ii. Close a database
iii. Open an existing database

Introducing Ms-Excel

Name of Module : Introduction to Microsoft Excel 2003

Learning Outcomes: The students should be able to:

1) State the steps to launch spreadsheet software
2) Launch a spreadsheet application
3) State and identify features in spreadsheet application and demonstrate
understanding of user interface State the main toolbars in spreadsheet
software
4) List icons in standard, formatting, formula and chart toolbars.
5) Create a new worksheet using spreadsheet software
6) Enter data into new worksheet
7) Copy, Cut, Paste and Delete data
8) Save the worksheet

students should be able to:

1) State the steps to launch spreadsheet software
2) Launch a spreadsheet application
3) State and identify features in spreadsheet application and demonstrate understanding of user interface State the main toolbars in spreadsheet software
4) List icons in standard, formatting, formula and chart toolbars.
5) Create a new worksheet using spreadsheet software
6) Enter data into new worksheet
7) Copy, Cut, Paste and Delete data
8) Save the worksheet


Activity 1: Launch Microsoft Excel


1. Click Start button at the Task Bar

2. Click All Programs

3. Click Microsoft Office to open Microsoft Excel application.

Activity 2: Introduction to MS Excel window.

Main menu consist of 9 commands (File, Edit, View, Insert, Format, Tools, Data, Window and Help) which is the first letter of the commands word was underline. Otherwise you can open all of the commands word with enter ALT + letter .
Example, enter ALT + F to open menu File.


The figure below shows the cell A1, (column A and row 1)

Activity 3: Open Worksheet MS Excel 2003

1. Creating Worksheet

(i) Click File at a main menu after that click New. The dialog box will appear. (ii) One new worksheet with name Book1 will open in a screen.

Activity 4: Entering Data

1. Enter a title in cell A1.

(a) Click cell A1.
(b) Type a title “KOPERASI SEKOLAH MENENGAH KEBANGSAAN BANDAR BARU”.
(c) Press Enter key.

2. Enter a text in cell A2, “JALAN LOMBONG, KOTA TINGGI”
cell A3, “JOHOR”

Note : Follow step 1

3. Enter text below

In cell A5, type “Customer “
In cell A6, type “Name:“
In cell B6, type “Computer Club “
In cell D6, type “Invoice Number: “
In cell E6, type “G1085 “
In cell A8, type “Address : “
In cell B8, type “SMK Bandar Baru “
In cell D8, type “Date “
In cell E8, type “8.9.05 “
In cell B9, type “Jalan Lombong, Kota Tinggi “
In cell B10, type “Johor“
In cell D10, type “L/O Number:“
In cell E10, type “12345 “

Your screen will be shown below.

5. Continue the next activity to save your workbook.

Activity 5: Save A Workbook

Use the Save or Save As command in File on the bar menu to save the document for the first time. There are few options to save your document. You can choose either one.

1. Save in My Document

The following examples shows how you can save a new document that you have open in Activity 1 in Floppy disk. This document will be saving as try.xls in My Document folder.

a. Click File on the bar menu.

b. Click Save As, then the Save As dialog box will appear.

c. The document will be save as try.xls file in My Documents folder

Microsoft Word

Introduction
Introduction To Microsoft Word
What is Microsoft Word?
- Popular word processing software developed by Microsoft Corporation.
- It is used to create document such as report, letter, memo, flyers etc.
- Examples of word processing are Microsoft Word, Corel WordPerfect, Lotus
Word Pro.
- File extension for Microsoft Word is .doc


Start a Program
1. Click on the Start button on the Windows Taskbar. The Start menu will
appear.
2. Click on the All Programs  Microsoft Office  Microsoft Office Word 2007.

The Initial Screen
- When you first open MS Word, the following screen is displayed.

Screen Layout


Menus
There are three features that you should remember as you work within Word 2007:
the Microsoft Office Button, the Quick Access Toolbar, and the Ribbon.
The Microsoft Office Button





· create a new document
· open an existing document
· save or save as
· print
· send (through email or fax)
· publish
· close.


The Ribbon







It has seven tabs: Home, Insert, Page Layout, References, Mailings, Review, and
View that contain many new and existing features of Word. Each tab is divided into
groups. The groups are logical collections of features designed to perform functions
that you will utilize in developing or editing your Word document. Commonly used
features are displayed on the Ribbon, to view additional features within each group,
click on the arrow at the bottom right of each group.



Each of the tabs contains the following tools:
Home : Clipboard, Fonts, Paragraph, Styles, and Editing.
Insert: Pages, Tables, Illustrations, Links, Header & Footer, Text, and Symbols
Page Layout: Themes, Page Setup, Page Background, Paragraph, Arrange
References: Table of Contents, Footnote, Citation & Bibliography, Captions, Index,
and Table of Authorities
Mailings: Create, Start Mail Merge, Write & Insert Fields, Preview Results, Finish
Review: Proofing, Comments, Tracking, Changes, Compare, Protect
View: Document Views, Show/Hide, Zoom, Window, Macros


Quick Access Toolbar






Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access
toolbar provides you with access to commands you frequently use. By default Save,
Undo, and Redo appear on the Quick Access toolbar. You can use Save to save your
file, Undo to rollback an action you have taken, and Redo to reapply an action you
have rolled back.


The Ruler
The ruler is found below the Ribbon.




The Text Area
You type your document in the text area. As you type, your text displays at the
cursor location.


The Status Bar
The Status bar appears at the very bottom of your window and provides such
information as the current page and the number of words in your document. You can
change what displays on the Status bar by right-clicking on the Status bar and
selecting the options you want from the Customize Status Bar menu. You click a
menu item to select it. You click it again to deselect it. A check mark next to an item
means it is selected.






Learning Outcomes:

By the end of the lesson, students should be able to:
· Create A Document
· Format Text
· Format Paragraph
· Insert Header And Footer
· Insert Column
· Insert Pictures/Clip Art/Word Art
· Insert Page Number
· Insert Border
· Insert Table
· Insert Drop Cap
· Insert Bullets
· Insert Footnote


1. Create new document

a. Open Word 2007.
b. Click the Microsoft Office button. A menu appears.
c. Click New. The New Document dialog box appears.
d. Click Blank Document.
e. Click Create. A new blank document opens.


2. Format text

a. Select the text and click the Font Styles included on the
Font Group of the Ribbon, or
b. Select the text and right click to display the font tools.



3. Format paragraph

a. Click the Home Tab.
b. Choose the appropriate button for alignment on the Paragraph Group.
c. Click the Indent buttons to control the indent.
d. Click the Indent button repeated times to increase the size of the indent.
e. Click the dialog box of the Paragraph Group
f. Click the Indents and Spacing Tab
g. Select your indents.


4. Insert header and footer

a. Click the Insert Tab on the Ribbon
b. Click Header or Footer
c. Choose a style
d. The Header/Footer Design Tab will display on the Ribbon
e. Choose the information that you would like to have in the header or footer (date,
time, page numbers, etc.) or type in the information you would like to have in the
header or footer


5. Insert column

a. Position your cursor where you would like to insert the columns
b. Open the Page Layout ribbon
c. In the Page Setup section, click Columns
d. From the dropdown menu,select the number of columns you’d like to insert
e. Word will automatically insert the columns in your document.

6. Insert Pictures/Clip Art/WordArt

a. Place your cursor in the document where you want the illustration/picture
b. Click the Insert Tab on the Ribbon
c. Click the Picture Button
d. Browse to the picture you wish to include
e. Click the Picture
f. Click Insert


7. Insert Page Number

a. Choose the Insert tab.
b. Click the Page Number button in the Header & Footer group. A menu appears.
c. Click Bottom of Page.
d. Click the right-side option.


8. Insert Border

a. Select the area of text where you want the border or shading.
b. Click the Borders Button on the Paragraph Group on the Home Tab
c. Choose the Border and Shading
d. Choose the appropriate options


9. Insert Table

a. Place the cursor on the page where you want the new table
b. Click the Insert Tab of the Ribbon
c. Click the Tables Button on the Tables Group. You can create a table one of four
ways:
- Highlight the number of row and columns
- Click Insert Table and enter the number of rows and columns
- Click the Draw Table, create your table by clicking and entering the rows and
columns
- Click Quick Tables and choose a table


10. Insert Drop Cap

a. Click the Insert tab.
b. Then click Drop Cap button.
c. Then select the Drop Cap style you want.


11. Insert Bullets

a. Select the words you just typed.
b. Choose the Home tab.
c. In the Paragraph group, click the down arrow next to the Bullets button . The
Bullet Library appears.
d. Click to select the type of bullet you want to use. Word adds bullets to yourlist.


12. Insert Footnote

a. Click the References Tab on the Ribbon
b. Click Insert Footnote or Insert Endnote depending on your needs)
c. Begin typing the footnote


Enhancement

Quiz:


1. A message will appear if you attempt to edit a cell in a worksheet that has been
protected.
a.True b.False

2. What command keeps the titles of a worksheet on the screen no matter where the
highlight is moved?
a. Copy command b.Freeze Panes command c.Protection command d. Paste command

3. How are columns identified in a worksheet?
a.by numbers, 1,2,3,4, etc. b.by letters, A,B,C,D, etc.
c.by special characters, @, &, *, /, etc. d.none of these are correct

4. An operator is a number or cell reference used in formulas.
a. True b. False

5. To select a group of cells, click each cell individually until all cells in the
range have been selected.
a. True b. False

6. You can only place a border around one cell.
a.True b.False

7. The Clear command in the Edit menu can be used to remove the contents of a cell.
a.True b.False

8. Cutting and pasting is used in Excel to perform what process?
a.Copying text b.Moving text
c.Deleting text d.None of these are correct

9. If you copy data into cells already containing data, the existing data will be
added to the copied data.
a.True b.False

10. When using the Delete Row command, the row above the highlight will be deleted.
a.True b.False