Wednesday, July 23, 2014

Getting Started with MS Excel 2003

            Start Menu >> All Programs >>Microsoft-Office>> Microsoft Office MS Excel 2003
Or
  1. Click on the Start button from the Task bar
  2. Select All Programs From the Start button.
  3. Select All Programs and Click on the Microsoft Office and Choose the Microsoft Office Excel 2003
      The screen as shown in figure appears with a blank workbook opened.

Creating a New Blank Database

Creating a New Blank Database on MS-Access 2003

1. Select File menu and click on the New.
2. Click on the Blank database.
3. File New Database box will be appears.
4. In the File New database give File name: db2 (new database)
5. Click on the Create button.
6.  The New Database db2 is created on the MS Access.

Creating a New Blank Database

Creating a New Blank Database on MS-Access 2003

1. Select File menu and click on the New.
2. Click on the Blank database.
3. File New Database box will be appears.
4. In the File New database give File name: db2 (new database)
5. Click on the Create button.
6.  The New Database db2 is created on the MS Access.

AUTO SAVE IN MS WORD

1. Select The File Menu and Choose Save As.
2. Click On The tools and Select Save As option .
3. In Save click on the Save Auto Recovery into every--- Minute and
4. Getting the timing as you want to save your document.
5. Click on the OK button
6. Click on the Save button.

Create Table by Using Wizard

Create Table by Using Wizard -
1. Select File menu and Choose New.
2. Click on the Blank Database.
3. In File New Database – File name db1 Create.
4. Double Click on the table Using Wizard Option.
5. The Table Wizard dialog box appears
6. Choose a table Business or Personal.
7. Select the fields that you want to include in your table and click on the > button. This Step for all the fields that you choose. You would notice that all these field has been added to your new table.
8. If you need to delete any field in your new table, then Select the field you to delete and Click on the < Button, that field will no longer be present in the New Table.
9. Click on the Next button.
10. In Table Wizard, you want to name your table.
11. And Set a Primary key or not. (A Primary Key is a field that uniquely identify a Record)
12. Click on the Next button.
13. Click on the Finish button.
14. Now Create a Table.
15. Now Right Click on the table and Select Deign View.

Creating Table in Design View

1. Click on the File menu and Select New.
2. Click on the Blank Database.
3. In File New Database, File name db1  Create.
4. In Tables, Create table in Design View.
5. In Table1:Table, File Field Name and Datatype.
6. Close Table1: Table
7. Do you want to save changes to the design of table’Table1’?
8. Click on the Yes
9. In Save As get Table Name Table1 OK.
10. If You Want a primary Key.
11. Click on the yes.
12. Now Create a Table in Design View.
13. Now Right Click on the Table1 and Select Design view.


Creating a Form by Using Wizard

1. Select File Menu and Choose New.
2. Click on the Blank Database.
3. In File New Database- File Name db1 Create.
4. Click on the Create Button.
5. In db1 database, Choose Forms and Create form by Using Wizard.
6. Double Click on the Create Form by Using Wizard.
7. In Creating Form You must have at least one table to use this wizard.
8. In Form Wizard, You can Choose a table or more than one table.
9. Click on the Next button
10. In Form Wizard, Select  a layout would you Like From your Form.
11. Click on the Next Button.
12. In Form Wizard, Select a Style Would You Like.
13. Click on the Next Button.
14. In Form Wizard, Give a Title You to Your Form.
15. Click on the Finish Button.

Macro

1. On the Tools Menu, Select Macro and Click on the Record New Macro.
2. In Record Macro: Type a Name for the Macro.

3. And Assign Macro to Toolbars or Keyboard.
4. To Assign the Macro to Toolbars, Click On the Toolbars and Click Command Tab.

5. Click on the Close Button to Start Recording Macro
6. Click on the Close Button to Start Recording Macro.
7. To Assign the Macro in Keyboard, Click on the Ok Button.
8. In Customize Keyboard, Press New Shortcut key.
9. Click on Assign Button.

10. Click on the Close button to Start Recording to Macro.

11. Now Perform your action to Include in Macro.
12.To Stop Recording Macro, Click on the Stop Recording.

13. For Running Macro Press  Shortcut keys.

Create a Macro in MS Excel 2003

1. On the Tools Menu, Select Macro and Click on the Record New Macro.
2. In Record Macro: Type a Name for the Macro,  Get a Shortcut Key Ctrl + __
3. Click on the OK Button.
4. Now Perform your  action to Include in Macro.
5. To Stop Recording Macro, Click on the Stop Recording.
6. And then Run Your Macro

Some Important Shortcut Keys

To Press
NewCtrl + N
OpenCtrl + O
SaveCtrl + S
PrintCtrl + P
CutCtrl + X
RedoCtrl + Y
UndoCtrl + Z
CopyCtrl + C
Select AllCtrl + A
PasteCtrl + V
FindCtrl + F
ReplaceCtrl + H
FontCtrl + D
BoldCtrl + B
ITALICCtrl + I
Under LineCtrl + U
Right AlignmentCtrl + R
Center AlignmentCtrl + E
Left AlignmentCtrl + L
Justify AlignmentCtrl + J
Increase Font SizeCtrl + ]
Decrease Font SizeCtrl + [
HelpF1
Go toF5
Spelling and Grammar CheckingF7
ResearchAlt + CLICK
Task PaneCtrl + F1

Find and Replace

To Find Text -
1. On the Edit Menu, Choose Find…
Or
2. Press Ctrl + F.
3. The Find and Replace Dialog box appears.
4. In the Find What: Type the text or special characters in the text box, you want to search for.
5. Click the More button to display more search options.
6. Click on the Find Next button.
7. Click on the Close button to close the Find and Replace dialog box.
Or
8. Press Esc Key.
To Replace Text –
1. On the Edit Menu, Choose Replace…
Or
2. Press Ctrl + H.
3. The Find and Replace Dialog box appears.
4. Click the Replace tab.
5. In the Find what: Type your text that you want to replace.
6. In the Replace with: Type the new text in the text box.
7. Click on the Replace or Replace All Button.
8. Click Cancel or Press Esc Key..

Display the Status Bar

Display the Status Bar-
1. Click The Tools menu and choose Options…
2. In Option, Click on the View tab.
3. In View tab property, Click on the Status bar Check box.
4. Click on the OK Buton.
5 The Status bar is displayed.

OFFICE ASSISTANT

To Show the Office Assistant -
1. Choose Help Menu from the Menu bar and Select Show the Office Assistant.
2. The Office Assistant Show.
3. Double Click on the On Screen Office Assistant.
4. In What Would You Like to do, Type Your Question in the Text Box.
5. Click on the Search Button.
6. In Options, Click on the Option Button.
7. The Office Assistant dialog box appears
8. In Options, Click on the Options what you want to do.
9. And Click on the OK Button.
10. In Gallery, You can Find Different Type of Assistants by Using Back and Next Buttons.
11. Now you can Select Your Assistant.
12. And Click on the OK Button.

To Hide Office Assistant -
1. Right Click of the On Screen Office Assistant and Select Hide Option.
Or
2. Choose Help Menu From the Menu Bar and Click on the Hide the Office
Assistant.

To Insert Page Numbers

1. Click on the Insert Menu from the Menu Bar and Select Page Numbers.
2. In Page Numbers, Select Your Position: Top of the Page (Header) or
Bottom of Page (footer).
3. And Select Alignment: Left, Center, and Right, Inside or Outside.
4. Click on the OK Button.
5. In Page Numbers, Click the Format.
6. Page Number Format Dialog Box appears.
7. In Page Number Format, You can find Different Types of Numbers Format
by Using Drop down List.
8. By Clicking, Include Chapter Number, Chapter Starts with Different Style
and Use Different Separator.
9. And Page Number is Start with Continues from Previous Session or Start at
New Session as you required
10. Click On the OK Button.

To Insert the Clip Art

1. Click on the Insert from the Menu Bar.
2. Select Picture and Click on the Clip Art.
3. In The Clip Art Task Pane, For Selected Collections in the Search Box- Type a Word in the Search Box.
4. Do you want to Clip Art  Search.
Or
5. In The Clip Art Task Pane, Selected All Collections in the Search in Box.
6. In the Result should be box,  You can select different type of media file.
7. Click on the GO Button
 Or
1. Click on the Insert Clip Art  From The  Drawing Tool Bar.


HELP

1. Select Help Menu from the Menu Bar and Click on the Microsoft Office Word
Help F1.
Or
2. Press F1 Function Key.
Or
3. Click on the Microsoft Word Help   Button on the Standard tool bar.
4. In what would you like to do, Type your question in the text box.
5. Click Search.
Or
6. Choose Help Menu from Menu bar and Click on the Show the Office Assistant.
7. The Office Assistant Window appears.
Or
8. Double click on the On Screen Office Assistant.
9. In what would you like to do, Type your question in the text box.
10. Click on the Search Button.
Or
11. Select Help Menu from the Menu Bar and Click on the Microsoft Office
Online..

To Hide Office Assistant –
1. Right Click of the On Screen Office Assistant and Select Hide Option.
Or
2. Chose Help Menu from the Menu Bar and Click on the Hide the Office
Assistant.

WORD ART

1. Click on the Insert Word Art   from Drawing Toolbar.
Or
2. Click on the Insert Menu from Menu Bar and Select Picture and Choose WordArt.
3. In WordArtGallery, Select a Word Art Style -
4. Click on the OK Button
5. The Edit Word Art Text Dialog Box appears.
6. In Edit Word Art Text, Type Your Text in the Text Box.
7. Click on the OK Button.
8. In Edit Word Art Text, You can Change your Font Style from the Font.
9. In Edit Word Art Text, You can Change your Font Size from the Size
10. In Edit Word Art Text, You can you can make your text Bold
11. In Edit Word Art Text, You can you can make your text Italic
12. Click on the OK Button.

Creating Query By Using Query Wizard

1. In db1 database, Select Queries and Double Click on the Create query by using Wizard.
2. In Simple Query Wizard, Select Field do you want.
3. Click on the Next Button.
4. In Simple Query Wizard, Given Title on your query.
5. Click on the Finish Button.
6. Right Click on the Query and Select Design View.
7. Now Select Query do you want.
8. Save your query and Click on the OK button.
9. Now Open your query.

Creating Pages by Using Wizard

1. Open your db1.mdb Database.
2. Select Pages Tab on the Left Side of Database Window.
3. Select Create data access Page by using Wizard.
4. Double Click on the Create database access by using wizard.
5. In Page Wizard, Select Field do you want.
6. Click on the Next Button.
7. In Page Wizard, Select Your Grouping Levels.
8. Click on the Next Button.
9. In Page Wizard, You can Sort your Record in Ascending or Descending
Order.
10. Click on the Next Button.
11. In Page Wizard, Given a Title on your Page.
12. Click on the Finish Button.
13. Now Save your database Access page.
14. Click on the Save button.
15.Your Pages is Created
16. Now Right Click on the Pages and Select the Web Page Preview.
Subscribe to: Posts (Atom)